Sunil Agarwal, a program manager from the Storage Engine Team, from the just did another blog posting on minimal logging in SQL Server 2008 and TF-610, this one when using the MERGE statement. Run some of his code in his series on minimal logging and see if you don’t agree with me that this is reall... [More]

Posted in: The Best of MSDN Blogs  Tags:
Lee posted on June 6, 2010 18:07
Where I am consulting we’re getting ready to set up a full-blown partitioning design for a fact table that will hold data from, roughly, 50 countries. Someone asked the other day about locking and DML so I experimented in another post on the new (LOCK_ESCALATION = AUTO) feature for SQL Server 2008.&... [More]

Posted in: SQL Server 2008 , TSQL  Tags:

by Lee Everest, M.S.

Info

Poll

Do you use Azure or cloud in your organization?
Show Results

Ads

Search


Month List

Calendar

«  June 2010  »
MoTuWeThFrSaSu
31123456
78910111213
14151617181920
21222324252627
2829301234
567891011
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog