Viewing 15 posts - 4,066 through 4,080 (of 5,678 total)
MB-400824 (2/10/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 10, 2011 at 1:32 pm
A very handy article, Jeremiah, especially the revised one. Thanks for pointing it out. Much reading to be done!
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 10, 2011 at 1:25 pm
adonetok (2/10/2011)
SSCommitted, thank you so much. It works great!!!
Heheh, my pleasure, glad it works for you. You understand what it's doing, I hope?
Also, just an FYI, my name's Craig...
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 10, 2011 at 1:05 pm
aksheela (2/9/2011)
I am doing multiples deletes at a time using the front end of the application that is through ADO.Net recordset.
Do you...
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 10, 2011 at 12:32 pm
Chrissy321 (2/9/2011)
So the only place I use the parameters is in the SELECT not the WHERE. Would that still be considered to be parameter sniffing? Or some type of variant...
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 10, 2011 at 1:18 am
Portlander (2/9/2011)
Craig Farrell (2/9/2011)
I'd really like to see the full proc and ddl here, this thing is a tragedy.
No arguments there. Hence the subject (How to improve performance...
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 10, 2011 at 1:13 am
I don't know the answer offhand, but out of curiousity, why do you care? Are you just simply curious or do you have a distinct criteria for it?
Now, if...
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 5:23 pm
A number of them. To answer your first question, yes, a bad execution plan can get stuck in cache. Look up 'parameter sniffing', you'll find an eyeful. 🙂
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 5:20 pm
|--Stream Aggregate(DEFINE[Expr1009]=MIN([testdb].[Table1].[id])))
|--Nested Loops(Left Semi Join)
|--Nested Loops(Left Semi Join)
...
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 5:16 pm
^ What Grant said. 🙂
I personally prefer individual scripts and jobs for my backups (and maintenance in general) to fine tune my control... and to make sure backup #23 failing...
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 5:13 pm
I just took a second look at your code. Okay, that is a significantly STRANGE clause.
and exists
(select id from Table1 where calendar_id = 'Test1'...
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 5:04 pm
Portlander (2/9/2011)
UPDATE STATISTICS Table1
WITH FULLSCAN, NORECOMPUTE
And verified that it has no impact on...
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 4:46 pm
It won't be able to happen immediately until the snapshot is sent over and in place before the transactions can start being shipped. You can trigger that to 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 4:05 pm
The squares simply mean they're out of the standard character set for the font.
There's no gentle way to do this, you need to loop to each character, evaulate the CHAR()...
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 4:03 pm
The first and most likely cause of a slowdown after a version upgrade in SQL Server is table statistics.
Take all the tables in the offending query and rebuild the statistics...
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 3:50 pm
Viewing 15 posts - 4,066 through 4,080 (of 5,678 total)