Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Execution Plan Cursors Expand / Collapse
Author
Message
Posted Saturday, December 21, 2013 12:50 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
Comments posted to this topic are about the item Execution Plan Cursors






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1525288
Posted Saturday, December 21, 2013 12:51 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 6:40 AM
Points: 3,683, Visits: 4,818
Nice one, thanks, Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1525289
Posted Saturday, December 21, 2013 11:34 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 3:59 AM
Points: 929, Visits: 380
If it`s going to make you dig `n` search, then it`s a good question (most probably).

Thanks Steve.
Post #1525321
Posted Sunday, December 22, 2013 6:13 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 20, 2014 6:00 AM
Points: 588, Visits: 276
Steve, good question. Thanks.
Post #1525349
Posted Monday, December 23, 2013 12:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:46 AM
Points: 1,371, Visits: 1,547
Hany Helmy (12/21/2013)
If it`s going to make you dig `n` search, then it`s a good question (most probably).

Thanks Steve.


+1


~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1525424
Posted Monday, December 23, 2013 2:43 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 6:52 AM
Points: 470, Visits: 823
very good start of the week and QotD

Thanks for sharing Steve.
Post #1525449
Posted Monday, December 23, 2013 5:41 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 10:37 PM
Points: 3,306, Visits: 2,351
I liked the question, as it made me do research. Thank you, Steve.


Tally Tables - Performance Personified
Best practices on how to ask questions
Post #1525492
Posted Monday, December 23, 2013 6:44 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 7:35 AM
Points: 1,625, Visits: 2,034
Wasn't really sure when I clicked 'submit'. I would have thought that KEYSET was a TYPE of cursor, and not the operator that generated the cursor.

For example (stolen from a 2007 Grant Fritchey post):

DECLARE CurrencyList CURSOR KEYSET FOR
SELECT CurrencyCode FROM [Sales].[Currency]
WHERE Name LIKE '%Dollar%'

But, since none of the other choices seemed correct, I went with it and was rewarded with another point I can put in my retirement account.



Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1525521
Posted Monday, December 23, 2013 7:42 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 1:15 PM
Points: 673, Visits: 199
Can I get 1 point for getting 1 right?
Post #1525541
Posted Monday, December 23, 2013 9:22 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 12:05 PM
Points: 3,569, Visits: 72,411
Thomas Abraham (12/23/2013)

But, since none of the other choices seemed correct, I went with it and was rewarded with another point I can put in my retirement account.



What is the current SQL Server Central point conversion to US Dollar ratio these days anyway?




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1525579
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse