Browse by Tags

• Administration
• Automation
• Best Practices
• Developer
• Humor
• Internals
• Opinion
• People
• Performance
• SQLIOSIM
• SQLMag
• Tools
• Transact-SQL Programming
• Trends
• Troubleshooting

• Dev Advice: Make a Tiny Dev Database Act Like a HUGE Prod Database

  If you're struggling with doing development on a big SQL Server database, learn the ropes on cloned databases asap! Read More... Posted Friday, March 16, 2012 10:30 AM by KKline | 3 Comments Filed under: SQL Programming, Best Practices, Tips, Tools, Developer, SQLMag, Transact-SQL Programming

• Database Maintenance Scripting Done Right

  I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's Read More... Posted Friday, February 18, 2011 8:16 AM by KKline | 0 Comments Filed under: Performance, SQL Programming, Best Practices, Administration, People, Tips, Tools, Automation

• 2009: The Year in List Form

  Before I jump onto the Goals and Themeword meme started by my buddy, Thomas LaRock ( blog | twitter ), I decided I'd spend a few minutes looking back on both the year 2009. (From a personal standpoint, the 00's were my most difficult decade yet. Major Read More... Posted Tuesday, January 05, 2010 2:53 PM by KKline | 0 Comments Filed under: Performance, SQL Programming, Humor, Trends, Administration, People, Tips, Opinion, SQLIOSIM, Tools

• 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 Read More... Posted Wednesday, November 05, 2008 2:12 PM by KKline | 4 Comments Filed under: SQL Programming, Tips, Troubleshooting

• 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 Read More... Posted Monday, April 21, 2008 4:45 PM by KKline | 3 Comments Filed under: SQL Programming, Tips

• NASTY RUMORS ABOUT MAXDOP

  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 Read More... Posted Tuesday, April 15, 2008 1:48 PM by KKline | 12 Comments Filed under: SQL Programming, Internals, Tips

• Beware of computed columns

  If you use computed columns a lot, you might want to know about some new behavior in SQL Server 2005. Read More... Posted Thursday, October 11, 2007 12:20 AM by KKline | 0 Comments Filed under: SQL Programming, Internals, Tips

• 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 Read More... Posted Friday, August 31, 2007 6:31 PM by KKline | 3 Comments Filed under: SQL Programming, Internals, Tips