THE SQL Server Blog Spot on the Web

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

Kevin Kline

ICYMI - Predicate Logic, Four Things I Wish I'd Known Sooner, Transact-SQL Bad Habits, Rewriting Queries to Improve Performance

 Some of my favorite articles originally appearing at SQLPerformance.com.


Why Not Seek Predicate
Paul White ( b | t ) proves, once again, why he is the best in the business when it comes to debugging a SQL Server query. In this post, Paul gives you a step-by-step breakdown of a query that goes astray due to implied predicate logic. Got a tough query of your own? Post it atanswers.sqlperformance.com!

Four Things I Wish I Knew Sooner as a SQL Server DBA
Lori Edwards ( b | t ) tells four things she wished she knew before she started her many year career as a SQL Server database administrator. Hint – the best DBAs don’t excel based solely on technical prowess.

Transact-SQL Bad Habits Revival
Our own Aaron Bertrand ( b | t ) has been blogging and speaking about T-SQL Bad Habits for years. This outstanding blog post recaps his many entries and examples on the topic and points out all of the places where you can read more.

Rewriting Queries to Improve Performance
Another article from Paul White, looking at several situations where alternative T-SQL examples should produce comparable execution plans, but do not. In fact, these queries actually benefit most from a full rewrite.

Read more SQL Sentry happenings in our monthly eNews.

-Kevin

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

Published Tuesday, August 4, 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

Comments

 

obat batuk kronis said:

https://goo.gl/KTrjVR Obat herbal kolesterol terbaik

https://goo.gl/9qCgf9 Obat Batuk Kronis Alami Terbaik

https://goo.gl/HQh67p Masker wajah alami untuk menghilangkan jerawat

https://goo.gl/4UJxUL Obat liver alami aman dan terbaik

https://goo.gl/j3PFHJ Obat herbal sinusitis kronis terbaik

https://goo.gl/W5W8F9 Obat bronkitis anak secara alami

https://goo.gl/2AsGLu Obat Kanker Payudara terbaru 2018

https://goo.gl/ssFQGs Cara meningkatkan nafsu makan secara alami

https://goo.gl/KSnnFb Obat herbal diabetes menurunkan gula darah

https://goo.gl/ngiymL Obat herbal kusta terbaik

https://goo.gl/ZsjaLf Obat benjolan di leher tanpa operasi

https://goo.gl/arrkfe Obat Herbal Kanker Otak tuntas hingga akar

https://goo.gl/VBFyi2 Obat TBC alami aman tanpa efek samping

https://goo.gl/ooXyhS Obat radang amandel sembuh tanpa operasi

https://goo.gl/94gZFX Obat asam urat alami tanpa efek sampinfg

https://goo.gl/Ld4VKF Obat tetes Sariawan secara alami

https://goo.gl/8v2oKL Cara mengobati mata bengkak dengan cepat

https://goo.gl/pnP3nA Obat tradisional kanker lambung terbaik

https://goo.gl/96UaW3 Obat kanker paru paru

https://goo.gl/bjzQzS Obat usus buntu alami tanpa operasi

https://goo.gl/PUDELN Obat asam lambung naik cara alami

August 27, 2018 8:21 PM

Leave a Comment

(required) 
(required) 
Submit

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, www.sqlpass.org.

This Blog

Syndication

Archives

Privacy Statement