Bottlenecks aka locking & blocking is a quite common scenario within a RDBMS platform, that too SQL Server is not an exception at all. With an access to shared resources causes bottlenecks and demands on shared resources cause poor response time and must be identified and tuned. Few root causes for...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-25-2008
Filed under: sql server, performance, memory, dba, i/o, disk, 2008, development, cpu, best practice, capture, resource governor
Since the release of SQL Server 2008 (last 2 CTPs) users are anxiously awaiting for data compression feature, so how it is handled in this version and what it does, is it a good thing? Data compression enables you to store your data more effectively and reduce the storage requirements for your data....
Here it is, next installment of SQL 2008 CTP which is July CTP of SQL Server 2008 is now available for download on the SQL Connect site (you need to have a passport login to download). There are few enhancements to the Reporting services, introduction of new date & time data types including the performance...
SQL 2008 books online confirms the deprecated features that are not supported with the release of RTM, those few lists are as follows: SP_DBCMPTLEVEL is replaced with ALTER DATABASE .. SET COMPATIBILITY_LEVEL SP_HELPDEVICES is replaced with sys.backup_devices system table SP_RENAMEDB is replaced with...
First of all I would like to remind the users to install the SQL 2008 CTP on their Virtual Server environment rather than mixing with current test or development (physical) environment. Once the SQL 2008 CTPs are more stable and if you are planning to test it with real-time data (say by 2008) then you...