Monthly Archives: April 2015

April Blogger Challenge 4–Filtered Index Limitations

Posted on April 30, 2015 by

The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to motivate and cheer people on. Filtered Index Limits I ran across a limitation recently with filtered indexes and was surprised. … Continue reading →

Posted in Blog | Tagged , , , , | 1 Comment

Is It Time to Upgrade?

Posted on April 30, 2015 by

There was a post from the SQL Server Data Platform Advisor the other day that noted it’s been almost 10 years since SQL Server 2005 was released and it’s time to upgrade. At least, if you want to remain in support. Microsoft … Continue reading →

Posted in Editorial | Tagged ,

Altering a column to add NOT NULL

Posted on April 29, 2015 by

I had to do this recently and needed to look up the syntax as I couldn’t remember it. I don’t do this often, but I was working on a particular item and wanted to test this. I had a table, … Continue reading →

Posted in Blog | Tagged , | 2 Comments

Dig Out the Root Cause

Posted on April 28, 2015 by

Early in my career in technology, I worked as a system administrator on a Novell network. Periodically we’d have crashes of servers on our network, or application failures, and while we understood that sometimes these were caused by transient errors, … Continue reading →

Posted in Editorial | Tagged , | 1 Comment