The enterprise edition is one hell of a lot of money for......not really that much unless you are into major league stuff.

I would work out precisely what it is that...

I tend to follow the practice that if the table is in the middle of a query then I need a single unique field to act as a primary key.

If...

My understanding is that, as a transaction log is a sequential file writing into it doesn't cause performance issues.

That said I can see performance issues arising in the following areas.

• Disk...

Good Lord!!!!!!!

Well, make sure your first statement in the procedure is SET NOCOUNT ON, which should speed the thing up.

I would definitely break this...

If you are mixing and matching DDL with DML then you are almost certain to get recompiles.

The way that I would approach the problem is to break out the proc...

Could you be a bit more specific?

Do you mean the reporting services reports, error reports, results for QA etc?

I found that the best way of comparing text execution plans was to export them into text files then import them into source safe and use the compare function.

Crude I...

Absolutely.  There should be very few SysAdmins.

You can assign owners to jobs and therefore sysadmin role is not needed.

Provided your user exists within MSDB they can use sp_Start_job etc, but...

Books on-line says that any user who is in the public group within MSDB can list the jobs that they own.

If you want to list jobs you don't own then...

When you use a UNION clause it does an implicit SELECT DISTINCT.

If your two selects produce completely different records then change the UNION to UNION ALL.

Also, qualify the multiid in...

Just curious, why don't you have AND Shifts.dtShiftdate < GETDATE()-1 in the first query when you have it in the 2nd?

I would also go for the backup/restore method but make sure that you transfer logins first, otherwise you will get broken users.

If your two servers have different sort orders, code...

If you have a view then you can only use ORDER BY statements if you use the SELECT TOP 100 PERCENT version.

Personally I am not ecstatic about anything that involves coding logins and passwords into stored procedures.

If you use sp_helptext on a stored procedure you get all the code for the...

You need all of them.

If you don't know what the structure is i.e. is notify_level_eventlog an int, smallint, byte it doesn't matter because SQL is intelligent enough to do an...