Category Archives: tsql

Why don’t you go and LOCK OFF!

No this is not a Hekaton post :) -perhaps I should have saved this title for another rainy day. SQL Server concurrency is a particularly difficult subject to master and understanding the result of your actions can be confounded by … Continue reading

Posted in 24HOP, Concurrency, sql, SQLServerPedia Syndication, tsql | 2 Comments

Baby baby baby, where did our love/ data go?

Possibly one of the very first things we learn as fledgling DBA’s is that transactions are used to provide “all or nothing” operations. If you ever go for a SQL Server job interview, you are almost guaranteed to be asked … Continue reading

Posted in Concurrency, error, sql, sqlbits, sqlpass, SQLServerPedia Syndication, tsql | 4 Comments

Who’s active on SQL 2000

Yes yes yes I *know* we are currently on SQL 2012 but just hear me out for a second… I think I am probably one of the only people on the planet who has not (yet) used Adam Machanic’s (blog|twitter) … Continue reading

Posted in Concurrency, connectivity, dmv, SQLServerPedia Syndication, tsql | 3 Comments