Viewing 15 posts - 3,106 through 3,120 (of 5,678 total)
EDIT: Removing my rude and unnecessary comment.
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
May 27, 2011 at 2:46 pm
Syed Jahanzaib Bin hassan (5/27/2011)
If you have multiple processors then useMAXDOP query hint option in the end of the query
how to apply query hint then visit on this link
What...
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
May 27, 2011 at 1:09 pm
mister.magoo (5/27/2011)
Yes, I understand that principal better now - that's why I changed the query to include that specific ORDER BY.
Ah, sorry. Misunderstood your confusion.
1. Why does this query...
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
May 27, 2011 at 1:01 pm
al_nick (5/27/2011)
Craig-This works perfectly.
Was not familiar with "Cross Apply",
Glad to hear, and my pleasure. 🙂
What would you see in the way of optimizations? Indexes on the "id"s on the...
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
May 27, 2011 at 12:52 pm
Brandie Tarvin (5/27/2011)
I had to add my two cents about Craig's article and blog about it too. I hope that drives more traffic to the site.
Cool, that's always nice. 🙂
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
May 27, 2011 at 12:50 pm
The two triggers are "instead of" and "after" for SQL Server. One triggers on the data on its way in, the other triggers with access to the data but...
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
May 27, 2011 at 12:48 pm
*facepalm* MUST LEARN TO READ, CHOOSE 2... and I go and click 3 of them.
D'oh! :blush:
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
May 26, 2011 at 6:31 pm
Jan Van der Eecken (5/26/2011)
Anyhow, I hope my comments on that thread didn't put him down even more...
Nah, you're good, and thanks. 🙂 I just re-read the article to...
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
May 26, 2011 at 5:26 pm
CXPacket waits are not bad things directly.
It means that the internal optimizer isn't balancing the load between the threads perfectly, and some end up waiting. It could be they're...
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
May 26, 2011 at 5:24 pm
Jake Shelton (5/26/2011)
Hi Craig, glad you replied and I was pleasantly surprised you were around to do so as quickly as you did.
I cheated. I get notifications when this...
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
May 26, 2011 at 4:08 pm
I would use a technique like this. Some notes:
1) Notice how I built out the dataset to be easily consumed for testing.
2) This can be continuously expanded as 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
May 26, 2011 at 3:51 pm
Craig Farrell (5/26/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
May 26, 2011 at 3:20 pm
Anyone tell me if I was a bit too heavy handed here? He didn't get me riled, I'm just not sure it reads well. It looks fine to...
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
May 26, 2011 at 2:45 pm
Jan Van der Eecken (5/26/2011)
GilaMonster (5/26/2011)
From the posts the person has made, they are totally out of their depth. 6TB DBs, major perf problems and barely...
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
May 26, 2011 at 2:42 pm
Jake Shelton (5/26/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
May 26, 2011 at 2:36 pm
Viewing 15 posts - 3,106 through 3,120 (of 5,678 total)