-
T-SQL Tuesday #47: Your Best SQL Server SWAG
1October 7, 2013 by Kenneth Fisher
It’s time for T-SQL Tuesday again and this time Kendal Van Dyke is asking for Your Best SQL Server SWAG. …
Continue reading -
Use TOP instead of SET ROWCOUNT
13October 7, 2013 by Kenneth Fisher
Both TOP and SET ROWCOUNT are both valid methods of limiting the result sets from a query. They are however …
Continue reading -
Filtering Object Explorer
3October 2, 2013 by Kenneth Fisher
I absolutely love learning new tricks that can be done in SSMS. Everything from opening initial connections to both the …
Continue reading -
The MERGE statement doesn’t have a WHERE clause.
5September 30, 2013 by Kenneth Fisher
What the heck? Even indexes have WHERE clauses these days. I can’t remember what I was reading when I saw …
Continue reading -
Detaching a database
1September 26, 2013 by Kenneth Fisher
In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL …
Continue reading -
DBA Myths: You can’t use an alias in a DELETE statement
3September 24, 2013 by Kenneth Fisher
Recently I wrote about the myth that you can’t use an alias in an UPDATE statement. You can of course, …
Continue reading -
sp_DBPermissions V2.0
1September 18, 2013 by Kenneth Fisher
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
Continue reading -
sp_SrvPermissions V2.0
1September 18, 2013 by Kenneth Fisher
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
Continue reading -
Brad Shultz’s blog on reviewing your database
1September 17, 2013 by Kenneth Fisher
This is possibly the best blog I have every read on the subject of reviewing a database. It is witty, …
Continue reading -
DBA Myths: You can’t use an alias in an UPDATE statement.
4September 16, 2013 by Kenneth Fisher
I’ve found a very common belief among users of T-SQL (both DBAs and Developers) is that you can’t use an …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 