Not my job to judge, but "Well Done!", Flo. 🙂

Consider the OP in the following... Lynn may have competition for saint-hood... 🙂

http://www.sqlservercentral.com/Forums/Topic670491-338-1.aspx

Gift Peddie (3/7/2009)

---

No I know how cross JOINs without the where clause can make TempDB grow because most RDBMS query processors use those JOINs to increase JOIN performance. But...

Gosh, I don't know how to build a policy. But, as a side bar, I'd never use a policy that forced any object name to use a prefix such...

That's the first time I've heard of someone writing a CLR stored procedure and I'm curious... what does it do?

I'd recommend that you never import 3rd party directly to permanent tables. I always do the imports to temporary staging tables so I can validate the data as being...

Gift Peddie (3/7/2009)

---

Hi Jeff,

The link below says Trace Flag 1118 is not really needed in SQL Server 2005 and above because of changes made. The user is supposed do...

I agree with what's been said, already. The paradox of "emergency changes" is that's when bad code and mistakes are most likely to happen simply because there's a rush...

Bob Hovious (3/7/2009)

---

Until you all get to that point, I wonder if I could run a piece of code past some of you? It's a handy technique...

Actually, it compresses it as it's saving it for both a time savings and disk storage savings right up front. And, restores are "snap" simple. I can see...

Two way street, please... what was that code issue and how did you fix it?

Thanks for the feedback, Wayne. I appreciate you taking the time as well posting your data in such a readily consumable format.

As a sidebar, even though it makes for...

Absolutely... and, as Jules already pointed out, it will require the use of some...

I recently went through such a thing... for the second time...

It was simply "bad" code where a developer didn't understand the relationship between a few tables and created what amounts...

Actually, in SQL Server 2k5, we don't need to solve the running total problem for this because it's just a ranking problem... this should do it...

;WITH

cteGroup AS

(

SELECT...