Thanks for this post...

It was the USE command for me.

I've had 2 19" Monitors for about a year now, and I'd NEVER go back.  We use Villatetronic video cards to give us the multipe monitor setup on our laptops. ...

Good article.  Used the exact names of the index methods many times(so it should be easy to find in the future).

However, who really needs help in tuning a simple (select somecolumn1,...

You can use Table variables....

Someone correct me if I'm wrong, but I think that you will want (at least) standard edition.  Also, I am pretty sure that if you will be connecting to the...

I've found this script to work best for us.

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=26

Good Luck!

Good tips all.  However, I had to also run this script to shrink our 20gb log:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=26

How about running 2 simple update statements.  I haven't verified this synax, but how about this:

--Update 1

Update A

 Set A.Debit_Amount = A.Debit_Amount + B.Amount,

   A.EndBalance = A.Begin_Balance + (A.Debit_Amount+A.Credit_Amount) 

From...

We have an office in Las Vegas, and sidekick service there has been an absolute nightmare.  Our main office is in Indianapolis, and everything is fine here.  However, no one...

If you are going to consider as sidekick, take a good look at a treo (or any other smartphone).  I think that you'll be much happier with it over the...