April 23, 2013 at 1:07 pm
sys.dm_exec_cursors shows nothing =((( how do I view the underlying DDL for the dm_functions?
Dird
April 23, 2013 at 6:23 pm
Dird (4/23/2013)
sys.dm_exec_cursors shows nothing =((( how do I view the underlying DDL for the dm_functions?Dird
dm exec cursors, if I remember right, only displays explicitly called cursors.
What you're calling a cursor in Oracle doesn't really fit here. Now, I'm not an Oracle expert by any means, Junior at best, but they handle data *very* differently than SQL Server does for optimization.
What you really want to inspect is the Execution Plans for queries to start learning how SQL Server handles things under the hood. I recommend you start with Grant Fritchey's book. It's available for free on the site as a PDF download. You'll find it over in the left navigation bar under Books.
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
April 23, 2013 at 11:23 pm
Evil Kraig F (4/23/2013)
What you really want to inspect is the Execution Plans for queries to start learning how SQL Server handles things under the hood. I recommend you start with Grant Fritchey's book. It's available for free on the site as a PDF download.
It's on my to-do list 🙂 along with Bolton's "Professional SQL Server 2012 Internals and Troubleshooting" and like 7 other books that are supposed to be good :s Need to focus on Sybex's MCITP book for now though then the pocket consultant, self target of 70-450 near the end of May 😮 4-5 weeks studying of SQL Server under my belt so far, 4 more weeks to go...unless the practice test is a disaster in 3 weeks time :crying:
Dird
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply