Anna Hadnagy

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

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 s

When the server ran out of both memory and disk space. On both drives.