Madeira TeamJan 9, 201210 minCASE StudySometimes we want to populate a table with random data, mainly for testing purposes. For example, let’s consider the following table:...
Madeira TeamJan 8, 20123 minThe table variable transaction catchAs I’ve mentioned in my previous post, there is a catch when using a table variable as a part of a transaction. It behaves differently...
Madeira TeamJan 5, 20128 minLOOP, HASH and MERGE Join TypesToday I’ll talk about the available JOIN operator types in SQL Server (Nested Loops, Hash and Merge Joins), their differences, best...
Madeira TeamJan 3, 20123 minPro and Cons of Parameter SniffingLook at the following 3 scripts: Transact-SQL -- 1. Hardcoded SELECT * FROM Sales.Orders WHERE DateAndTime < '19900101' -- 2. Variable...
Madeira TeamJan 2, 20128 minStaging, temp and variable tables – performance, recompilation and what’s in betweenA lot of times, when creating a procedure, we need to use some kind of an empty table in order to perform all kinds of calculations. The...
Madeira TeamDec 30, 20115 minAbout Snapshots and GhostsA few weeks ago Kalen Delaney presented a 3-day seminar in Israel. Unfortunately, I wasn’t able to attend the seminar, but some of our...