SqlServer-QA.net

Do you cache or not? By default SQL Server cache stores the data & query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required to retrieve a report if the report is large or accessed frequently. Bear in mind that ...

By default SQL Server automatically creates the internal tables for Full-text search, XML indexes and Service broker. These are also created when a user query is written poorly that uses tempdb heavily. At they are called internal tables but do not contain any user related data and schema for these tabls are always fixed. You will not be ...

Another common question in the forums asking about what are the best practices for using antivirus software on servers running SQL Server. In my experience if your SQL Server is not a internet-faced one then no need to have one installed on a SQL Server that is dedicated to databases, rather tighten the access on the file access and share on ...

I feel like there is lot of confusion (new users) in deciding which build to apply after the re-release of SQL Server 2005 Service Pack2 during the month of March 2007. So here is the list of references I would like to share in explaining what is what in the recent releases for SQL Server 2005: Build 3161 KBA Build 3152 KBA In both the ...

SSMS - useful tool for a SQL Server DBA and user to manage their work in SQL Server. This tool has been fine tuned since the RTM release of SQL 2005 since Nov.2005 and you may be aware using this tool you can manage SQL 2005 and 2000 instances without any issues. IF you are on a Windows domain network then for the day-today work you must use ...

The goal of this FAQ is to offer a place for Disaster Recovery that simulates the Business Continuity provision for your SQL Server enviornment. The important factor for your DR provision is: Using backup and restore  Using DBCC, including interpreting output from CHECKDB and related commands Diagnosing and recovering from hardware ...

Updates to system catalogs are not allowed - a big subject and nothing but opening door to trouble by allowing direct updates or modifications to system tables in SQL Server 2005. If I remember correctly since the days of SQL 6.5 version Microsoft has been discouraging udpates to system tables even though the provision has been enabled. Since ...

Very interesting insight of security topics on Windows operating system by Aaron Margosis.

Scenario is like this: Error generated when trying to register the Linked server between 2 SQL instances.  SQL Server setup information is as follows:provider:SQL native ClientProduct Name: SQLNCL1Data Source: Somewhere IN this world (SQLServer 2000 default instance)catalog=Northwind 1. Remote connections: using both TCP/IP and Named ...

Well the prime criteria for DBAs is to upgrade from the previous versions to latest version and it is not an easy option or platform to perform so quickly without having a proper testing within their environment. As far as the SQL Server is concerned with the version 2005 you have Upgrade Advisor tool and also you need a documentation on setting ...