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