THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » developer » Performance   (RSS)
Showing page 1 of 2 (13 total posts)
  • ICYMI: Query Optimization Phases, Observer Overhead, and Secrets of SP_Updatestats - SQL Server Performance

    Do you do a bit of query tuning? Then check out this treasure trove of performance tuning advice!Optimization Phases and Missed Opportunities andWorking Around Missed OptimizationsPaul White (b | t) writes two fascinating blog posts that go hand-in-hand concerning query optimization.  He goes into some deep details about ...
    Posted to Kevin Kline (Weblog) by KKline on March 23, 2015
  • ICYMI: Troubleshooting CPU, Logging Myths, Missing Indexes, and Query Tuning Examples

    Great Articles at SQLPerformance.comThere are so many good articles from this ICYMI article that it’s hard to know which are best to highlight in the limited space. So, I’ll be arbitrary and simply choose a few of my favorite entries as we look back:Troubleshooting SQL Server CPU Performance IssuesThis outstanding ...
    Posted to Kevin Kline (Weblog) by KKline on March 16, 2015
  • The SQL Sentry forum for SQL Statement Tuning

    The SQL Sentry forum for SQL Statement TuningHave you ever looked at our community site specifically dedicated to helping users tune their SQL queries, can easily upload an execution plan directly from our free Plan Explorer tool or from good ol' SQL Server Management Studio.  Once ...
    Posted to Kevin Kline (Weblog) by KKline on February 25, 2015
  • Top 10 DBA Mistakes on SQL Server. (Now with Prizes for Participation!)

    The first big mistake I made as a DBA was coming to work with my zipper wide open. But I digress.Hear one of my most popular session via streaming media at SQLSentry.TV!Microsoft SQL Server is easier to administrate than any other relational database on the market.  But “easier than everyone else” doesn’t mean it’s easy.  And it doesn’t ...
    Posted to Kevin Kline (Weblog) by KKline on April 9, 2014
  • Hear the SQL Server 2012 story on DotNetRocks

    I was privileged to have a chat with my buddies over at, Carl Franklin and Richard Campbell, episode number 876 (876!). Listen to the most popular internet audio talk show for .NET developers!  Here's the abstract:Carl and Richard talk to Kevin Kline about the latest features in SQL Server 2012. The conversation ...
    Posted to Kevin Kline (Weblog) by KKline on May 31, 2013
  • Learn More About SQL Server IO and Query Tuning in These Webcasts

    I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch.   SSDs are a Game Changer for SQL Server Storage No, session is not exclusively about SSDs.  But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks.  As Bob Dylan said ''Times, they ...
    Posted to Kevin Kline (Weblog) by KKline on December 14, 2012
  • Everybody Needs a Test Harness

    When you're developing new Transact-SQL code or modifying some existing code, do you just launch directly into programming? I know that I did just that, for years. It wasn't until I was trying to performance tune some existing code that I realized I hadn't actually taken caching of data and execution plans into account. So all those modified ...
    Posted to Kevin Kline (Weblog) by KKline on October 31, 2011
  • From SQLMag Tool Time Column: SSMS Plug-in News

    I first wrote about Mladen Prajdic's excellent tool in my Tool Time column at SQL Server Magazine HERE. The tool is a nice plug-in to SSMS and definitely worth having. If you’ve never installed it or have only installed an older version, but sure to pick up the newest release. Here’s Mladen’s press release complete with hyperlink for the ...
    Posted to Kevin Kline (Weblog) by KKline on May 12, 2011
  • Have You Heard About Project Lucy?

    Lucy, You Got Some 'Splainin to Do!' Quest Software's latest community initiative, Windows Azure-based Project Lucy, has debuted! Project Lucy is part infrastructure analytics, part social media experiment, and part performance data warehouse. The best things about Project Lucy include: It’s Free - just like our SQLServerPedia ...
    Posted to Kevin Kline (Weblog) by KKline on February 16, 2011
  • Join Me May 19th for 24 Hours of PASS

    Join Us for 24 Hours of SQL Server Training (with a special focus on SQL Server 2008 R2)Did I mention that your Cohorts in Crime (that be me and Brent Ozar) are presenting?!? The FREE 24 Hours of PASS event is bringing an exceptional lineup of SQL Server and BI experts to your computer starting at 12:00 GMT (UTC) on May ...
    Posted to Kevin Kline (Weblog) by KKline on April 26, 2010
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement