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.
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 it necessary to drop a temp table created in the stored procedure? I was recently asked this question during the Comprehensive Database Performance.
What is Temp Stored Procedures? – Interview Question of the Week #294
Temp stored procedures are the SPthat are created with the help of the # at the beginning of the name and only available until the SQL Server restarts.