SELECT * pulls extra columns, hurts plans and makes debugging hard. This sixty second video shows two tricks to replace SELECT * with column names.
SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video
SSMS comes with many built-in performance and activity reports. This sixty second video shows where to find the Standard Reports and how to run them.
Filling Template Parameters in SSMS With Ctrl+Shift+M
Template parameters save you from typing one value in four places, but they only paste text. Here is what that means in practice.
SQL SERVER – Right Aligning Numerics in SQL Server Management Studio (SSMS)
Numbers in SSMS results are hard to read when they do not line up. Right aligning numerics takes one query option, and I show where to find it.
SQL SERVER – A Cool Trick – Restoring the Default SQL Server Management Studio – SSMS
Closed Object Explorer by mistake or moved windows around? Here is a cool trick for restoring the default SQL Server Management Studio window layout.
SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device.Operating system error 3 (The system cannot find the path specified.)
Got Msg 3201, Cannot open backup device, with operating system error 3? The folder in the backup path is missing. Create it and run the backup again.
SQL SERVER – Error: Deleting Offline Database and Creating the Same Name
Deleted an offline database but the disk is still full, or you get an error creating a database with the same name? Here is why, and what to do.