SqlServer-QA.net

When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as:  [Id]  INT (make this primary key clustered), [Unit_Id]  UNIQUEIDENTIFIER, [EventType_Id]   ...

Recently we have had problems on one of the database that is used on 24/7 basis where a ETL process to import and export millions of rows on few tables has been taking longer time to finish. Further the SELECT queires on reports are timed-out and smaller queries are taking more time to finish. First instance I thought REINDEXING would ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard EditionNotification Contents: New and All Modifications FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005http://support.microsoft.com/kb/913494/en-US

Interesting newbie question on the forums to share. I am selecting a value from a table(column).I do not want any 2 users can select same value at the same time..in other word 1 value only be selected by individual user. in order to do it I am simply using with (xlock) in select statement within begin tran...commit tran. In this way I am ...

PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query is slow when it is using a parallel plan, you can try forcing a non-parallel plan by ...

With the SQL Server 2000 DTS has very good capability of treating the huge processes as transactions, let's assume these parameters: DTS Package with ''Use Transactions'' and ''Commit on successful package completion'' boxes checked. No transaction related boxes checked in the Workflow Properties of each Package step. So the ...

UPDATE STATISTICS is very helpful to get the performance by updating the distribution of key values for one or more statistics groups or set of collections in the specified table or indexed view. So how this is handled within the SQL Server, you may be aware that SQL 2000 version uses a counter (rowmodctr) to track row modification  ...

USE <database_name>;GOSELECT s.name AS statistics_name    ,c.name AS column_name    ,sc.stats_column_idFROM sys.stats AS sINNER JOIN sys.stats_columns AS sc     ON s.object_id = sc.object_id AND s.stats_id = sc.stats_idINNER JOIN sys.columns AS c     ON sc.object_id = c.object_id ...

On SSP forums I have looked at the question about Update Statistics and AUTO UPDATE STATISTICS option available on a SQL server database; 1> When i say Auto create statistics, what are the columns for which statistics are collected? Are these all columns part of the primary key or just the index statistics?2> What is the difference between ...