Using the CASE expression instead of dynamic SQL

I have a lot of SQL update queries where I need to make IF/ELSE types of decisions. I am using a cursor in some cases but looping through thousands of rows for update takes a long time. I also use some dynamic SQL to handle some query parameter decision making. Is there a better alternative?

CS Techcast 16: Revving Up SQL Server 2008

CStechcast.com brings another podcast episode to the starting line with guest Kalen Delaney. This SQL Server expert and authoritative author of the Inside SQL Server series gives us her take on SQL Server 2008. Find the latest from Kalen Delaney at insidesqlserver.com and SQLCommunity.com.

Application Roles

Hubs, Spokes and Buses: How to Get to a Better Data Warehouse

Are you frustrated by the inefficiency, rigidity and latency of a first-generation, hub-and-spoke-architecture data warehouse? Here's a six-step guide to evolving to a streamlined, robust Kimball Dimensional Bus Architecture that will reduce time to reporting, lower data latency, and deliver more detailed, analytically useful information.

Utah Code Camp 2008

If you are near Salt Lake City on April 26th, join in the local Code Camp there.

Data Compression in SQL Server 2005 (Believe it !!)

That’s correct. SQL Server 2005 SP2 supports data compression using Vardecimal data type.

Screencast: Tracking memory with PerfMon counters

Learn how to use SQL Server PerfMon counters to track Windows memory. SQL Server MVP Kevin Kline explains the maximum numbers to watch for when using PerfMon memory counters.

The curse and blessings of dynamic SQL

How you use dynamic SQL, when you should - and when you should not.

Operators

SQL Server 2005 Express Edition - Part 17 - Merge Web Synchronization

In this article, we will explore another variation of this mechanism, called Web Synchronization, with SQL Server 2005 Express Edition instances operating as merge replication subscribers connecting to a publisher via HTTPS protocol.