The bottom line is... if you expect the database to grow back to the same size in the next week or two, don't shrink it...

I've already proven that it will return more than one NEWID()... just not the way you did it because the view only returns one row. Go back and look...

ywb (7/6/2008)

---

Hi Jeff, just fyi, it's for a marketing application. We send promotion info to our users on a regular basis. Different promos are available to different number of users,...

I agree... WHY? The methods shown on those links do not accomplish the task requested (eventually) by the original poster....

colin Leversuch-Roberts (7/6/2008)

---

I have to agree with Jeff - there needs to be a better way of becoming certified without cramming with transender. I did one exam which I failed,...

There is no doubt in my mind... you would pass with flying colors because you never lie. 🙂

rbarryyoung (7/5/2008)

---

Jeff Moden (7/5/2008)

---

If you...

All that and a helmet with good grill-work! 😀 Thanks for the feedback, Barry! 🙂

I agree that operators should start a...

Ok... here we go... other than personal preference, what are the practical reasons why you do this?

bitbucket (7/5/2008)

---

Jeff ran your codea and got the following:

@Day @monday ...

... and THAT's precisely what I'm getting at... neither the cert nor the degree really matter because some cheat at both and the good guys will shine no matter what,...

I think multi-cores are going...

Heh... I thought you said it was cleaned up... it has leading commas in it 😀

That's where you and I may differ... I don't ask...