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 » SQL Programming   (RSS)
Showing page 1 of 4 (31 total posts)
  • ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior - SQL Server Performance

    Here are some oldies, but goodies that I recommend you read:Two Partitioning Peculiarities and Aggregates and PartitioningMost of us know that partitions are one of the best ways to scale very large databases or very large IO workloads.  However, there are risks, two of which are explored in detail by internals master Paul White ...
    Posted to Kevin Kline (Weblog) by KKline on March 30, 2015
  • 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
  • Four New Slide Decks for SQL Server and IT Pros from the DevLink 2014 Conference

    I always enjoy presenting at the DevLink conference, presented each summer in middle Tennessee.  This year, I'm trying to be a better social media person and actually post my slides (in their most recent forms) on my SlideShare account for everyone to see and share. If you attended my session(s) and enjoyed them, feel free to ...
    Posted to Kevin Kline (Weblog) by KKline on August 29, 2014
  • MySQL, NoSQL, and NuoDB

    I've been keen on MySQL ever since I first started using it heavily more than a decade ago.  In fact, I liked it well enough to include it as one of the four main database platforms, over and above the ANSI-ISO SQL standard, in my popular book SQL in a Nutshell. However, with the advent of NoSQL data platforms in the last few years, ...
    Posted to Kevin Kline (Weblog) by KKline on July 8, 2013
  • 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
  • Help Me Update the History of SQL Server

    I was chatting with my buddy, Buck Woody (Twitter | Blog), about a week ago and we were discussing that it's pretty hard to put together the entire history of SQL Server.  Then the thought hit me that I'd already done this, to a degree, in my book Transact-SQL Programming.  This was the first Transact-SQL programming ...
    Posted to Kevin Kline (Weblog) by KKline on September 12, 2012
  • Dev Advice: Make a Tiny Dev Database Act Like a HUGE Prod Database

    Here's an evergreen question. It's a question that never completely goes away. But lately, I've been getting it a few times per week. So I thought it's time to readdress the question, which usually takes some form of the following:I can't really do effective development on my little dev laptop because our production SQL Server database is 15 ...
    Posted to Kevin Kline (Weblog) by KKline on March 16, 2012
  • How Do You SKU?

    I’d like your opinion here. Follow my logic here for a moment as I walk through a couple rhetorical questions.  Have you ever had a friend developed an application entirely on SQL Server Developer Edition?  (Not that YOU would ever do such a thing, but maybe you know someone who has. Right?) And has your friend’s IT department ...
    Posted to Kevin Kline (Weblog) by KKline on March 30, 2011
1 2 3 4 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement