Tag Archives: language sql
-
How I like to learn a t-sql command
11January 7, 2013 by Kenneth Fisher
Recently I received a security request and realized I wasn’t comfortable in my ability to script out the t-sql commands …
Continue reading -
Red errors in the results pane
3December 19, 2012 by Kenneth Fisher
Most DBAs have seen those nice clear red errors in the results pane. And I’m sure most DBAs have noticed …
Continue reading -
Generating multiple SQL statements from a query
2December 17, 2012 by Kenneth Fisher
Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can …
Continue reading -
Creating an empty table from a SELECT statement
12November 26, 2012 by Kenneth Fisher
I’m in the middle of reading a good book on DMVs, “SQL Server DMVs in Action” http://www.manning.com/stirk by Ian W. …
Continue reading -
CTEs beyond SELECT
5November 20, 2012 by Kenneth Fisher
The other day I was writing a query to pull some DMV information and I ended up using several CTEs …
Continue reading -
keyword DEFAULT
5August 20, 2012 by Kenneth Fisher
In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and …
Continue reading
SQL Studies 