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 query. For a thorough overview on the Query Store you can read Enrico van de Laar’s article here. Query Store is also available for Azure since V12. To turn on Query Store […]
Let’s just say, it wasn’t a pretty piece of script.
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 will demonstrate, watch my hands because I cheat. To add a column to every table: exec sp_msforeachtable ‘alter table ? add intGoat int NULL’ To […]
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 databases for each report. That is, go in the database, pull the data, load into temp. Go in the next database, pull the data, load into temp. Go in next, […]
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 mm/dd/yyyy format.) I actually like the third answer the most, because it gives you a chart on all the styles. A pretty helpful shortcut, if you ask me. […]
And I realize I was the one who launched those procedures
And I pretend I totally understand the whole query plan
Tl;dr – SQL server 2008R2’s results to grid output truncates string values above 43,680. Conclusion: if half of your script is missing, it might still be there.
When the server ran out of both memory and disk space. On both drives.