It is totally possible to Insert Multiple Values into Multiple Tables in a Single Statement. Let us learn how we can do that in today’s video.
Priority Boost and Performance – SQL in Sixty Seconds #131
Enabling Priority Boost does not mean that you get performance from your SQL Server. It may be quite opposite. SQL in Sixty Seconds.
SSMS Efficiency – Replace STAR – SQL in Sixty Seconds #130
You might have heard that SELECT * is bad for queries performance. Let us learn in today’s video how we can replace STAR (*) by column name.
Cycle Clipboard Ring – SQL in Sixty Seconds #129
Copy (CTRL + C) and Paste (CTRL + V) are the friends of the DBAs and Developers. In SQL Server it is totally possible to use the Cycle Clipboard Ring.
SET STATISTICS IO ON – SQL in Sixty Seconds #128
I am working with clients on helping them tune their SQL Server Performance. Let us learn how we can use SET STATISTICS IO to check the query’s performance.
How to Change Database File Size? – Interview Question of the Week #296
Question: How to Change Database File Size?
Answer: By Shrinking the files. Now, many have a negative opinion about Shrinkfile.
Long-Term Backup Retention in Azure SQL Database
Configure long-term backup retention in Azure SQL Database, inspect retained recovery points, restore a separate copy, and review costs.