SQL Server tips and tricks library

SQL Server - Frequently Asked Questions(FAQ)

This page contains a collection of the frequently asked questions about SQL Server in the various newsgroups along with some, from my own experience with the product over the years. Please note that many of the answers are suggestions and hence would be better to test them thoroughly in a testing environment before adapting them into production .

Based on the nature, I have categorised the questions as mentioned below. Hope you find them helpful !!

SQL Server Development FAQ - Commonly encountered problems regarding the syntax of SQL Server programming.  
SQL Server Setup - Issues related to the Sqlserver edition setup/upgrade  
Database Maintenance - Issues that DBAs face in maintaining the SQL Server database and also discusses disaster recovery methods.  
SQL Server Performance Tuning - Covers those topics which help in tuning the SQL Server database for optimum performance.  

Home | XP Help | SQL Help | Jokes | Kids Sites |