Category Archives: tsql

VIEW, Pugh, Barney McGrew…

…Cuthbert, Dibble, Grub. I never ceases to amaze me that there is always that little bit of SQL Server functionality that you didn’t know about. Some of it good and some of it bad, some of it just meh… The … Continue reading

Posted in development, gui, SQLServerPedia Syndication, ssms, tsql | Leave a comment

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