August 2022 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Copy Data from One Table to Another Table – SQL in Sixty Seconds #031 – Video

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
, , ,
Copy data from one table to another table is one of the most requested questions on forums, Facebook and Twitter. The question has come in many formats and there are places I have seen developers are using cursor instead of this direct method. Earlier I have written the similar article…
Read More

SQL SERVER – Resolving SQL Server Connection Errors – SQL in Sixty Seconds #030 – Video

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
, , ,
One of the most famous errors related to SQL Server is about connecting to SQL Server itself. Here is how it goes, most of the time developers have worked with SQL Server and knows pretty much every error which they face during development language. However, hardly they install fresh SQL…
Read More

SQL SERVER – Identify Most Resource Intensive Queries – SQL in Sixty Seconds #028 – Video

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
, , ,
During performance tuning conversation the very first question people often ask is what are the queries offending the server or in another word let us identify the queries which are the most resource intensive. The resources are often described as either Memory, CPU or IO. When we talk about the…
Read More

SQL SERVER – Copy Column Headers from Resultset – SQL in Sixty Seconds #027 – Video

Pinal Dave
SQL Video
, , , ,

SQL Server Management Studio returns results in Grid View, Text View and to the file. When we copy results from the Grid View to Excel there is a common complaint that the column header displayed in resultset is not copied to the Excel. I often spend time in performance tuning databases and I run many DMV’s in SSMS to get a quick view of the server. In my case it is almost certain that I need all the time copy column headers when I copy my data to excel or any other place.

Read More

SQL SERVER – Effect of Collation on Resultset – SQL in Sixty Seconds #026 – Video

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
, , ,
Collation is a very important concept but often ignored. I have often seen developers either not understanding this or ignored it – this is plain wrong. In simple word we can say Collation is the language or interpreting done by SQL Server. Well, in today’s SQL in Sixty Seconds we…
Read More