SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

Are UDFs Harmful to SQL Server Performance?

Well, not really. But it is vitally important to understand when to use them and when to avoid them, as well as how best to construct them so as not to shoot your foot off. SQL Server 2000 introduced user-defined functions (UDFs), and they were immediately hailed as a great tool for encapsulating repetitive code, […]

How to Best Implement a SQL Server Performance Audit

The Final Word on How to Perform a SQL Server Performance Audit If you have gotten this far, you have done a lot of reading. In this final article on how to perform a SQL Server Audit, we will take a look at some best practices about how to best implement a SQL Server Performance […]

SQL Server Database Backup Performance with Quest (Imceda) LiteSpeed for SQL Server; 3 Terabytes in Under 1 Hour

Introduction For the last several weeks, I have been working with Imceda (now Quest Software) on improving the performance of LiteSpeed for SQL Server, particularly for high–end storage systems. This report represents my assessment of LiteSpeed performance characteristics. I am an independent consultant, so this report does not represent the views or claims of Quest. […]

SQL Server Query Performance Audit Checklist

SQL Server Query Performance Audit Checklist SQL Server Job Checklist Your Response Have you identified all long running queries? Have you prioritized the queries? Have you reviewed the execution plans of the above prioritized queries? Enter your results in the table above. Identifying Long Running Queries is First Step At this step in the SQL […]

SQL 2000 to SQL 2005: Where Have All the Old Features Gone?

As more DBAs across the planet begin using SQL 2005 Tools, but still manage SQL 2000 servers with them, I suspect there will be lots of muffled moaning as to where all the good old features have gone. Although Management Studio has some very nice long-awaited features, some of the good old stuff just isn’t […]

SQL Server XML Statistics and Execution Plans

One of SQL Server’s deficiencies when using XML queries is the lack of statistics capability in the XML driver. This is surprising because the ODBC API contains a function for providing statistics on remote data sources. SQL Server defaults to the fixed assumed row count values for remote servers, which is unreasonably high for XML […]

Job Performance Audit Checklist

SQL Server Job Performance Audit Checklist SQL Server Job Checklist Your Response Are you running any unnecessary jobs? Are jobs scheduled to run during production lulls? Do any SQL Server jobs on the same server overlap? Do you have any non-SQL Server jobs that overlap?   Have jobs that run T-SQL been optimized? Have you […]

SQL Server Monitoring in 8 Steps: Lessons From the Field

“To count is to know.” SQL Server database systems are more than ever before being chosen as the preferred backend database solution for large business’s critical systems. And SQL Server richly deserves this status. As a result of this, more users than ever before are blocked in their daily activity when the database is not […]

10 Baselining Tips for SQL Server: Lessons From the Field

“A known value against which later measurements can be compared” is one of many definitions for SQL Server baselining. In this article I want to share my findings with you on this subject. This document is the first in a series of four where I want to cover subjects as baselining (this article), monitoring, stress […]

Top 10 Must Have Features in O/R Mapping Tools

Object-to-relational (O/R) mapping tools are becoming more popular each day and people are realizing the productivity gain they provide to developers. Yet, many people do not know enough about O/R mapping to consider using these tools and many others are weary of using any code generators (including O/R mapping tools). In this article, I will […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |