Thanks

Don't worry I was being a numpty. I could just DISTINCT on table but I would like to know if the

AND [sp].[modification_counter]/[sp].[rows] > 0.10

is the right sum is your...

Hi Gail

So I guess I need to change my SQL for the loop then as it is showing multiple indexes / statistics for each table. I have tables in that...

e.g like

UPDATE STATISTICS [dbo].[tbl_TRAFFIC_VISITORS] _WA_Sys_0000000C_1DE57479 WITH FULLSCAN

Hi

Sorry, could you give me an example of what you mean.

Is this inside the loop of statistics I am doing (with the EXEC) or is it something else e.g EXEC...

LOL I don't envy my whole existence! Let alone job which includes being off ill with a serious illness yet still called upon to "help" the person who manages the...

Any ideas on how to fix those two problems e.g the FK errors and Target Server without "backing up" the whole msdb server (which I don't have permission to anyway)

A...

Hi

Well, I would I have restored the whole msdb except I am not "in charge" of the DBS and the BODS who are seem to know less about SQL Servers...

Hi

I do have a full table but certain "sys admins" have already added some "important - must have" jobs.

Therefore I am doing this one by one at the moment which...

Ok thanks

I haven't really done anything in CE apart from follow some basic tutorials about checking for and creating a database, and then running some sql. It seemed like it...

Hi the source of my data is from a feed which lists out the courses and the races on each course that day.

There is no human input involved - all...

Hi

Pretty please don't start a debate about natural keys versus surrogate keys! It will go on forever as I've witnessed before.

I am using a surrogate key - RacePK (a unique...

Cheers John, genes are genes and my families are full of Big C all the way down.

Here is the main RACES table DDL with indexes.

I use the original Auto Index...

I know about having lots of indexes being heavy on the writes but this is a read intensive process and I want to get a report for stats as quickly...

Ok, looks like a timed log check then.

Thanks for your help