Connect Digest : 2009-05-30 : please vote!
May 30th, 20094
Connect Digest : 2009-05-30 : please vote!
May 30th, 20094

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.



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*/
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*/
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*/
Current rating: 4.7 (13 votes)

#352596 : SSMS: Activity Monitor is no longer in Treeview*/
Current rating: 4.7 (6 votes)

#361102 : [SSMS 2008 RTM] Restore 2000 Activity Monitor*/
Current rating: 3.8 (6 votes)

#350734 : SSMS : Activity Monitor column headers are too fragile*/
Current rating: 4.3 (3 votes)

#350736 : SSMS : Activity Monitor queries replace white space with ugly boxes*/
Current rating: 3.9 (2 votes)

#350726 : SSMS : Activity Monitor "Kill Process" more dangerous than it sounds*/
Current rating: N/A (1 vote)

#350729 : SSMS : Activity Monitor process details dialog hard to use*/
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:

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

By: 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, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a husband, a father of two, a huge hockey and football fan, and my pronouns are he/him.

4 Responses

  1. sulumits retsambew says:

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

  2. Alejandro Mesa says:

    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.

  3. Brian Tkatch says:

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

  4. Alexander Kuznetsov says:

    "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!