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.
Show Clipboard History in SSMS: SQL in Sixty Seconds #129
Show Clipboard History in SSMS 22 sits on the Edit menu with the Ctrl+Shift+V shortcut, where the 2020 video used the older Cycle Clipboard Ring name. I could not test the editor feature from a script, so this post tests T-SQL on SQL Server 2025 that builds row count, index rebuild and procedure scripts worth pasting.
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.
Performance Comparison – IN vs BETWEEN – SQL in Sixty Seconds #127
Yesterday I blogged about SQL SERVER – Performance Comparison – BETWEEN, IN, and Operators. Following that, I got many emails about the topic.
Varchar vs Nvarchar – Storing Non-English Characters – SQL in Sixty Seconds #126
Let us learn how to store non-English Characters in SQL Server tables. You will learn in this video the major difference between VARCHAR and NVARCHAR.
Nested Transactions are Myth – SQL in Sixty Seconds #125
Many sent me an email that they want to know more about the nested transactions. Let us learn about them in today’s blog post.
Dropping Temp Table in Stored Procedure – SQL in Sixty Seconds #124
Is dropping temp table in stored procedure code really needed? In this SQL in Sixty Seconds video, I compare two procedures to show what happens.