Browse by Tags

• analysis
• api
• application
• backups
• best practice
• busy
• cache
• columns
• create
• creation
• cursor
• databases
• dmv
• heavy
• indexes
• monitoring
• online
• operating system
• optimization
• perfmon
• query
• security
• sql server
• statistics
• sysmon
• table
• tuning
• update statistics
• usage
• users

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!
25 January 08 02:41 AM | SQL Master | 3 Comments   

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, Read More...

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

TSQL cursors vs API cursors - poor cursor usage
27 August 07 06:54 AM | SQL Master | 2 Comments   

Cursors are based for a definitive purpose, but heavy usage of such methods will prove as costly expense on database performance. The process of cursor is prolonged, as a cursor first has to be defined with its features set, then populated after positioning Read More...

Filed under: performance, sql server, usage, cursor, application, tsql, api, heavy

How to Analyze the PERFMON (SYSMON) data?
20 August 07 11:26 AM | SQL Master | 2 Comments   

As you may aware the PERFMON (SYSMON) utility provides much information to analyze on the systems resource usage, I support and suggest to make use of this tool as much as you can with a default templates within our environment. You may be aware the data Read More...

Filed under: databases, sysmon, tsql, analysis, tuning, performance, sql server, perfmon

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

Filed under: performance, security, query, dmv, optimization, tsql, statistics, update statistics

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

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