This page was last modified on Monday, February 05, 2007 09:04:53 PM
How to detect a TABLE FRAGMENTATION in SQL Server?
How effectively you can use SQL Server 2005 Books OnLine:
Office Writer for SQL Server Reporting Services, a good add-on for Reporting Services using a third party tool. Refer to http://www.sql-server-performance.com/sj_officewriter_spotlight.asp & http://officewriter.softartisans.com/OfficeWriter-352.aspx link for more information.
Using Plan guides in SQL Server 2005
In SQL Server 2005, there is a new feature called Plan Guides that can help out in some cases where you discover poorly performing queries that you don't have direct control over. Essentially, a Plan Guide allows you to add or modify query hints to queries on the fly, just before they are executed. Review
http://www.sql-server-performance.com/bm_using_plan_guides.asp link.
Index Locking Granularity in SQL Server 2005That's right, indexes, just like tables, are subject to locking. And as most DBAs already know, inappropriate locking (in tables or indexes) can negatively affect the performance of SQL Server. Review
http://www.sql-server-performance.com/bm_index_locking_options.asp link.
SQL Server Processor Performance
With the new multi-core processors launching this year and in 2007, finally unconstrained by thermal limitations, look for performance gains in multi-threaded applications to exceed the pace of Moore's Law. The traditional doubling of the logic complexity of a processor was only expected to generate a 40% performance gain. Review http://www.sql-server-performance.com/jc_processor_performance_06.asp link.
Boost Performance and Reduce Code Use With SQL Server Aggregate Functions
This article will acquaint you with aggregate functions such as MIN, MAX, COUNT, and AVG, which easily let you perform tasks that you may have thought needed extensive programming codes to accomplish. Review http://www.sql-server-performance.com/art_aggregate_functions.asp link.
Using TRY/CATCH to Resolve a Deadlock in SQL Server 2005
The TRY/CATCH method is powerful enough to handle the exceptions encountered in your code irrespective of how deeply nested the application is in a stored procedure. Review http://www.sql-server-performance.com/art_deadlock_sql_2005.asp link.
Comparing the SQL Server 2000 Index Tuning Wizard and the SQL Server 2005 Database Tuning Adviser
How does the SQL Server 2005 DTA stand up against the SQL Server 2000 ITW?
Review http://www.sql-server-performance.com/lm_database_tuning_adviser_english.asp link.
Security Enhancements in SQL Server 2005: Schema
This article will discuss the key features of authorization in SQL Server 2005. Among the several authorization features, schema is the most valuable and confusing special features. Review http://www.sql-server-performance.com/da_authorization_2005.asp link.
Centralized SQL Server 2000 Monitoring
Learn two different ways to help centrally manage your SQL Servers. Review http://www.sql-server-performance.com/tp_centralized_sql_server_monitoring.asp link.
Sample SQL Server Disaster Recover Plans
Learn how other companies put together their SQL Server disaster recovery plans. Review http://www.sql-server-performance.com/disaster_recover_examples.asp link.
Introduction to SQL Server Reporting Services 2005
http://www.sql-server-performance.com/sm_sql_2005_reporting.asp
Attain High Availability in SQL Server
http://www.sql-server-performance.com/sql_server_high_availability.asp
SQL Server Clustering from 2000 to 2005
http://www.sql-server-performance.com/rn_sql_server_clustering_2000_to_2005.asp
A White Paper on "Cannot Delete File: Cannot Read from the Source File or Disk"
Recently I have been looking for information on few issues when deleting (backup) files and had issues with errors stating "Cannot Delete File: Cannot Read from the Source File or Disk". I could get over with this issue by referring to the article http://ezinearticles.com/?expert=Scott_Best from here.