SqlServer-QA.net

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications UPDATE Statements May be Replicated as DELETE/INSERT Pairshttp://support.microsoft.com/kb/238254/en-US Diagnostics in SQL Server 2000 ...

You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based RAID. This could be due to one of the reasons such as starting location of partition is ...

Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes occur in a database the changes are formed as transactions that are held in buffer pool ...

This is a very tricky question and hard to stick to 1 or few solutions as answer, it depends! Overall the say is if  there isn’t any resource contention (from your pre-installation testing & analysis) and there is enough of each resource to go around, then there is usually no reason to set any restrictions on the server ...

Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be  listed on this  Windows Catalog and Hardware Compatibility, otherwise you may not be able to utilize or install full set of clustering ...

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 such blocking are: Insufficient resources, ...

One of the best features you have in the SQL Server is to create database data file (additional) on fly without  having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that is used for the databases and how big disk queue length in terms of I/O ...

Recently I have been through interesting forum post on SQL Server performance website that a user asking how to monitor transaction activity between the databases without using a third party tool. Until SQL 2000 version it is not that easy to get more information on what you want, but with SQL 2005 by using DMVs  you ...

May 25 2007-  From the snippet of Tibor Karaszi, SQL Server MVP I have raised a feedback form on Connect.Microsoft website to get newer version (SQL Server 2005) about Index Defragmentation Best practices information. Vote your interest to get newer documentation quickly for most of our benefit to attain the performance. Jan 04 2008 - ...

It is a good practice to determine the required capacity for a database application before it is deployed on the Production environment. As it speaks the I/O system is ''most'' important to the performance of SQL Server, in the event of any performance loss or even configuring a new server for SQL Server you would need to assess the disk ...