Matt - well said. Thanx!

1. Documenting what the system has now, just as a record and to support future comparisons: Use a manager tool to script EVERYTHING you possibly can. Be...

Rather than just free form 'dump' everything, why not design what your documentation requirements are. In particular, if you want to stop the shooting, ask (not demand) of your...

I find it interesting that either spid51 or SYSTEM was the user. was it predominantly SYSTEM? or was just the first instance spid51? That may be a...

You ARE going to look over the rookie DBA's shoulder while he/she cleans up their own mess, right?

would that not still be only one record, found by datetime and one team name?

OFF_COD between '0000' and '9999'

vs.

OFF_COD <= '9999' (or, OFF_COD < 'A')

- using a single '<' rather than between might speed up execution a little. I'm synthesizing above posts to...

1. Are you using task manager from the operating system level to identify the 100% usage, or performance monitoring from inside SQL Server?

2. Are the devices dedicated solely...

could you provide us with the source that google found you, or at a minimum the search string you used on google?

Yogiberr - congratulations on being the recipient of a passed buck.

What you have not shared with us, is what leads you to conclude what the primary purpose of the...

I find it interesting that you are constraining on HomeTeam, AwayTeam and gamedatetime. You only need one team name with gamedatetime, right? Because no one team can play...

You may find this thread helpful:

http://support.borland.com/thread.jspa?messageID=2201

alternatively, why are you committed to this particular, out of date version of the software (4.2)?

IF the database is defined with a non-local time for storing time internally (e.g. using system clock and setting all time entries to GMT), and the users' work stations have...

Can you elaborate on 'this'? I understand 'all the time'. Also, I thought that blade servers big advantage was the ability to rack mount many of them in...

Gail - thanks for the explanation on the table identification - is it necessary to translate to decimal rather than using the '0x...' format in the query?

Joe - since the...