October 2007 - Posts

• Available Ports On A SQL Server

  Ever have a situation where you’d like to know what TCP/IP ports are open on your server? Read More... Posted Wednesday, October 31, 2007 1:42 PM by KKline | 0 Comments Filed under: Tips

• More Pages Reported Than Actually Exist in the Table

  MVP Hugo Kornelius once reported that he encountered a situation in which it was possible to perform a table scan on more pages than actually existed in the heap table. Hugo deduced that this was due to a phenomenon called “forwarding pointers”. Why in Read More... Posted Friday, October 26, 2007 9:38 AM by KKline | 3 Comments Filed under: Internals, Tips

• TempDB Space Usage

  Aaron Bertrand, a blogger on SQLBlog.com and keeper of www.aspfaq.com is one of those SQL Server MVPs whose material is always on my must-read list. Here's a really useful query he developed to determine the space used by objects in TempDB: SELECT SPID Read More... Posted Tuesday, October 23, 2007 7:59 AM by KKline | 9 Comments Filed under: Tips

• Changing PerfMon Counters on SQL2000 vs SQL2005

  You might have noticed, if you’re a heavy user of PerfMon, that some counters are exhibiting alterations in behavior between SQL Server 2000 and SQL Server 2005. For example, I’ve long used the “Transactions/sec” counter to get an idea of how much work Read More... Posted Monday, October 15, 2007 5:40 AM by KKline | 2 Comments Filed under: Internals, Tips

• RAID6 on SQL Server?!?

  Kevin talks about why RAID6 is a bad idea for SQL Server. Read More... Posted Saturday, October 13, 2007 10:35 PM by KKline | 4 Comments

• 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

• Acquiring a good habit and breaking a bad habit

  Have you ever made a New Year's Resolution to drop a bad habit, maybe to stop snacking on junk food or to stop biting your nails? Have you every made a similar resolution to pick up a good habit - flossing anyone? They're both hard to make stick. For Read More... Posted Wednesday, October 03, 2007 2:07 PM by KKline | 4 Comments Filed under: Tips