Viewing 15 posts - 76 through 90 (of 8,414 total)
spaghettidba (6/21/2013)
Interesting question.Anyone?
Yep.
June 23, 2013 at 9:00 am
The main issue is the cardinality estimation for the Filter in the MERGE plan: estimated rows 32 million, actual 10 thousand.
The sorts in the plan require a memory grant, which...
June 23, 2013 at 8:51 am
This is a variation of the 'Top N per Group' problem, and there are many ways to express it in T-SQL. Whichever you choose, be sure to make the ORDER...
May 24, 2013 at 1:37 am
Scanning the nonclustered index, there is an implied first key on the partition ID, so the following can use a Stream Aggregate:
SELECT sessionid, username
FROM dbo.AttemptedLogin
WHERE sessionid IS NOT...
April 20, 2013 at 12:05 am
Don't mind admitting I fell for this completely.
Well done, Steve! :laugh:
April 1, 2013 at 5:50 am
NBSteve (3/22/2013)
Paul White (2/26/2011)
March 22, 2013 at 3:15 pm
Jeff Moden (3/7/2013)
I just can't understand why anyone would actually use XML. 😉
The only possible reason is so you can say your indexes are SeXI.
March 7, 2013 at 4:31 pm
Stefan Krzywicki (2/27/2013)
February 27, 2013 at 5:14 pm
ChrisM@Work (2/27/2013)
Anyway, isn't it past your bedtime?
We can no longer be friends :laugh:
February 27, 2013 at 3:43 am
ChrisM@Work (2/27/2013)
I know of at least one other old git who will be cackling his face off reading these posts :laugh:
Oi!
February 27, 2013 at 3:30 am
Lynn Pettis (2/23/2013)
I did qualify that it was in my experience. Could be they are being converted to strings before being sorted.
That's fine, I'm not posting to prove you...
February 23, 2013 at 7:35 pm
Lynn Pettis (2/22/2013)
February 23, 2013 at 7:01 pm
_simon_ (2/20/2013)
February 20, 2013 at 4:26 am
Rob-350472 (2/18/2013)
I'm wondering of the implications of two different update methods, say you're changing a bunch of titles from Mr to Mrs (or something similar), for say 300 records.
The batch...
February 20, 2013 at 2:17 am
dgowrij (2/19/2013)
Could you please clarify what the below statement actually does?
.value('.[1]', 'varchar(MAX)')Especially the '.[1]'
The value XML method is documented in Books Online:
http://msdn.microsoft.com/en-us/library/ms178030.aspx
The '.[1]' is an XQuery expression, where the '.'...
February 19, 2013 at 12:35 am
Viewing 15 posts - 76 through 90 (of 8,414 total)