SqlServer-QA.net

Recently when I had a task to identify the learning materials (free) and web resources for SQL Server Integration Services (SSIS), then first place I have used is MVP private newsgroups. You will appreciate the immediate help I received from fellow MVPs in getting the list swiftly, they are as follows: Books Online (updated) - As the ...

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 ...

During the deployment of new project for an application that is accessed worldwide by one of my client. Ther were looking to implement Full Text Search as well due to the nature of application. For your information SQL-FTS: SQL Server Full Text Search which allows fast and efficient querying when you have large amounts of unstructured data. The ...

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 ...

Yet anothe forums related question I would like to blog, as I have seen in my experience on newsgroups. There will be always a question asking about why Transaction log is filling up and blocking is ocurred when a DBREINDEX & CHECKDB processes are under execution. Well the reason is obvious that these DBCC statements are ...

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 ...

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 ...