How to use Data Compression?

By taking advantage of SQL Server’s data compression feature, you can improve SQL Server performance without changing any application code. Compressing data reduces database storage, which leads to fewer I/O reads and writes. However, SQL Server consumes more CPU resources when it compresses and decompresses data. SQL Server currently supports two types of data compression: […]

Read More »

Performance Improvement for Cursors in Stored Procedures

Background on this example This is a fairly simple example, but is from a real world stored procedure.  The procedure accumulates the special instructions for all tasks assigned to a department and outputs them as a single string.  In this application, each job is assigned multiple tasks required to complete the job and each of […]

Read More »

Copy over SQL Login with dbatools.io

Copy over SQL Login with dbatools.io We recently went through an exercise to move most of our SQL Server databases onto another server. Moving the databases was easy enough, we just backed them up and restored them into the new environment. However that left the problem of how to move the logins. We could have […]

Read More »