-
Using CROSS APPLY instead of a calculated variable
Leave a commentMay 22, 2013 by Kenneth Fisher
Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working …
Continue reading -
The many uses of CROSS APPLY
1May 20, 2013 by Kenneth Fisher
Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY. In the …
Continue reading -
CREATE SCHEMA can do what?!?!?
3May 15, 2013 by Kenneth Fisher
So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t …
Continue reading -
Dragging a name from the object explorer to a query window
5May 13, 2013 by Kenneth Fisher
In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that …
Continue reading -
Free SQL Books
4May 8, 2013 by Kenneth Fisher
I was looking for a way to put BOL on my Kindle when I found a few good links I …
Continue reading -
GO
2May 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
10May 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
2May 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
Leave a commentApril 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
SQL Studies
My SQL Studies
