Tag Archives: microsoft sql server
-
Tales of a DBA fed up with NOLOCK. Part 2
8February 23, 2015 by Kenneth Fisher
Feb 16, 2015 Dear Diary, A few weeks back I introduced HAL002 to a database managed by some annoying devs. …
Continue reading -
Test your UPDATEs and DELETEs before you run them
15February 18, 2015 by Kenneth Fisher
This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you …
Continue reading -
Dealing with layered function calls
5February 5, 2015 by Kenneth Fisher
T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are …
Continue reading -
TSQL Tuesday #63 – How do you manage security?
26February 3, 2015 by Kenneth Fisher
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought …
Continue reading -
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 -
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
SQL Studies 