The value for Avg. Disk Queue length is number of requests being queued for the selected disk. Theoretically it  should be lower than 2* no.of processors. This value is the accepted...

The biggest advantage with c2 mode is that SQL Server will stop if for some reason(drive filling up) SQL server cannot write to the trace file. This is something which...

Arthur,

Can you not just define a unique key on column nullablevalue1 & nullablevalue2

I agree with kyle. For performance, try to keep your transactions as short as possible. This would greatly impact your performance if you have multiple users simultaneously accessing the same...

Gary,

For log shipping, the secondary server should be in read-only mode. There is nothing wrong with it. With you having mentioned that all the copy and restore jobs are successfully, i can't...

Can you please let us know the below

1) Are the inserts/updates/deletes performed against the same table ?

2) Is the transaction going to be executed simultaneously by different users ?

Open client network utility. Click on the alias tab and click Add. In the alias box, type in server_name, Under server Name box type in the Servername\instance_name.

Thanks a lot Bill, That would definetely help. I will try to push to get additional 200GB.(Considering some growth factor.)

Thanks a lot for the reply. I agree that theoretically you need roughly 1.25 times the data space but i was wondering if someone had run into such a scenario...

Below is what i understood from your post

I am getting following error while backing of my table

Ans. SQL Server does not have a feature which will allow you...

you can call ftp using xp_cmdshell

If you want to restore database from server A to server B you need to do the following.

1. Create the procedure to restore the database on server B.

2. Execute the procedure...

If you are not concerned about point in time recovery, you can change the recovery model to Simple. But with this change you would be able to restore your database...

Douglas,

What you are referring to means a table scan. If you defined a non-clustered index on top of a clustered index and if the optimizer uses the non-clustered index, it will...

Look for create trigger under Books online. It has many examples also.