Tag Archives: T-SQL
-
Query to compare indexes between two tables
Leave a commentOctober 16, 2013 by Kenneth Fisher
We have a set of databases at my office that use the load and swap method of loading data with …
Continue reading -
Why you should know how to script as well as use the GUI
Leave a commentOctober 14, 2013 by Kenneth Fisher
Personally I’ve always enjoyed learning the T-SQL for any given task. The GUI is usually pretty easy to figure out …
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 -
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 -
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 -
A T-SQL query to get current job activity
30September 5, 2013 by Kenneth Fisher
I recently had the task of collecting job activity for the purposes of turning it into a report for some …
Continue reading -
Lots of ways to UNPIVOT a table
Leave a commentAugust 21, 2013 by Kenneth Fisher
I recently read an awesome post on http://www.stackexchange.com questioning how to change columns to rows ie UNPIVOT. One answer demonstrated …
Continue reading
SQL Studies 