SQL Tips

I'm not a DBA, my Microsoft SQL skills are fairly basic, but I've collected a bunch of queries and ideas over the years that make my life a little easier.

Hopefully they are valuable to you too!

Updated: January 2017

• SQL Tips #1 - Table Row Counts & Sizes
• SQL Tips #2 - Searching for a specific field name in a SQL table
• SQL Tips #3 - Searching for a keyword in a stored procedure
• SQL Tips #4 - Listing all SQL databases with their file locations and sizes
• SQL Tips #5 - Listing the recovery model for each database
• SQL Tips #6 - Looking for tables with specific fieldtypes
• SQL Tips #7 - Which tables or stored procedures were updated recently