If I was in hurry I would go with something like....

-- To allow advanced options to be changed.

EXEC sp_configure 'show advanced options', 1

GO

-- To update the currently configured value for...

I've seen a job which 'rebuilds' indexes to cause the log files to grow pretty big. Not quite to 4 x the size of the data file however.

I think I read some where that after adding a new environment variable that you have to reboot. Is that true?

I did a truncate table and that sorted it - thanks.

The database used to be on a SQLServer 2000 machine, so I guess that the issue was left over...

sp_spaceused 'ImportCustomer'

Gives....

name=ImportCustomer

rows=0

reserved=874776 KB

data=571048KB

index_size=16KB

unused=303712KB

thanks

David

Is using NOLOCK a good idea? Quite a lot of people post sql on this site where they are specifying it, but I have always avoided its use.

My...

A possible sign that your statistics are out of date is if the actual and estimated row counts in the execution plans are very different.

I expect that you know, but...

You might be able avoid the key lookup (28%) by including the following columns on your index

[DWH_Reporting].[dbo].[rep_business_unit].rep_bu_key, [DWH_Reporting].[dbo].[rep_business_unit].bu_client_name, [DWH_Reporting].[dbo].[rep_business_unit].bu_manager_name, [DWH_Reporting].[dbo].[rep_business_unit].bu_facility_manager_name, [DWH_Reporting].[dbo].[rep_business_unit].bu_category_02_name

Also, can the union be a union all ...

N G (1/28/2009)

---

I'm sorry what do you mean by pricey -- you didn't list a cost?

your solution is exactly the kind of thing we are looking for; if you don't...

A couple of options we looked (are looking at) are

Using a SafeSentry USB hard drive. This is both fire and water proof. A bit heavy to carry home...

Out of interest, what's the performance like if you run the sql without the joins to your validation list.

ie. exclude the joins past this bit and remove some columns from...

Have you tried updating the statistics on the tables

Also, you could try the MAXDOP 1 option to prevent the parallel plan

David

To get around point 2, you could have the policy of running the scripts against the database which is the exact copy of live before deploying it on to...

Why not have two databases, a dev one and a support one. The support is created each night based on a backup of the live database. The dev...

Not sure that I fully understand your question, but this might help

select *

from Products P

join Products P2 on P.ProductName = P2.ProductName

and...