Excellent question - a client asked me that today and I couldnt answer so I tried it. Gives an error to run DBCC Checktable to check sysindexes. Definitely cannot go...

Service Pack 3 is needed - please deliver!

Lee Everest

MCDBA

SQL Rx

Dallas, TX

www.texastoo.com

Ken was a true gentleman. Always willing to help anyone who had a question. Such a nice guy. Will be dearly missed in our community.

Lee Everest

www.texastoo.com

Thanks Matt. I agree and have come to the conclusion that those not agreeing with the article, or those otherwise opposed to using the relational engine in this fashion, would...

Interesting article - nice job.

Oh how I love the posts stating "don't do this or that" ... you'd think that their authors either 1) got too bloated...

Heheh I've seen some Joe bashing in person - like at SQLPass in Grapevine, TX last year. I was actually on his side, sitting there in the front row. Guess...

Thanks for posting this. Based on comments received for two articles that I've written, I doubt that I'll be posting again anytime soon. To bad these "rules of the road" weren't...

Doesn't sound like you are slowing down any. Good. Live longer!

I'll be heading down that way tomorrow, G'town, to Mom's for Christmas. Hope to plow over as many 'horns as...

Joe you still in the Austin area?

I'm inclined to disagree with the data mart example. If you refer to Ralph Kimball's The Data Warehouse Toolkit he does mention that any data that is mapped or masked...

That comes in Part 2! Stay tuned

You could possibly do that, but the CASE statement is required nonetheless. IE, the order of the decode (3,2,1) must be as such or the AND might occur against the...

You have a point. I really don't think that the code is all that difficult, though. What you might gain is replacing brute-force, or lengthy, DDL statements for this fictitious...

Not only 2000, but what about 7? Or 6.5? Or 4.2! Yes all of them work equally as well. It made more sense to title as I did rather than,...

You could use a number of different data types for this operation - it's personal preference. Lots of folks might be included to use an integer, it doesn't matter. The...