For who don’t know, it is know possible to remove Lock Escalation, and this is something that be “granularly” done to a table on SQL SERVER 2008 or Higher without the need to use Trace Flags. Sample sintax ALTER TABLE table_name_goes_gere SET (LOCK_ESCALATION=DISABLE) . — PT — Para quem não sabe, já é possível remover
Tag: optimization
I’m writing this article to help everyone who whats “more juice” from a MS SQL SERVER INFRASTRUCTURE . Instead of writing lots of articles i will update this post every week. I will mix lots of concepts in this post, ranging from Physical Infrastructure/ Operating System/ SQL SERVER PARAMETERS / T-SQL . I will write a
Paulo's SQL Server Weblog and other bytes 