Browse by Tags

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

• 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

• 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 5, 2010 2:53 PM by KKline | 0 Comments Filed under: Performance, SQL Programming, Humor, Trends, Administration, People, Tips, Opinion, SQLIOSIM, Tools

• 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