Browse by Tags

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!

Published 25 January 8 3:41 AM | SSQA.net

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...

Filed under: sql server, performance, indexes, cache, users, tsql, best practice, backups, create, online, monitoring, operating system, busy, creation

TSQL to findout blocking and locks on a SQL Server?

Published 7 December 7 1:8 PM | SSQA.net

Have you ever performed huge operations such as deleting records of a table and processing inserts on that table at the same time? This is a common task that every application will have to perform and you can avoid by fine tuning your queries (mostly...

Filed under: sql server, performance, indexes, blocking, security, insert, tsql, locks, deletes

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