Viewing 15 posts - 1,531 through 1,545 (of 2,443 total)
CirquedeSQLeil (2/19/2010)
Grant Fritchey (2/19/2010)
---------------------------------------------------------
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."
February 19, 2010 at 2:08 pm
mstjean (2/19/2010)
SuspicionBreedsConfidence****An ironic phrase appearing in the background in one of the greatest movies ever made, but in the context of a SQL DBA's life, a truism.
I love that movie!...
---------------------------------------------------------
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."
February 19, 2010 at 1:15 pm
So what you're saying is we should invest in SA telco?
---------------------------------------------------------
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."
February 18, 2010 at 3:15 pm
CirquedeSQLeil (2/18/2010)
duct tape (pronounced duck tape 😀 )
I always thought it was Duct Ape?
---------------------------------------------------------
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."
February 18, 2010 at 11:08 am
jcrawf02 (2/18/2010)
Gianluca Sartori (2/18/2010)
GilaMonster (2/18/2010)
Gianluca Sartori (2/18/2010)
In that particular case, with the identity column as primary key clustered, yes, doesn't it?
Logical order of the index - yes
Physical order of the...
---------------------------------------------------------
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."
February 18, 2010 at 11:02 am
Andy DBA (2/18/2010)
RBarryYoung (2/18/2010)
...Cursors are much, much more undesirable than Dynamic SQL, and should be avoided at all costs.
All costs? Sounds like trolling, to me. I know my...
---------------------------------------------------------
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."
February 18, 2010 at 10:41 am
Odd, when I force a negative value, it doesn't change the identity incremental value at all? Try the last code, but set to negative anything, I assumed it would then...
---------------------------------------------------------
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."
February 18, 2010 at 10:37 am
Paul White (2/18/2010)
Dan Guzman - Not the MVP (2/18/2010)
---------------------------------------------------------
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."
February 18, 2010 at 10:35 am
simplest answer might be to replace the loop with a join to a Tally table, see Jeff Moden's article on the subject: http://www.sqlservercentral.com/articles/T-SQL/62867/
There may be a better way to do...
---------------------------------------------------------
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."
February 18, 2010 at 8:19 am
Grant Fritchey (2/18/2010)
---------------------------------------------------------
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."
February 18, 2010 at 8:13 am
Gianluca Sartori (2/18/2010)
GilaMonster (2/18/2010)
Gianluca Sartori (2/18/2010)
In that particular case, with the identity column as primary key clustered, yes, doesn't it?
Logical order of the index - yes
Physical order of the data...
---------------------------------------------------------
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."
February 18, 2010 at 8:09 am
That's not entirely true though, if you SET IDENTITY_INSERT ON, you can force identity values that are out of sequence:
CREATE TABLE #temp (iRow int identity(1,1),something char(1))
INSERT INTO #temp
SELECT 'a' UNION...
---------------------------------------------------------
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."
February 18, 2010 at 8:07 am
Alvin Ramard (2/17/2010)
Steve Jones - Editor (2/17/2010)
Alvin Ramard (2/17/2010)
---------------------------------------------------------
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."
February 18, 2010 at 7:59 am
complain about the lack of process improvement...until the shoe is on the other foot, then CYA
---------------------------------------------------------
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."
February 18, 2010 at 7:56 am
athornicroft (2/18/2010)
Hi there is a good thread here about eliminating cursors without the use of sub queries.
Replacing a cursor with a while loop isn't really an improvement, it's still RBAR.
---------------------------------------------------------
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."
February 18, 2010 at 7:55 am
Viewing 15 posts - 1,531 through 1,545 (of 2,443 total)