THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Aaron Bertrand

Aaron is a Product Evangelist for SentryOne, makers of Plan Explorer and a performance monitoring and event management platform for the Microsoft Data Platform and VMware. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features, and also blogs at blogs.sentryone.com and SQLPerformance.com; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at major conferences, user group meetings, and SQL Saturday events worldwide.

Connect Digest : 2009-05-23 : please vote!

Here are the items from this week that I feel deserve some attention.  I'm also adding a little bit of analysis to this.  I am always curious if my vote-pimping has any effect, so I am going to start taking a note of the ratings at the time I publish the post, and then compare them when I publish the next post.  This will give me some idea about whether my efforts here are worth it.

====================

CREATE OR REPLACE syntax

We've been asking for this syntax for several versions now, and it finally looks like they're seriously considering it.  To the point that they are narrowing down which DDL commands to support in the first round (since they don't pretend to be able to support all of them in one go).  This item already has a lot of votes, so if you have already voted, you could add comments indicating which items you would prefer be supported initially. 

#127219 : CREATE OR REPLACE
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=127219
Current rating: 4.7 (84 votes)

====================

sp_helptext improvements

Because of the missing syntax for create or replace, I filed two items in 2007 that would allow for improved usability with the system procedure sp_helptext.  One is to allow an option that would append 'GO' to the end of the script, and the other is to allow an option to script ALTER instead of CREATE.  While arguably these options are much less useful if they implement CREATE OR REPLACE functionality, that is still not guaranteed, so some other extensions might be helpful.  So far, I am the only person who has voted for either of these items.

#273938 : sp_helptext : option for generating ALTER
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=273938
Current rating: N/A (1 vote) 

#291300 : Option for sp_helptext to add 'GO'
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=291300
Current rating: N/A (1 vote) 

====================

Object Explorer tree limits

Object Explorer has a known limitation where, if you have too many objects in a single database, expanding a relevant node will yield the error message: "See Object Explorer Details for objects in this folder."  Using Object Explorer Details instead of the Object Explorer tree adds some functionality (like sorting and viewing additional properties); however, at the same time, it takes some important functionality away (like expanding multiple items at the same level and dragging column name lists onto query windows).  Now it seems that fixing this issue means they will also have to fix the underlying OS, but I say by all means do it.  If I want to wait 15 minutes for my crappy desktop PC to display a tree, I should be able to make that choice myself.

#362453 : SSMS RTM Table Limit
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=362453
Current rating: 4.7 (13 votes)

====================

Bizarre XML Performance

Fellow MVP and sqlblog.com blogger Adam Machanic discovered some illogical performance when constructing and slightly changing queries involving XML and TVFs.

#453982 : Bizarre XML Performance
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=453982
Current rating: 4.7 (3 votes) 

====================


Published Saturday, May 23, 2009 1:02 PM by AaronBertrand

Comments

 

Aaron Bertrand said:

Here are some issues I came across recently. Most involve SSMS in some way, At the bottom I also compare

May 30, 2009 1:32 PM
New Comments to this post are disabled

About AaronBertrand

...about me...

This Blog

Syndication

Archives

Privacy Statement