Solved

sql2008 new features

Posted on 2011-03-21
2
276 Views
Last Modified: 2012-05-11
0
Comment
Question by:motioneye
2 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 250 total points
ID: 35186700
As specified over there, it should have been fixed in SQL Server 2008 SP1 and hence applying the latest Service Pack SP2 should ensure that the particular issue have been resolved.
0
 
LVL 15

Assisted Solution

by:Aaron Shilo
Aaron Shilo earned 250 total points
ID: 35190603
yes there is an regression in lock escalation algorithm in SQL2008.

it has a very heavy effect in regard to sql 2005.

microsoft fixed this issue with the latest service pack 2 released not long ago.

still you can allways control locking on the object level or with hints on the query level.

just check MSND for lock handling
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question