THE SQL Server Blog Spot on the Web

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

Kevin Kline

ICYMI - Adding Filtered Indexes, Wait Statistics, Comparing Windows Azure Performance

Some of my favorite articles originally appearing at 

Dirty Secrets of the CASE Expression
Aaron Bertrand ( b | t ) of SQL Sentry takes a look at some unexpected behavior with the CASE expression and some of its derivatives. Did you know that Aaron is both an uber-genius and a curling fanatic? Improbable, I know.

An Unexpected Side-Effect of Adding a Filtered Index
Paul White’s ( b | t ) deep dive post explains some of the limitations in the special use and usefully special kind of index, the filtered index. When applied in the appropriate scenarios, filtered indexes can greatly improve query performance. But there are some dangers of performance degradation and risk of deadlocks when used improperly.

Knee-Jerk Wait Statistics : PAGEIOLATCH_SH
Paul Randal ( b | t ) of SQLskills adds another chapter in his continuing series on knee-jerk reactions to wait statistics, this time focusing on PAGEIOLATCH_SH. If you don’t know much about wait statistics, be sure to read Paul’s blog post series at SQLskills, starting with Wait statistics, or please tell me where it hurts.

Comparing Windows Azure Virtual Machine Performance
Thinking about the cloud? Glenn Berry ( b | t ) of SQLskills gets into the nitty-gritty details of cost and performance on the various options in Microsoft Azure virtual machines.

Read more SQL Sentry happenings in our monthly eNews.


Connect with me online! Facebook | Twitter | LinkedIn | Blog | SlideShare | Google Author

Published Tuesday, July 21, 2015 8:05 AM by KKline

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



hzx said:


July 11, 2018 11:56 PM

chenjinyan said:


August 22, 2018 11:18 PM

obat batuk kronis said: Obat herbal kolesterol terbaik Obat Batuk Kronis Alami Terbaik Masker wajah alami untuk menghilangkan jerawat Obat liver alami aman dan terbaik Obat herbal sinusitis kronis terbaik Obat bronkitis anak secara alami Obat Kanker Payudara terbaru 2018 Cara meningkatkan nafsu makan secara alami Obat herbal diabetes menurunkan gula darah Obat herbal kusta terbaik Obat benjolan di leher tanpa operasi Obat Herbal Kanker Otak tuntas hingga akar Obat TBC alami aman tanpa efek samping Obat radang amandel sembuh tanpa operasi Obat asam urat alami tanpa efek sampinfg Obat tetes Sariawan secara alami Cara mengobati mata bengkak dengan cepat Obat tradisional kanker lambung terbaik Obat kanker paru paru Obat usus buntu alami tanpa operasi Obat asam lambung naik cara alami

August 27, 2018 8:21 PM

yanmaneee said:">">

June 29, 2020 11:16 PM

Leave a Comment


About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS,

This Blog



Privacy Statement