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 (23 total posts)
  • Upcoming Seminar and SQL Saturday in Florida, Oct 13-17

    Please join me for SQL Saturday #21 coming up on Saturday, October 17th.  There are over 50 sessions on tap with great speakers from the area and across the nation.  Some of the notable speakers include: Andy Leonard (blog here)Andy Warren (blog here)Brian Knight (blog here)Buck Woody (blog here)Chad Miller (blog here)Joe Celco (blog ...
    Posted to Kevin Kline (Weblog) by KKline on October 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
  • 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
  • Beware of computed columns

    If you use computed columns a lot, you might want to know about some new behavior in SQL Server 2005. One of the changes in SQL Server 2005 was to evaluate expressions in queries to match computed column expressions and identify redundant expressions, in order to prevent run-time errors in queries that have unsafe expressions. This is documented ...
    Posted to Kevin Kline (Weblog) by KKline on October 11, 2007
  • Useful Index Information Scripts for SQL Server 2005

    Italian SQL Server MVP Davide Mauri has released four very useful scripts that simplify the usage of SQL Server 2005 DMVs to discover, analyze, and understand index usage and health.  The queries are not rocket science, but they are long and rely on DMVs that you may not have learned about yet.  They also provide useful and ...
    Posted to Kevin Kline (Weblog) by KKline on August 31, 2007
  • Which DMV Shows Plan Handles?

    Sometimes, knowing which Dynamic Management View (DMV) to use is your biggest challenge when attempting to figure out SQL Server 2005 behavior.  For example, what if you want the cached execution plans in XML format, similar to the output of SET SHOWPLAN_XML?  As it turns out, Gert Draper pointed out that there are a couple of DMVs ...
    Posted to Kevin Kline (Weblog) by KKline on July 25, 2007
  • Tracking Log File Growth on SQL Server 2000

    Gert Drapers, whom I consider to be a super-genius of the SQL Server world and owner of the very useful website, wrote a useful little script a few years ago that I thought I'd share.  This is a SQL query that will show who and what is causing the log of a database, in this case tempdb, to grow: USE tempdbGO SELECT ...
    Posted to Kevin Kline (Weblog) by KKline on July 11, 2007
Privacy Statement