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

Amazingly Useful SQL Server Articles on SQLPerformance.com

IMG_0247

Me and Aaron Bertrand, SQL Sentry flagbearers.

One of the things we've been working on at SQL Sentry is building up institutional knowledge for the SQL Server community. There are three main ways that we're doing that on-line:

  1. Hard-core tech articles on SQLPerformance.com, edited by long-time SQL Server MVP Aaron Bertrand ( b | t ).
  2. Helping tune tough SQL Server transactions on Answers.SQLPerformance.com for free.
  3. Streaming videos at SQLSentry.TV.

In addition, our monthly eNews newsletter keeps you up to date on all the latest happenings on all of these websites. Please subscribe! I'll personally hug you if you do.

If you've never looked at any of these resources, a great starting place is our top 12 most popular blog posts of 2013 from the SQLPerformance.com website:

  • I used to ask myself "Isn’t everyone bored with string splitting problems?". But this is such a perennial favorite, the answer is clearly "No. No, we’re not". Read more about splitting strings the right way – or the next best way here.
  • Paul White ( b | t ) presents a definitive article on one of the most common SQL coding problems, parameter sniffing.
  • CHECKDB is essential for good database maintenance, but it can also be a resource hog. Here are some ideas for lightening its load: Minimizing the impact of DBCC CHECKDB: DOs and DON'Ts.
  • Jonathan Kehayias ( b | t ) steps out into licensing, the region labelled "Here be dragons" on the maps of most IT professionals, in this great article on performance problems appearing on SQL Server 2012 servers with CAL licensing.
  • All processors are not equal in the eyes of SQL Server. Glenn Berry ( b | t ) tells you about the most important factors in choosing CPUs in these two articles.
    • For SQL Server 2012, read here
    • And for SQL Server 2014, read here
  • Now here’s a perenial T-SQL problem that I’m glad to see summarized in one concise article, Best approaches for running totals.
  • Erin Stellato ( b | t ) gives us a great review of the best practices around indexing foreign key constraints here.
  • Generating number sets is a really valuable technique in many coding scenarios. Read about the most common scenarios here.
  • Joe Sack ( b | t ) tells us all about troubleshooting CPU problems in this article.
  • Ever wonder which is better – NOT IN, LEFT OUTER JOIN, NOT EXISTS, or EXCEPT? Find out in this excellent article by Aaron Bertrand.
  • Paul Randal ( b | t ) helps dispel another commonly held myth about transaction log behavior here.

Have you learned anything new at SQLPerformance.com or gotten help at Answers.SQLPerformance.com? Please tell me if you have. It's always a big encouragement for me when I hear personal feedback that some of my hard work actually made a difference in your day.  

Many thanks,

-Kevin

-Follow me on Twitter!
-Google Author

Published Monday, March 3, 2014 11:50 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

 

Jimmy May @AspiringGeek said:

What a cunning array of brilliance, well done!

March 3, 2014 12:28 PM
 

fdeer said:

August 23, 2018 1:15 AM
 

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:25 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