Category Archives: Microsoft SQL Server
-
GO
6May 6, 2013 by Kenneth Fisher
Did you know that the GO command isn’t really part of T-SQL? It’s what’s called a batch separator. And in …
Continue reading -
Comparing an inner join vs a subquery
12May 2, 2013 by Kenneth Fisher
I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing …
Continue reading -
Well I finally passed the 70-451
7May 1, 2013 by Kenneth Fisher
So I am now an MCITP Database Developer for SQL 2008. This is a big milestone for me. A few …
Continue reading -
INFORMATION_SCHEMA the un-sung system views
13April 29, 2013 by Kenneth Fisher
I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others. …
Continue reading -
How do I tell the stored procedure name from inside the stored procedure?
1April 24, 2013 by Kenneth Fisher
I’ve occasionally had the problem of trying to put “smart” logging messages into a process. You know the ones, you’re …
Continue reading -
Calculating the length of a string (Len vs DataLength)
3April 14, 2013 by Kenneth Fisher
This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers …
Continue reading -
How do I use a variable in an IN clause?
16April 8, 2013 by Kenneth Fisher
I see this question in one form or another a lot. I’ve seen this or something like it probably half …
Continue reading -
UNPIVOT a table using CROSS APPLY
23April 1, 2013 by Kenneth Fisher
I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already …
Continue reading -
Using Templates
3March 18, 2013 by Kenneth Fisher
Templates are one of those really handy tools that most DBAs I know of have either never heard of or …
Continue reading
SQL Studies 