Performance tuning means understanding the query, finding the bottleneck and fixing it. This 60 second video shows how DB Optimizer speeds that up.
SQL SERVER – NuoDB in Sixty Seconds – SQL in Sixty Seconds #053
NuoDB in Sixty Seconds: this short video shows how to install NuoDB and set up a sample database in less than 60 seconds.
SQL SERVER – SQL in Sixty Seconds – Need Your Opinion
Though this may look very simple to you it is very crucial to me and I would like to know your opinion about it. I have included the latest video.
SQL SERVER – Puzzle SET ANSI_NULLS and Resultset – SQL in Sixty Seconds #052
I take my puzzle to the next level with SET ANSI_NULLS OFF. Why do two different queries now return almost the same results? Watch the 60 second video.
SQL SERVER – RESEED Identity Column in Database Table – Rest Table Identity Value – SQL in Sixty Seconds #051
Episode 51 of SQL in Sixty Seconds shows how to RESEED identity column values to a number higher, or even lower, than the current one.
SQL SERVER – Remove Cached Login from SSMS Connect Dialog – SQL in Sixty Seconds #049
Old server names clutter the SSMS Connect dialog. This SQL in Sixty Seconds video shows how to remove cached login entries in SQL Server 2012 and earlier.
SQL SERVER – Enable SQLCMD Mode in SSMS – SQL in Sixty Seconds #048
Enable SQLCMD mode in SSMS and use sqlcmd right inside SQL Server Management Studio, for example to switch between servers in one script.