I would not want to install SQL server on the DC.. 😉 There are lots of reasons why the snapshot might not start. The SQL Server and agent are running...

We did the same thing at our shop. What we did was we set up Log shipping to keep the DBs in sync. Once all traffic was cut off to...

I did not understand what you are asking. Can you be a bit more precise please?

Atlast the water cooler has come alive again..Yeaaaa...!!! I was getting withdrawal symptoms...:hehe:

Maybe your stats are going out of date and lots of bad plan/compile is happening. Check how much memory you have. If there is not enough memory, then it will...

I have a whole drive way to do... I have no clue if I can do it.....;-) Not strong and No Stamina...:hehe: Getting old you see...:hehe:

Thanks Silverfox, I felt that it was strange that he would suggest doing this just because it worked for him in one scenario. A sledgehammer approach is what I thought...

Can someone clarify why you should do this?

I know what CXPACKET is and I know what NUMA is. But I still do not understand why you want to penalize rest of the queries by restricting it. Restrict...

Atlast I see some action in the cooler. people venting..:-) I was afraid that with out the venting everyone would just blow up soon

:hehe:

Blind update is when you are updating all rows in the table without any condition. No WHERE CLAUSE.

The update I gave you will work. It will update CU_BANK_ANALYS with...

I finally figured out what I want to write about for SQL Server Standard (Atleast attempt but I know it will be rejected) but I cant seem to write even...

So you have decided what you are going to write for SQL Server Standard?

If you want to update CU_BANK_ANALYS for all rows that has CUUSER2 as 274, you have to use the Where clause. Right now you are doing a blind update. You...

The water cooler has been too quiet for my liking. I am getting withdrawal symptoms. What is happening? Where is everyone? 🙁