Blogs about: Execution Plans
Featured Blog
Dame NJ as far as read book of fate in hand Thursday; Mater(Mute unify)
Mademoiselle NJ up to appreciate planets whereupon Thursday; Materfamilias says number one’s likewise trustingPhiladelphia News Special edition- Subconscious self prevailed despisal sweet onstag… more →
Aislinnelp's Weblog
SQLPASS Day 2- Optimization Timeouts and All about TLogs
Kendra wrote 2 weeks ago: SQLPass unfortunately can’t last forever, but happily it’s still going strong. Here … more →
SQL PASS Day 1: To Free or Not To Free the Proc Cache?
Kendra wrote 2 weeks ago: Yesterday was day 1 of SQL PASS 2009. I am attending a variety of sessions on execution plans this y … more →
I Started a Fight
— 2 comments
scarydba wrote 3 weeks ago: I had no idea, but evidently I started a bit of a donny-brook. Cool! … more →
Hey, ho, where'd you go...
scarydba wrote 1 month ago: Ohio? I’m presenting on Thursday to the Columbus SQL Server Users Group, home of the newly min … more →
Gila Monster on Estimated vs. Actual Row Counts
scarydba wrote 2 months ago: I don’t generally do lots of blog aggregation and cross post linking & stuff. It’s j … more →
execution plans hints
umesh pandit wrote 2 months ago: Whenever any of your query performs slowly, you can view the estimated (And, actual if required) exe … more →
No Join Predicate
— 10 comments
scarydba wrote 2 months ago: You could be looking at an execution plan on a query and see this message: Warning, No Join Predicat … more →
Spools in Execution Plans
— 4 comments
scarydba wrote 2 months ago: I got the question the other day, when are you likely to see a spool in an execution plan? Easy, whe … more →
Who's Using All that Space in TempDb, and What's their Plan?
Kendra wrote 2 months ago: Whatcha Doing in My TempDb??? This post contains a script that I adapted from the fantastic SQL Serv … more →
Rownum effects
— 4 comments
Jonathan Lewis wrote 3 months ago: A few months ago, I wrote a note about setting the optimizer_mode to one of the first_rows_N values … more →
Execution Plan Compile Termination
— 14 comments
scarydba wrote 4 months ago: Recently I’ve been seeing a lot of people with bad execution plans, desperately trying to tune … more →
Distributed Queries
— 8 comments
Jonathan Lewis wrote 4 months ago: Some time ago I wrote a note about distributed DML, pointing out that the driving_site() hint works … more →
Re-evaluating Execution Plans (again)
scarydba wrote 5 months ago: I keep thinking I’ve got a handle on the way execution plans are dealt with in SQL Server. I h … more →
Explain VIEW
— 12 comments
Jonathan Lewis wrote 5 months ago: A brief note on reading execution plans. ----------------------------------------------------------- … more →
sql server 2005 execution plans free ebook
— 1 comment
Sql Server Collection wrote 5 months ago: Sql Server 2005 execution plans book- Disecting sql server exection plans is freely available at red … more →
Fixed Stats
— 6 comments
Jonathan Lewis wrote 5 months ago: There was a question about the notorious dba_extents view on the comp.databases.oracle.server newsgr … more →
WHOOOP!
— 16 comments
scarydba wrote 6 months ago: I just got the good word, I submitted an abstract for a spotlight session at the PASS Summit and it … more →
Odd Filter
— 2 comments
Jonathan Lewis wrote 6 months ago: A little while ago someone sent me a brief email about an odd section of execution plan that they ha … more →
Finding Plans and Stats for Queries like '%something%'
Kendra wrote 6 months ago: I often need to find a query plan in the cache for a process that has run long overnight. Typically … more →
