When it comes to SQL Server performance, many organizations look to their DBAs to help fine-tune hardware configurations, optimize indexes, or weed...
Don’t Forget Application Caching to Boost SQL Server Performance
read more
Liz Stephens
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Tips for Optimizing XML in SQL Server
I’ve worked on a project that used XML heavily inside SQL Server. We really utilized SQL Server’s XML support almost to the full extent,...
Consider Your Collations Carefully, Or Pay Later
When first installing SQL Server, many developers and DBAs new to SQL Server may have the temptation to click Next, Next, Next on the installation...
Ensure Proper SQL Server Connection Pooling
Coming to SQL Server from both a database developer and DBA background, I maintain that while tuning SQL Server’s ability to handle your application...
How to Make a Copy of a Database on Windows Azure SQL Database
Windows Azure SQL Database (previously SQL Azure) offers a unique way to make a database copy to another database using the CREATE DATABASE as COPY...
Understanding SQL Server Statistics
Donabel Santos (twitter (@sqlbelle) | blog) – April 25, 2011 “Statistics provides tools that you need in order to react intelligently to...
Take your indexed columns out of functions to really boost SQL Server performance!
In a future article I will show how to quantify and rank your “heaviest” SQL Server queries according to the overall load they place on...
Performance of COALESCE vs. IS NULL
There are a great many articles out there expounding the virtues of using the ANSI standard COALESCE function over the...