Category Archives: Query Tidbits

Shrinking Transaction Logs

I see questions on forums all the time about DBA’s or System Admins finding they are out of drive space due to a very large transaction log.  Post vary a bit on what the admin has tried but a common … Continue reading

Posted in Query Tidbits, SQL Tuning, SQLServerPedia Syndication | Tagged , | 3 Comments

Listing Stored Procedures From Every Database

Recently I answered a question on AskSSC that I thought I would create a quick blog about.  Someone had asked if there was an easy way to run SELECT * FROM SYS.PROCEDURES on every database.  I immediately thought of the … Continue reading

Posted in Query Tidbits | Leave a comment

Using “NOT IN” in a query can provide mixed results

The topic came up at work awhile back with using various includes/excludes such as IN, NOT IN, and EXISTS.  A co-worker was working on an ETL process when he discovered that using “NOT IN” in a sub query with a … Continue reading

Posted in Query Tidbits | 1 Comment