Browse by Tags

SQL Server 2005 Partitioned Tables and Indexes - learning curve

Published 12 March 8 3:1 AM | SSQA.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...

Filed under: sql server, performance, indexes, data, backup, bi, database, statistics, partition, monitoring, strategy, data warehouse

SQL Server 2005 methods to find table INDEX or Statistics age for better performance

Published 9 January 8 2:55 AM | SSQA.net

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...

Filed under: sql server, performance, query, index, process, agent, statistics, timeout, statiscs age

FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005

Published 11 September 7 4:37 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: The merge agent does not use a specified custom user update to handle conflicting...

Filed under: sql server, performance, update, replication, kba, statistics, conflict

XLOCK Hint is ignored even though specifying explictly?

Published 11 September 7 5:21 AM | SSQA.net

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...

Filed under: sql server, performance, optimization, hints, statistics, locking, results, xlock

TSQL to obtain a list of current execution of Parallel Plans (MAXDOP)

Published 4 September 7 9:32 AM | SSQA.net

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...

Filed under: sql server, stats, performance, blocking, tuning, query, stored procedure, statistics, parallelism, contribution

How do I find all the statistics and statistics columns on a specified object?

Published 16 July 7 7:46 AM | SSQA.net

USE <database_name>; GO SELECT s.name AS statistics_name ,c.name AS column_name ,sc.stats_column_id FROM sys.stats AS s INNER JOIN sys.stats_columns AS sc ON s.object_id = sc.object_id AND s.stats_id = sc.stats_id INNER JOIN sys.columns AS c ON...

Filed under: sql server, performance, indexes, table, tsql, statistics, columns