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-30 : please vote!

Here are some issues I came across recently; most involve SSMS in some way, though Erland's assertion suggestion is a great one. And just to be clear, since I am seeing some accusations of distorting the fairness of Connect by "asking for votes," I am not asking anyone to vote blindly on these items (and it's clear from last week's results that people are NOT doing that).  I'm asking you to take a look at these issues and -- if they affect you and you care enough to do so -- vote on them.

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

ASSERTIONS

Erland brought up a great suggestion to add true assertions to DML statements, which would have several benefits over triggers or rolling your own rollback mechanisms. 

#459383 : Add assertion clause to DML statements
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=459383
Current rating: 4.2 (6 votes)

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

Object Explorer problem during attach operation

Last week I was attaching a largish database (~300GB) using CREATE DATABASE ... FOR ATTACH.  Unlike when restoring a database, where you can see the "Restoring..." state next to the database name in Object Explorer (and can still access other online databases), during this time, I would receive an ugly error message if I tried to expand or refresh the database list.  I believe this is because the attach operation places an exclusive lock on the table(s) underlying the sys.databases catalog view, and the *ad hoc SQL* that SSMS issues to display the list does not use snapshot or lower isolation.  I'm not sure why it has to behave this way. 

#459208 : SSMS : Object Explorer fails to show database list during attach
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=459208
Current rating: N/A (1 vote)

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

Various Activity Monitor issues

Many people have complained about the way the new Activity Monitor replaced the previous version.  While there are many new and helpful ways in which the new feature works, a crowd has gathered complaining about some of the things that are still missing (or were taken away). 

#423019 : SQL Server 2008 Activity Monitor Enhancements
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=423019
Current rating: 4.7 (13 votes)

#352596 : SSMS: Activity Monitor is no longer in Treeview
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=352596
Current rating: 4.7 (6 votes)

#361102 : [SSMS 2008 RTM] Restore 2000 Activity Monitor
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=361102
Current rating: 3.8 (6 votes)

#350734 : SSMS : Activity Monitor column headers are too fragile
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=350734
Current rating: 4.3 (3 votes)

#350736 : SSMS : Activity Monitor queries replace white space with ugly boxes
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=350736
Current rating: 3.9 (2 votes)

#350726 : SSMS : Activity Monitor "Kill Process" more dangerous than it sounds
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=350726
Current rating: N/A (1 vote)

#350729 : SSMS : Activity Monitor process details dialog hard to use
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=350729
Current rating: N/A (1 vote)

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

And here are the changes I've observed over the past 7 days for the entries in my post from last week:

#127219 : CREATE OR REPLACE
Rating last week: 4.7 (84 votes)
Current rating: 4.7 (103 votes) +17

#273938 : sp_helptext : option for generating ALTER
Rating last week: N/A (1 vote) 
Current rating: 4.5 (3 votes) +2

#291300 : Option for sp_helptext to add 'GO'
Rating last week: N/A (1 vote)
Current rating: N/A (1 vote) no change

#362453 : SSMS RTM Table Limit
Rating last week: 4.7 (13 votes)
Current rating: 4.7 (17 votes) +4

#453982 : Bizarre XML Performance
Rating last week: 4.7 (3 votes)
Current rating: 4.7 (7 votes) +4

Published Saturday, May 30, 2009 1:47 PM by AaronBertrand

Comments

 

Alexander Kuznetsov said:

"distorting the fairness of Connect"? Connect is very inconvenient to navigate, so I really appreciate Aaron's effort. Thank you for the digest, Aaron, and please keep doing it!

May 31, 2009 2:29 PM
 

Brian Tkatch said:

Don't allow assertions. This can already be done in SQL with regular keywords.

June 1, 2009 11:00 AM
 

Aaron Bertrand said:

This week's digest for Connect items you should take a look at:

June 5, 2009 12:14 PM
 

Alejandro Mesa said:

Like Alexander, I also appreciate Aaaron's work to this regards. He is making our life easier and somehow educating us about the importance of connect to our community.

Thanks,

AMB

June 6, 2009 2:27 PM
 

sulumits retsambew said:

your article is very good nice post thank you, keep posting

July 2, 2009 4:32 AM
New Comments to this post are disabled

About AaronBertrand

...about me...

This Blog

Syndication

Archives

Privacy Statement