Well, I will definitely try the drop & create suggestion and I will also consider the other points. Right now, I am on holiday in Cornwall for a week but...

I was afraid that might be the case. Many thanks for the reply and the link to those articles, Grant. I better go give the good news to...

Thanks both of you - you've given me the answer. Even though the query engine is still scanning the whole table, using the wildcard is still slower as it...

Sure.

Stats and plan for the fast query:

Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead...

Thanks for your feedback, guys - that confirms my opinion. Is anybody able to give me definitive reasons that I can go back to the dev team with to...

Hi amc. It works like a bar chart. For every minute a job is running, an 'X' is printed. For every minute it is not running, a...

Yes, the link is broken. But I found it here...

http://www.biblereadingschedule.com/nucleus/?catid=6&blogid=1

Hi,

Looking at this from another perspective, you could say that the difference is 5.

😛

Martin

Hi,

if your company is happy to spend a bit of money, then Red-gate to a tool called SQL Generator which will create as much data as you like. It...

Oops! sorry! 😛

http://www.sqlservercentral.com/scripts/Jobs/66476/

Hi Brandie,

I submitted the following script a while ago which might help you out. Like the post above, it uses the REPLICATE function.

http://www.sqlservercentral.com/Contributions/Edit/66476

HTH,

Martin

Michael is correct, Scott.

A foreign key and an index are two different objects designed to do two different jobs. A foreign key constraint is there to ensure data integrity...

Hi Jim,

The thing to do is to change the timings in your job. In the Job Schedule Properties dialog box, adjust the Starting at: and Ending at: to have...

In desperation, I rebooted the DB server and now it works fine. Still no idea what the problem is but after spending a day looking, I don't care much.

Thanks...

Thanks for your replies Jack & Steve.

We only have one DC and I have now tried the same setup on a different DB server and it works fine; the user...