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 2 of 3 (27 total posts)
  • Bitemporal Data

    Any IT pro with more than a year or two of experience will have faced the challenges of version control for an application, but what if you have to implement version control for data? The most common way to tackle this problem is implementing something called ''bitemporal data''. Under this method, each row in a table includes the current ...
    Posted to Kevin Kline (Weblog) by KKline on August 4, 2009
  • Why Do I Keep Seeing This Mistake?

    One of the fundamentals of loop optimization is that you should move stable operations outside of the loop.  What I want to know is - if this is such a fundamental rule, why do so many people break it?!?If you are familiar with other programming languages, then you are probably aware of loop optimization techniques. You should try to put all ...
    Posted to Kevin Kline (Weblog) by KKline on July 10, 2009
  • Looking for Good DMV/Database Admin Queries!

    I like to collect useful database administration queries that leverage the SQL Server 2005 and 2008 DMVs.  Heck, I'm still interested in SQL Server 2000 queries too.  I thought I'd make my search public so that a) you can share your favorite queries here or great reference queries written by others and publicly posted on the ...
    Posted to Kevin Kline (Weblog) by KKline on April 7, 2009
  • An Interview with Denis Gobo

    I had the pleasure of speaking with SQL Server MVP, Denis Gobo, about my newest book, SQL in a Nutshell 3rd Edition.  In the interview, we discuss the state of database industry, ANSI SQL, and other related questions. Check out Denis' interview (and his fine blog) at Thanks, -Kevin
    Posted to Kevin Kline (Weblog) by KKline on February 24, 2009
  • LINQ: Enabling or Entangling?

    There’s been a lot of positive press for LINQ, such as the article about LINQ by Mike Otey at  You can also find lots of glowing reviews and info about LINQ by Troy Magennis at   I've been trying to figure out exactly how I feel ...
    Posted to Kevin Kline (Weblog) by KKline on December 23, 2008
  • Better Ways to Get Transaction Log Information

    If you've been around a while, you tend to do things the way you first learned how to do them.  This can turn you into an ''old timer'' whose oblivious to new and better ways to do things that have appeared in the newer releases of the technology.   Take measuring log space, for example.  If I wanted to find out how much log space ...
    Posted to Kevin Kline (Weblog) by KKline on November 5, 2008
  • Implementing A Hash Partition In SQL Server 2005

    One of the best things about becoming a Microsoft MVP is meeting other MVPs.  I bring this up because last week was the annual MVP Summit in Seattle, WA.  I was really looking forward to meeting Steve Kass.  Steve Kass is one of the smartest SQL Server MVPs I’ve encountered, especially when it comes to SQL questions.  A ...
    Posted to Kevin Kline (Weblog) by KKline on April 21, 2008

    You'd think an article called ''NASTY RUMORS ABOUT MAXDOP'' would have something to do with Britney Spears or maybe Robert Downy Jr, but in that case it'd be total fiction (at least, it would be coming from my pen).   So, I was en route to the 2008 Microsoft MVP Summit yesterday and I had a chance to catch up on my reading.  You ...
    Posted to Kevin Kline (Weblog) by KKline on April 15, 2008
  • Pain of the Week: Code Faster for Faster Code

    A while back, Quest Software started a series of webcasts called ''The Pain of the Week''.  These webcasts are about a specific area of difficulty for SQL Server DBAs and developers, and how specific Quest tools can help. In the next webcast, I and my colleague from Quest, Bryan Oliver, will present a methodology and show you how to ...
    Posted to Kevin Kline (Weblog) by KKline on March 27, 2008
  • Soliciting Feedback for the 3rd Edition of "SQL in a Nutshell"

    Kevin here.  In the 2nd edition of my book ''SQL in a Nutshell'', I covered the latest ANSI SQL implementation, plus the full syntax and usage of the SQL commands for IBM's DB2 UDB, Oracle, Microsoft SQL Server, MySQL, and PostgreSQL.  You can imagine how much work that was.  I'm now starting to plan for the 3rd edition of the ...
    Posted to Kevin Kline (Weblog) by KKline on November 26, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement