Sameer-

Thanks for your suggestions.

Yesterday, I did try a select * from ... on both servers.  This time "same building" performed slightly faster than "1000 miles".  Although both were fast and maybe...

Hmmm, supervisor says read for one hour a week on company time.  Employee doesn't want to.  Supervisor suggests to the employee not to let the door hit backside on the...

I start with my daily e-mail from SQL Server Central, of course.

Scott

Running a trace will quickly identify frequently used applications that use sa.  However, there are still going to be some obscure, used once every three months, utilities that aren't going...

Unfortunately, "testing in production" tends to be our most popular method too.

Bad question.

Technically you don't HAVE to enable it, but ....

You can limit a Google search to a particular web site by entering a domain in the advanced search properties.

Scott

You must upgrade a 6.5 database to 7 or 2000 first.

Scott

but I was told that only the back end file is converted into SQL and the users can work normally without changing anything to the queries, objects

I went through...

I use DTS on a legacy SS7 system to populate a roll up server.  This has been in place virtually untouched for years.  Although it is not fool proof, it...

How can someone complain about their job being outsourced when they themselves outsourced their education?

Regards,

Scott

You know, it looks like I never implemented it.  Although I can't remember the reason, it must be because other things came up.

If you try implementing it, let me know...

max doesn't apply to SQL Server 2000.  However, the question should have specified whether it was Unicode, in which case the maximum would have been 2^30.

Scott

Hey thanks for the new trick.  It was news to me and I will use it moving forward.

Scott

One of the biggest problems that I face in a rural area is the telephone company.  When they first installed our line, they piggybacked on the line that ran to...