We explore an alternative approach when dealing with high volumes of ‘OR’ conditions in our SQL queries: the use of a TempTable.
SQL SERVER – Steps to Identify with Odd and Even Rows
Sometimes, when working with SQL, you might need to do something special with odd and even rows in your table. This can be a bit tricky.
11 Essential Tips for Avoiding Common SQL Server Performance Tuning Mistakes
This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database’s performance.
INSERT EXEC: Capturing a Procedure’s Result Set and Its Limits
Capture rows with INSERT EXEC, match result columns, understand nested and multiple-result limits, and choose supported alternatives.
SQL SERVER – Table Variables, Temp Tables and Parallel Queries
I heard an interesting comment from a client and that made me write a blog post. Their point was about table variables, temp tables, and parallel queries.
SQL SERVER – Inserting sp_who2 Into a Table
I should also have included the script for method 1 discussed in the blog post. Let us learn a method of inserting sp_who2 into a table.
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.