Showing posts from March, 2010

Maximum limit of SQL Server

Attaching a database with out log file…

Procedure for Role change in log shipping

Need to back up a database with out breaking the log sequence? Use Copy only backup

Setting up log shipping in SQL Server 2005

How to move SQL Server user database files from a different location?

Geographically Dispersed Cluster and SQL Server... Advantages and Limitations

You may receive an error while executing sp_helpdb

Distributed query via linked server fails to execute from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server

One feature better to avoid in SQL Server while tuning the performance

A note on Resource database (mssqlsystemresource ) of SQL Server

Using port number to connect to a SQL Server

SQL 2005 Cluster Installation – A step by step guide

"Failed to reserve contiguous memory" error killed .net applications

Why should I use Checksum on my database?

Shall I move to 64 bits when migrating to SQL 2005/2008? … Invest 10 minutes on this question before designing your new server