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: October 2019
- 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
- SQL Tips #8 - List Read and Write Counts per Table
- SQL Tips #9 - Listing Stored Procedures by Change Date
- SQL Tips #10 - Rebuilding Table Indexes Across Databases
- SQL Tips #11 - Rebuilding the Query Cache and Statistics
- SQL Tips #12 - Making a Default Date Rounded to an Hour
- SQL Tips #13 - Finding the Domain from an Email Address
- SQL Tips #14 - Clearing the Query Store
- SQL Tips #15 - How to use Coalesce
- SQL Tips #16 - Looping Through Records using Cursors
- SQL Tips #17 - Table Row Counts and Sizes in Gb
- SQL Tips #18 - Listing All Tables Without Any Indexes
- SQL Tips #19 - Listing All SQL Jobs on the Server
- SQL Tips #20 - Showing All Table Data for a Specified User
- SQL Tips #21 - Listing All Table Columns and Their Default Values
- SQL Tips #22 - A Function to Split a String
- SQL Tips #23 - A Function to Strip Numeric Characters
- SQL Tips #24 - Listing All Indexes and Their Fragmentation Percentage
- SQL Tips #25 - Rebuilding All Fragmented Table Indexes
- SQL Tips #26 - Getting the Field Types of Fields in a Table
- SQL Tips #27 - Finding Which Indexes Are Not Used
- SQL Tips #28 - Generating Random Numbers for Non-Crypto Usage
- SQL Tips #29 - A Function to Generate Random Numbers
- SQL Tips #30 - Listing Databases and Their CPU Usage
- SQL Tips #31 - Deleting Duplicate Entries While Keeping the Original
- SQL Tips #32 - Listing Recent Deadlock Victims
- SQL Tips #33 - Generating a Comma Separated List of Fields per Table
- SQL Tips #34 - Finding Tables with Missing Primary Keys
- SQL Tips #35 - Finding Tables with Missing Identity Fields
- SQL Tips #36 - Listing All Stored Procedures or Tables
- SQL Tips #37 - Listing All Stored Procedures Using a Specific Table
- SQL Tips #38 - Finding All Dependencies of a Stored Procedure
- SQL Tips #39 - Listing All Keys in a Database
- SQL Tips #40 - Finding Queries with Missing Indexes in the Query Store
- SQL Tips #41 - Listing the Restore Progress of Databases
