Notes from Bangalore DevCon 2012: two tracks, 12 sessions and more than 140 attendees, plus my own session on SQL tips and tricks for web developers.
SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – T-SQL Example – Part 2 of 2
Part 2 of the disappearing rows story: a T-SQL example showing how ON UPDATE CASCADE and ON DELETE CASCADE made my friend’s rows vanish, no virus involved.
SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – Part 1 of 2
Rows kept vanishing from a product table with no DELETE anywhere in the code. Part 1 of a puzzle that leads to ON UPDATE CASCADE and ON DELETE CASCADE.
Measuring Time Between Workflow Steps With LEAD
Status rows hold timestamps, not durations. I use LEAD to measure each step, keep unfinished steps NULL, and show why zero ruins your averages.
What Is a Primary Key, and What Happens Without One?
A primary key is the promise that every row can be told apart. Why NULL is refused, what a table without one actually costs you, how it differs from a unique constraint, and when to choose a natural key over a made up one.
INNER HASH JOIN: Why a Table Join Hint Also Fixes Join Order
A join hint in the FROM clause quietly fixes the join order. I show the warning, three plans side by side, and the softer query-level alternative.
Checking XML Index Size Against the Table It Belongs To
An XML index can outweigh the table it serves. Here is how I measure each XML structure next to the base table, and what to test before dropping one.

-600x400.jpg)








