Latest SQL Server General DBA FAQ's

RSS Feeds

FAQ Topics

All FAQ's

General DBA

General Developer

DBA Performance Tuning

Developer Performance Tuning

Clustering

Error Messages

USEFUL SITES :

ASP.NET Tutorials
Windows and SQL Azure Tutorials
Cloud Hosting Magazine
SharePoint Tutorials
Windows Server Help

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...

Latest Articles

A High Level Comparison Between Oracle and SQL Server - Part ...

A High Level Comparison Between Oracle and SQL Server

	Setting Up Data And Log Files For SQL Server
	Is there a difference between fill factor 0 and 100
	The Excel Connection Manager is not supported in the 64-bit version of SSIS
	Will Check Constraints Improve Database Performance?
	Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created.
	Remove a Node From a SQL Server 2008 Cluster
	Report Builder Fails to Launch
	Error when Inserting data to Replicated Databases
	How to run SQL Profiler without sysadmin rights?
	How to Perform Multiple lookups to the same table
	How to import an Excel file which has columns with more than 255 characters to SQL Server using SSIS?
	How to Manually Uninstall SQL Server 2005
	How to send a SSRS report from SSIS?
	How to alter a User Defined Data Type?
	How to view previous query plans?
	Cannot Start SQL Server Service
	Errors when SQL Server Snapshot Replication is Running
	Error messages when you try to process a database or a cube in SQL Server 2005 Analysis Services: "The attribute key cannot be found" and "The record was skipped because the attribute key was not found"
	Database Mirror Certificate Expired
	How to replicate more than 256 articles in Merge Replication?
	SQL Server 2005 - clients using native client, should clients be upgrade as well
	How to Configure Multiple SQL Server Reporting Service Instances on the Same Computer
	Error When Configuring SSRS Database
	How to Access a Map Drive from SSIS ?
	How can I force SQL Server 2005 logins to change their passwords periodically?
	What permission does the user need to run PROFILER in SQL Server 2005?
	How can I drop all the instances attached to one Database?
	In SQL Server 2005 how to determine the role memberships and the permissions associated with login yy?
	Using SQL Server 2005 how to find a user or login that has the db_owner role in any database?
	IN SQL Server 2005, how do I backup the sys.asymmetric_keys and sys.symmetric_keys tables?
	How to resolve SQL Server Management Studio error: 'Could not load file or assembly 'SqlManagerUI ...'?
	For optimum security, is it recommended to use a single domain account the SQL Server instances in a network?
	What is the best way to test the upgrade process from SQL Server 7.0 or 2000 to SQL Server 2005, before I perform the actual upgrade?
	In SQL Server 2005, when I'm trying to open the Database Maintenance Wizard, I get an error message telling me that "Agent XPs" are not running. How can I resolve this problem, and what are "Agent XPs?"
	What is the purpose of the Surface Area Configuration Tool in SQL Server 2005?
	How can I enable xp-cmdshell on a SQL Server 2005 instance?
	Is it possible to set the database name in advance when deploying client database with an installer option?
	How do I get the taskpad view in SQL Server Management Studio as it was in SQL Server 2000 version?
	DTS package error "Cannot find specified package in the storage location specified".
	Unable to install Service Pack 1 for SQL Server 2005 version.
	How to get resource usage of an executing query in SQL Server without using SYSMON/PERFMON utility?
	Can you provide the scripts that you use to transfer (copy) logins from a primary server to a secondary server?
	How do you get rid of users that are already in the database on the backup server when a restore starts?
	Should we automatically reboot our SQL Servers on a weekly basis?
	Why do I get an unordered resultset, although my table has a clustered index?
	Can I downgrade my SQL Server databases to an earlier version?