Browse by Tags

All Tags » performance » statistics   (RSS)
SQL Server 2005 methods to find table INDEX or Statistics age for better performance
09 January 08 01:55 AM | SQL Master | 4 Comments   
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 Read More...
DTS package, how will optimizer treats the transactions?
02 August 07 05:52 AM | SQL Master | 2 Comments   
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 Read More...
Usage and good practices with UPDATE STATISTICS feature in SQL 2005
23 July 07 03:39 AM | SQL Master | 1 Comments   
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 Read More...
How do I find all the statistics and statistics columns on a specified object?
16 July 07 05:46 AM | SQL Master | 1 Comments   
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 Read More...

Search

Go

This Blog

«December 2008»
SMTWTFS
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Syndication