Monthly Archives: January 2015
-
A quick email interview of Pass President Thomas LaRock
3January 28, 2015 by Kenneth Fisher
Back in December I had the thought that it would be fun to do an email interview with someone. As …
Continue reading -
SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC
1January 26, 2015 by Kenneth Fisher
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
Continue reading -
Constraint names, Say NO to the default
14January 21, 2015 by Kenneth Fisher
Have you ever seen a constraint with a name like PK__TableNam__EA185FBF8FF1529D? It’s kind of funny looking right? I mean it …
Continue reading -
Except and Intersect
7January 19, 2015 by Kenneth Fisher
EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in …
Continue reading -
Pagination in SQL Server
5January 15, 2015 by Kenneth Fisher
It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL …
Continue reading -
TSQL Tuesday #62: Invitation to Healthy SQL – Why Page Verify?
1January 13, 2015 by Kenneth Fisher
I don’t think anyone’s ever been happy to get a support call at 11pm on a Saturday night. However this …
Continue reading -
Finding the reason for the error “Subquery returned more than 1 value”
1January 7, 2015 by Kenneth Fisher
First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In …
Continue reading -
SQL Judo’s Monthly Challenge – January 2014 – Restore the Master
5January 5, 2015 by Kenneth Fisher
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
Continue reading