Eve of SQL Rotation 9 and planning for future rotations

The ninth rotation of the SQL Microsoft Certified Masters program begins Monday.  I’m really looking forward to meeting this next batch of candidates and future MCMs.  A few days ago I drew up a summary of each attendee’s experience and background and then emailed it to our instructors.  I wanted the instructors to know about the significant accomplishments…

0

Friday afternoon case of the mystery scan versus seek

So I just got finished with a Friday afternoon head scratcher (that luckily had a resolution). Problem: Ad hoc query with a predicate that references a literal value does an index seek.  0 second execution. Ad hoc query that defines a local variable with same set value does an index scan.  2 second execution. Looking at the…

1

Gotcha: When Server-Scoped DDL Triggers don’t honor ROLLBACK

I’ve used DDL Triggers before to prevent database DROP DATABASE operations.  For example:             CREATE TRIGGER ddl_ss_prevent_database_drop ON ALL SERVER FOR DROP_DATABASE AS PRINT ‘Will not drop database until you disable this trigger.’ ROLLBACK GO If you try to drop a database with this DDL trigger in place, you’ll get the following message: Will not…

2

Free press doesn’t always mean lollypops and rainbows

(Cross posted on The Masters Blog) The eighth rotation of the SQL Microsoft Certified Masters program is about to wrap up and tomorrow is the big day of exams. David Ikeda is covering this rotation, but last week I got a chance to sit with the existing candidates for a day of instruction. I was…

0