It also depends if you are hosting a catalog server (static data) or other database that are always changing.

If static, you could refresh your database so that it is always...

I think we house some GIS data.  It can grow to be a very large database (40 to 50 GB).  I am not familiar with the application so I can't...

I think in this case, you might want to set up an alert that would start a job that go back at that time to read the log file and...

My husband once showed up at the interview and the company gave him paper test and a pen to answer and his response... good bye and don't call me back.

The...

I am happy that you are able to schedule weekly reboot.  I think you should feel happy and lucky to have that type of privilege of rebooting your server.  For...

Could it be that you stop sql server without knowing it? 

Is the Icon color on your server connection in the Enterprise Manager Green or Red?  If it is red,...

Did you log on locally using the service account of the sql server?  Are you able to send out email via outlook?  Sometimes all it takes is to reboot sql...

If I were you, I would re-install sql server.  Also when working with system database, there are special procedure on how to move them, you can not just detach and...

Do you have high transaction going on.  I have the same problem on our datawarehouse server but it's because we set the transaction log to auto growth.  It just keeping...

Intersting concept.  My co-worker onced told me that he would love to pay a million dollar in tax because that mean he has at least a million dollar after tax...

Is there any reason why you want 929 version?  I think it should make sense to put ms03-031 first before you put 929 just in case 929 doesn't include that...

My daughter is 3 years old(will be turning 4 in a few months), and my son is 2 years old.  They both enjoy playing on the computer.  My daughter can...

SELECT a,b,c FROM TableXYZ

WHERE a in (1,2,3)

and b in (1,2,3)

and c in (1,2,3)

depending on what you really need and want you could also do another query like:

SELECT a,b,c FROM...

You could find out the SPID of your process and kill that process.  It could be stuck in roll back depending on how many rows are being deleted.  After rollback. ...

1.  I would want to know what are your sql sever version on the old box. 

2.  Reinstall sql server to that version.

3.  restore master.

4.  restore the rest of the...