Viewing 15 posts - 3,106 through 3,120 (of 5,685 total)
EDIT: Removing my rude and unnecessary comment.
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...
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...
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...
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. 🙂
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...
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:
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...
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...
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...
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...
May 26, 2011 at 3:51 pm
Craig Farrell (5/26/2011)
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...
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...
May 26, 2011 at 2:42 pm
Jake Shelton (5/26/2011)
May 26, 2011 at 2:36 pm
Viewing 15 posts - 3,106 through 3,120 (of 5,685 total)