Your Daily Cup of WTF - tblStaffDirectory

re: Your Daily Cup of WTF - tblStaffDirectory

Sjoerd Verweij — Sat, 05 Jun 2004 05:28:00 GMT

Awesome. A full 8K page for every non-null property of this entity...

WOW.

Your Daily Cup of WTF - tblStaffDirectory

TrackBack — Mon, 24 May 2004 13:13:00 GMT

re: Your Daily Cup of WTF - tblStaffDirectory

AndrewSeven — Fri, 21 May 2004 18:51:00 GMT

I once had an architect and a DBA who came up with an equivalent suxtem, but the had an IsElement IsAttribute and Names.

We didn't have to write the queries and all the data was provided FOR XML AUTO which we were able to convert into recordsets or into deep and complex object heiarchies in VB6.

Sarcasm dead? Tha sounds like a really brilliant idea. I can recommend an arch to help with that.

re: Your Daily Cup of WTF - tblStaffDirectory

Alex Papadimoulis — Fri, 21 May 2004 16:25:00 GMT

*sigh*

Sarcasm is dead.

re: Your Daily Cup of WTF - tblStaffDirectory

Mischa Kroon — Fri, 21 May 2004 15:04:00 GMT

my opinion:

http://sphear.demon.nl/weblogs/mischa/archive/2004/05/21/898.aspx

re: Your Daily Cup of WTF - tblStaffDirectory

ruurd — Fri, 21 May 2004 11:42:00 GMT

maybe denny should submit his own table scheme's to this blog?

sorry man, read between the lines

re: Your Daily Cup of WTF - tblStaffDirectory

denny — Thu, 20 May 2004 22:19:00 GMT

I have done this kinf of thing for a set of "User Defined" items in an app but as was posted... indexing and sql server optimizing just got dumped to heck....

5 - 10 seconds you say?? you don't think the users mind?? what happens when you get say 50 hits on that in a 10 second time ?? bet it chokes and some users get errors....

where a normal db will be able to list that same data for say 1,000 users in say 1-2 seconds every time... no errors no lag.

sorry this is a good idea used for the wrong thing...

re: Your Daily Cup of WTF - tblStaffDirectory

Wim — Thu, 20 May 2004 20:54:00 GMT

You can't be serious! This sure is one way to kill performance...

Indexing down the drain, execution plan can't be optimized, bastardized datatypes, unmaintainable (speak of maintenance) overly complex queries, I could go on.

re: Your Daily Cup of WTF - tblStaffDirectory

brady gaster — Thu, 20 May 2004 20:54:00 GMT

i'm so so so so so all about this thread. i think you should change the entire focus of your blog and just do things like this.

heck, why not buy "dailydoseofwtf.com" and we'll ALL contribute!

YEAH!

re: Your Daily Cup of WTF - tblStaffDirectory

Jerry Pisk — Thu, 20 May 2004 20:32:00 GMT

Heh, even if you say it was Unicode you'd still be wrong, because you said bytes, not characters ;) Otoh people who ask you such a question are not the ones to realize that.