The Query Store is a feature that helps you evaluating query performance. It captures execution information asl well as up to 200 plans for a single

case when len( ROW_NUMBER() OVER( PARTITION BY left(replace(name,' ',''), 3) + left(replace(addrsscty,' ',''),3) ORDER BY left(replace(name,' ',''),

The title says it all, but let me expand on this a little bit. I have an assembly that I wanted to emulate in SQL server. The first, obvious choice

This blog post here on BI Developer Network contains a nice list on data conversion between SSIS and SQL server, something that gets my blood pressure

I ran into some 'Message 823' issues on my development DB, and upon running DBCC CheckDB() I saw that my indexes were the ones throwing the errors.

I will make this short and sweet for you. If there is something you want to do to all tables in your database, there is a command for you. I wil

So our aggregated databases have experienced some loading errors lately, and until that gets fixed, I have to collect the data straight from the field

I stumbled upon this great Q+A on Stack Overflow when I was looking for options to cast datetime for a report. (The customer didn't like our standard

And I realize I was the one who launched those procedures