Common Table Expression Basics

Learn the basics of how CTEs work with a few examples in this article.

REPLACE versus TRANSLATE for SQL Server Text Data Manipulation

Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation.

Refreshing Modules

Find 40 Problems in this SQL Server Stored Procedure

I often perform code reviews and thought it would be fun to frame this exercise: a completely fictitious stored procedure hits my desk, I’ll reject it of course, and enumerate the reasons why.

Convert Dates for XML

Summing a BIT column with a numeric as the outcome

Swapping values of variables

Multiple Defaults

OPENROWSET DNR

Performance Tuning with SQLFacts Tools

The need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved into cloud services, their efficiency has a direct impact on the recurring bills. A workload that consumes more resources than necessary costs more to host in the cloud and affects the bottom line for your organization.