Blocking in SQL Server occurs when a transaction in a database session locks resources that another transaction requires to read or modify. If your application has long term blocking, then you have a problem in your hands to resolve.
Having an effective Database Indexing Strategy is a key to your application performance. When we think about optimizing SQL query performance, generally the first thing which comes to our mind are ‘Indexes’. And rightly so, because Indexes tremendously help in fetching your data faster from SQL Server.
“Lock Escalation” is an optimization technique used by SQL Server and it is basically how it handles locking for large updates. When SQL Server is going to modify a large number of rows – it is more efficient for the database engine to take fewer, larger locks (table lock) instead of dealing with a large number of individual locks (row locks).
I am honored and super excited to have been selected to speak at this PASS Summit 2017 – the world’s biggest conference in the Microsoft Data Platform. This will be my first PASS Summit experience. I consider myself very fortunate to have got this opportunity, knowing very well that there are so many experienced and better speakers around.
SQL Saturday Chattanooga was held on 24th June at UTC Chattanooga EMC Building. I have been to multiple SQL Saturdays earlier, but this was my first time in SQL Saturday Chattanooga. I was humbled to get the opportunity to present two sessions during this event.
I am excited to announce that I have been selected to speak at SQL Saturday Pensacola on 3rd June, 2017. I have heard so many good things about this event from my peers, that I feel humbled to be part of the event this year. SQL Saturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics.