Ajit, are you aware that SQL Server automatically indexes every row as it is added to a table. There is no need to do a separate index build in...

To access mainframe files, you will need an appropriate ODBC (or similar) driver. Google may help you find what is available, but I believe a company called NEON can...

If you are doing an in-place upgrade from SQL 2000 you must be on SP4.

If you are building a new server to host the new version of SQL you may...

You can get an alert if a service fails by using facilities in Windows.

Right-click on My Computer and select Manage. Navigate to Services and locate the SQL...

Even though master will always operate in Simple mode regardless of the recovery mode you have set, personally I would want the recovery mode to reflect what is happening. ...

As stated above, the reserved value is space allocated to the table but not currently used.

You should read the word 'reserved' as meaning space set aside within the filegroup for...

The article tells you how to move system databases, but does not tell you if it is a good idea to do so.

Many people need to put tempdb on to...

I think a data subject should have the right to see all data held about them. For free. This includes all police, security and medical data, all commercial data,...

sp_readerrorlog needs to open a new connection to get to the data. You are in single user mode and are already using the only connection available.

You can always read...

As people have said, Microsoft decided this type of in-place migration would not be supported.

Most people upgrading from SQL 2000 to SQL 2005 or SQL 2008 recommend you do a...

You are getting this message because WSUS is not running using a domain account.

One way to resolve this is to change the account used to run the WSUS...

SQL Server clustering is designed to solve the problem of high availability, not the problem of load balancing.

You can install SQL Server on a multi-node cluster, but only one node...

I think you need to make this change to the active instance of SQL Server. If you want the change to take effect immediately you also need to run...

Sometimes the left hand at Microsoft does not talk to the right hand. This can result in experts in one product saying how to use another product they actually...

You should be able to change the certificates without impacting the encrypted data. If you need to change the encryption keys then I think you will need to re-encrypt.

Is...