Connect Digest : 2010-02-16

Simon Sabin has asked for better usability in the SQL Server Agent log viewer: specifically, to allow you to get to job / step properties directly from the history viewer.

#531889 : Allow access to job details from the log file viewer to improve manageability

Guru Itzik Ben-Gan asks for a more powerful QUALIFY() option to allow filtering on the same kind of query elements that you can currently achieve with ROW_NUMBER().  This one already has over 80 votes!

#532474 : QUALIFY – Request for a New Filtering Clause

Chris Howarth points out even more problems with the custom connection coloring feature in SSMS (all the more reason to use Mladen's SSMSToolsPack).

#533667 : SSMS Connection Colouring Not Implemented Sensibly

 
MauriD asks for the ability to include a NOEXPAND hint for CTEs.

#533766 : Make NOEXPAND hint usable also with CTE

 
And last but not least, user "7gartner" asks for the ability to store tempdb on local storage in a cluster.

#532759 : Support local disk location for TempDB in failover cluster installation

When I read the title of this item, I thought, "oh, he must expect that someone with an active batch that is using a #temp table, might be able to continue working in the event of a failover."  Which doesn't make sense because their connection would be severed anyway.  But when I investigated the body, the want is much more simple than that: allow a system to avoid having to use shared storage for TempDB.  This means not using valuable SAN space and using local hard disks, possibly SSDs.  A light bulb went on when I saw that, because I know that outfitting SAN-based SSDs at reasonable capacity can get quite expensive, but an SSD dumped into a server – at a capacity to handle the typical sizing requirements of TempDB disks – would be a much more affordable option.  (Paul Nielsen just wrote about using tempdb in RAM, and the implication on using this in a cluster resonates again.)

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, speak frequently at conferences, and write at SQLPerformance and MSSQLTips. In real life I am a father of two, an architect at Wayfair, and my pronouns are he/him.

2 Responses

  1. AaronBertrand says:

    Hey Chris,
    Some days have been hectic (like today, I drove down to Seattle and am now back in Vancouver), but as I find time on quieter, non-event days, I will probably try to squeeze a bit of time on here…

  2. Chris Wood says:

    Aaron,
    Thought you were too busy at the Olympics to blog? Come on Canada
    Chris (in Edmonton, Alberta, Canada)