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 [...]
Archive for April, 2011
Disable Lock Escalation in SQL SERVER 2008 or Higher
Posted in sqlserver, tagged bottleneck, optimization, performance, scalability, tuning on Monday, April 18, 2011 | Leave a Comment »
Run SSIS Packages in SQL SERVER 2005 x64 with Jet4 OleDB connections (eg:excel)
Posted in sqlserver, tagged SSIS on Friday, April 8, 2011 | Leave a Comment »
To sum up, I had to solve a situation in a client that wasn’t able to run a couple of SSIS package with SQLSERVER AGENT but they were running ok in BIDS. Since SQL SERVER was running on a x64 environment, and the SSIS package was connecting to a excel files ( JET 4 OleDB [...]
