Viewing 15 posts - 2,416 through 2,430 (of 2,443 total)
Jeff Moden (5/22/2008Heh... First off, I never build a Tally table using a While loop except for demonstrating how slow it can be. If you only do it once,...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 23, 2008 at 6:07 am
All right Jeff, I was having fun with your tally table example and trying to think set-based on how to clean up a column that included non-alpha characters. I...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 22, 2008 at 8:57 am
The theory goes that it's either a 'fat finger error' or a 'fat head error', this one was both. Needed to either add a space in my final addition of...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 21, 2008 at 12:02 pm
In case anyone else wants to use Jeff's example and is lazy like me:
copy/save as a template (.tql) under C:\Program Files\Microsoft SQL Server\80\Tools\Templates\SQL Query Analyzer--------------------------------------------------------------------
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 20, 2008 at 3:14 pm
Matt Miller (2/27/2008)
Jack Corbett (2/27/2008)
Yeah and another version coming this fall.
Kick a man while he's down ,heh? (just kidding). It would be nice if those going over BOL...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 20, 2008 at 11:56 am
Jeff, BOL says this -
Permissions
Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.
If I can't convince almighty DBA to make me either, I'm screwed?...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 16, 2008 at 11:46 am
Thanks to both, 8192 should work. 😀
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 16, 2008 at 11:15 am
Trombonist - Jazz Performance. I don't play anymore, but want to get back into jazz piano so I can entertain myself. I always just played for myself anyway, and trombone...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 15, 2008 at 5:51 am
Personally, I prefer responses from folks who are logged in, so you can see who the responder is. Starts the names sticking in your head when you like the response....
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 13, 2008 at 5:54 am
Article says "SQLServer 2000 and Windows 2000 ONLY" - will this not work in XP?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 12, 2008 at 7:32 am
Derek Karpinski (5/9/2008)
Favourite code comment I've encountered (at another place)// don't know why this works, it just does
lol I've been guilty of something like that. "--I don't know...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 9, 2008 at 9:04 am
I don't write because I don't have any business writing (yet). I'm still absorbing all that knowledge that you folks have sweat blood to gain, and consequently I am reaping...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 9, 2008 at 6:50 am
Luke L (5/5/2008)
Additionally, If you are looking to try to push people from paradox to SQL server, look for valid business reasons and ways that you'll be able to provide...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 6, 2008 at 8:38 am
Steve - "Being the "Voice of Microsoft" has a nice ring to it "
Thou blasphemer! May the mighty Bill smite thee with a pox!
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 5, 2008 at 6:24 am
Erik Hunter (4/30/2008)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 30, 2008 at 6:48 am
Viewing 15 posts - 2,416 through 2,430 (of 2,443 total)