Viewing 15 posts - 4,096 through 4,110 (of 5,678 total)
Aksheela,
Nice description of the problem and the code, thanks. However, the one thing you left out was the delete statement, so I have a few questions.
Do your deletes occur...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 9, 2011 at 10:06 am
*sighs* Can't really blame you Grant.
GSquared (2/9/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 9, 2011 at 9:39 am
nzngh (2/8/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 9, 2011 at 1:11 am
Lynn Pettis (2/8/2011)
Craig Farrell (2/8/2011)
*sighs* I've failed sainthood. I leave this gentleman in your hands, he can't even debate well, and my patience is stretching to the unprofessional realms.http://www.sqlservercentral.com/Forums/Topic1059167-145-1.aspx
One...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 8, 2011 at 8:51 pm
Tom.Thomson (2/8/2011)
Craig Farrell (2/8/2011)
*sighs* I've failed sainthood. I leave this gentleman in your hands, he can't even debate well, and my patience is stretching to the unprofessional realms.http://www.sqlservercentral.com/Forums/Topic1059167-145-1.aspx
I've joined...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 8, 2011 at 7:45 pm
nadabadan (2/8/2011)
... Snip ...
Computer science theory background? What the hell is bubble tree logic? Hardware buffer usage? You are just writing nonsense to sound intelligent. The algorithm I was referring...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 8, 2011 at 7:16 pm
One important thing I didn't see mentioned here as I breezed through was Disk I/O and SAN organization.
For example, your TempDB is about to be shared to multiple reporting applications,...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 8, 2011 at 5:10 pm
*sighs* I've failed sainthood. I leave this gentleman in your hands, he can't even debate well, and my patience is stretching to the unprofessional realms.
http://www.sqlservercentral.com/Forums/Topic1059167-145-1.aspx
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 8, 2011 at 4:50 pm
nadabadan (2/8/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 8, 2011 at 4:32 pm
nadabadan (2/8/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 8, 2011 at 3:48 pm
A way we used to deal with this on some critical systems, specifically the reindexing, was object swaps.
Copy the table in question, make sure it's auditing so you can re-process...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 8, 2011 at 3:18 pm
nadabadan (2/8/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 8, 2011 at 3:12 pm
:Wow::blink:
Nice idea Lowell... faster by a magnitude of nearly 10. (Edit: Heh, whoops, sorry. Faster 10x at the CPU level, 50% of time at the final timing. I...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 8, 2011 at 2:19 pm
nadabadan (2/8/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 8, 2011 at 2:04 pm
sqldba_icon (2/8/2011)
Thanks Gail. The exec plan has all the table names and database names. I am little hesistant to send it that way. What do you suggest?
Well, you could open...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 8, 2011 at 1:57 pm
Viewing 15 posts - 4,096 through 4,110 (of 5,678 total)