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

obat limfoma said:


September 23, 2018 6:52 PM

Arnav Nihaliya said:

Tech Support Phone Number Phone Number for tech support provides people with latest information in a very less time and in a very speedy way. One can get the help of a technical support engineer in various ways. The most reliable means of communicating with them are either by calling or by email or by chatting online .

September 27, 2018 4:13 AM

Arnav Nihaliya said:

September 27, 2018 4:14 AM

Arnav Nihaliya said:

September 27, 2018 4:14 AM

Arnav Nihaliya said:

September 27, 2018 4:16 AM

Sophie Taylor said:

The aim was to test the effectiveness of wireless operations in space. This is a substantial step for future long-term missions such as the one planned for Mars.

October 31, 2018 4:41 AM

Kiaan Roy said:

Finally, you’ll need to consider some other options including field upgrade options if your card printing needs change down the road, operating system compatibility (not every printer is Mac compatible, for example!), and the manufacturer warranty.

November 2, 2018 12:42 AM

Kiaan Roy said:

Mid-sized organizations often look for ID card printers that are powerful and flexible enough to handle all their needs, from creating long-lasting employee IDs to retail rewards and membership cards.

November 2, 2018 12:43 AM

Kiaan Roy said:

Medium-sized organizations use ID card printers to print cards for every possible need including employee IDs, student IDs, membership cards, and more. Because they are used in such a wide range of industries, the features you’ll find most often are designed to give your organization flexibility:

November 2, 2018 12:43 AM

Kiaan Roy said:

Each system includes a printer, Printer software for PC or Mac, blank cards, a printer ribbon, cleaning supplies, and a camera so you’re ready to go right out of the box!

November 2, 2018 12:43 AM

Kiaan Roy said:

Dual-sided ID cards are great because they give you twice as much space to print cardholder information. But if you already have a single-sided printer, can you print dual-sided cards?

November 2, 2018 12:43 AM

Kiaan Roy said:

Single-sided ID card printers are built to only print on a single side of your cards – the card goes into the printer, is printed on, and then ejected. There is no way for the printer to automatically print on the second side, unlike a dual-sided printer.

November 2, 2018 12:44 AM

Leave a Comment


This Blog


Favorite Non-technical Sites or Blogs

Privacy Statement