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.

Adding Multiple Columns

Passing parameters to query without TVFs

This article looks at an interesting way to help your users get filtered data from a TVF instead of using a stored procedure or specialized view.