Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources that the query accesses. This can be very dangerous because an exclusive lock on a table or partition could cause significant performance concerns.
If you’re a data professional or application developer chances are you’ve run into Microsoft SQL Server once or twice.
About a year ago I wrote about a new feature in SSMS that allows you to add a data classification to your columns. Today we’ll discuss what happens behind the scene and how to look at the classifications later.
It’s taken longer than I thought it may and I’ve run into several problems along the way but had a few people in the MVP community swing some homeruns to help me complete the BETA of this new SQL Server community query tuning tool.
In case you aren’t familiar with #MSIgnite, it’s a huge event where Microsoft debuts all the new shiny software that you’re going to want your hands on immediately and the conference is happening right now and goes until Friday.
You can watch and learn all about the exciting new things at this link:
Hope you enjoy and find some time to check out some of the broadcasting.
I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog I’m going to explore if that’s the case. Let’s have a look.
I’m speaking along with many other amazingly talented professionals, including Adam from Guy In A Cube. If you’re in the Houston, TX area be sure to head over to the SQL Saturday website to register. You can find more details here: http://www.sqlsaturday.com/766/eventhome.aspx
There are over 50 sessions across 6 different tracks; so, there’s plenty to learn for everyone! My session is a guide to troubleshooting performance for DBAs and developers.
Hope to see you there!
It always seems that when I give a talk on performance there are 100+ people packed in the room but when it comes to security there’s 10 to 15 people. No one likes patches, unless you’re talking about a puppy named patches or something that’s not related to updates; yet, it’s so important that we all do them.
SQL is a stout language and SQL Server has so many features that it’s impossible to be an expert in everything. I see a lot of people gravitate towards performance; but, that’s not the best place to focus. If you don’t know the fundamentals of the language then you will never be the best performance tuner.Read More »
I decided to poke fun at ORM tools again this week. Hope you enjoy.