Every growing business hits this wall at some point. The application that worked perfectly six months ago now takes forever to load. Users start complaining. The dev team blames the server. The ...

Who are these scripts for? You need to troubleshoot performance problems with SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, ...

If your logic involves multiple INSERT, UPDATE, or DELETE operations on the intermediate data, a temporary table is the way to go. You need to share the intermediate data between different execution ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...

As described in our previous article, the packer configuration contains the decryption key of the packed binary as well as its original filename, its size and the execution type (EXE or DLL). The ...

The first installment of this TechRepublic series focused on C# developer interview questions. It generated a lively discussion on the merits of such questions and the different approaches to ...

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. In a previous TechRepublic column about SQL Server ...