Viewing 15 posts - 45,016 through 45,030 (of 59,063 total)
What you call a "normal" table structure may be the best or the worst or somewhere in between. You asked a question with no real information to go on...
February 21, 2009 at 4:03 pm
KT8177 (2/20/2009)
select *
from openrowset('Microsoft.Jet.OLEDB.4.0'
...
February 21, 2009 at 3:42 pm
Make sure you read this fully
Heh... right... read 19 pages of posts... some with some pretty bad information (not yours). Can you summarize, please?
February 21, 2009 at 3:41 pm
Edward Boyle (2/21/2009)
That said, I use both Tally...
February 21, 2009 at 3:28 pm
I absolutely agree... It's not what you can backup... it's what you can restore. I do at least one "practice" recovery a week and I'm not the System DBA....
February 21, 2009 at 3:20 pm
It's a "Catch 22". Only Developers that actually concern themselves with things like performance, scalability, and documented code would ever take the time to add such instrumentation to the...
February 21, 2009 at 3:17 pm
Please see the following article... for performance reasons, you may want to reconsider and use simple cross-tabs, instead.
http://www.sqlservercentral.com/articles/T-SQL/63681/
Also, if you'd like a tested answer to your good question, please see...
February 21, 2009 at 3:06 pm
Jeff Moden (3/31/2008)
GSquared (3/3/2008)
Just did some tests.The XML version is faster, significantly so, than the Numbers table version, for parsing out a string.
Any bets? 😉 Post your test data...
February 21, 2009 at 12:03 pm
BWAAS-HAA!!! Now you know why I like Tinker Toys... it's real easy to find the red sticks. 😛
February 21, 2009 at 11:51 am
I agree with that... searchs on this forum, ummm... suck. (Sorry, no nicer way to say it). How can we tell the users to do a search when we...
February 21, 2009 at 10:55 am
In high school and before, we'd play a bazillion different card games... mostly Poker, Spades, and HiLoJack. At home, it was Pinochle, graph paper battleship, graph paper road race,...
February 21, 2009 at 9:53 am
GilaMonster (2/21/2009)
February 21, 2009 at 8:23 am
Ninja's_RGR'us (2/21/2009)
Credit is due and all good, but that still does not answer the question....
True enough... we were waiting on some test data so we could show some tested code.
[font="Arial...
February 21, 2009 at 8:18 am
Lynn Pettis (2/20/2009)
February 20, 2009 at 10:34 pm
Viewing 15 posts - 45,016 through 45,030 (of 59,063 total)