THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Kalen Delaney

Did You Know: My Online Seminar Lasted Almost 5 Hours!

Yesterday was a rebroadcast of the index internals seminar I presented last February, and I had forgotten how long it was. I was in a chat room the whole time, and the questions just kept coming, fast and (not so) furious! Thanks to all the participants for making it a really exciting 5 hours for me. I really appreciated all your enthusiasm.

My next seminar with SSWUG will be on Plan Caching and Recompiling. I always love teaching this topic, because there are so many ways you can make a major difference in performance by understanding when reusing a cached plan is a good thing and when it is NOT! This includes Parameter Sniffing and how to avoid it.

We'll look at when automatic statistics updating kicks in and when that causes recompiles, as well as looking at what other changes can cause automatic recompilation.

We'll talk about XML query plans, and -I'll show you how to access the plan cache metadata to see how to look at the plan for every query currently in cache. It's an awesome capability!

I hope to see you there!


Published Saturday, July 24, 2010 6:06 PM by Kalen Delaney

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



obat diabetes said:

August 1, 2018 11:22 PM

obat bronkitis anak secara alami said:

August 7, 2018 7:51 PM

obat sinusitis said:

August 10, 2018 7:25 PM

obat herbal koresterol terbaik said:

August 23, 2018 11:00 PM

obat usus buntu alami tanpa operasi said:

August 24, 2018 12:23 AM

obat benjolan di tubuh said:

August 30, 2018 7:42 PM

obat wasir said:

September 4, 2018 8:28 PM

Kiaan Roy said:

September 6, 2018 9:27 PM

Taniya said:

<a href="">Check">">Check Support</a>

[URL=]Check Support[/URL]

[url=]Check Support[/url]

[URL=""]Check Support[/URL]

[url=""]Check Support[/url]

September 11, 2018 3:52 AM

Taniya said:

To meet the requests of our clients and organize their projects and comfort, we offer our alternatives 24/7.

September 11, 2018 3:56 AM

Taniya said:

The technique uncomplicated and you just need to go through easy level by level details that will help you to make the difference easily without using cellular mobile cellular mobile cellphone no.

September 11, 2018 4:00 AM

Taniya said:

Users must first restart laptop pc methods laptop pc or pc or pc in ‘Selective Startup’ way to see if this technique could be started.

September 11, 2018 4:04 AM

Taniya said:

This process doesn’t get you guests, now you’re getting worried yet there is another method to fix it, in nevertheless it requires a 100 % free time.

September 11, 2018 4:08 AM

Taniya said:

September 11, 2018 4:13 AM

Taniya said:

September 11, 2018 4:17 AM

Sophie Taylor said:

September 12, 2018 10:53 PM

obat katarak said:

September 16, 2018 5:48 PM

Packers and Movers Gurgaon said:

Manish Packers and Movers Pvt Ltd provides domestic and international packers and movers services in Gurgaon to help you get right and reliable movers and packers company, We offer and help you in selecting Best Packers and Movers services in Gurgaon affordable prices after understanding your exact requirements.

Packers and Movers Gurgaon @

Packers and Movers DLF Gurgaon @

Packers and Movers Sector 23 Gurgaon @

Packers and Movers Iffco Chowk Gurgaon @

Packers and Movers Sector 45, 46, 47 Gurgaon @

Packers and Movers MG Road Gurgaon @

Packers and Movers Sector 55, 56, 57 Gurgaon @

Packers and Movers Palam Vihar Gurgaon @

Packers and Movers Sohna Road Gurgaon @

Packers and Movers Sector 14, 17, 19 Gurgaon @

Packers and Movers Udyog Vihar Gurgaon @

Packers and Movers Faridabad @

September 17, 2018 4:34 AM

obat maag said:

September 17, 2018 7:12 PM

Leave a Comment


This Blog


Favorite Non-technical Sites or Blogs

Privacy Statement