SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Under Appreciated Features


Under Appreciated Features

Author
Message
tony.hayes
tony.hayes
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 190
Sometimes the simplest things are the most useful - my favorite feature of SQL 2005 : the ability to filter in the object explorer. We have several databases with thousands of Queries and being able to jump to (or close to depending on how specific the filter) the right query without scrolling through an endless list saved me loads of time.
SQLNightOwl
SQLNightOwl
Old Hand
Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)

Group: General Forum Members
Points: 372 Visits: 511
I don't think you can overlook the usefulness of bcp and/or bulk insert. They're frequently overlooked in favor of SSIS. Many times SSIS is overkill for loading/producing simple files.

I have a love/hate thing going with intellisence.

On the wish list is the ability to bundle procedures and functions into a class (similar to oracle packages).

--Paul Hunter
shaycullen
shaycullen
SSC-Enthusiastic
SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)

Group: General Forum Members
Points: 143 Visits: 222
I have to say I am a big fan of Tuning Advisor. Some of the databases I work with are an absolute nightmare for performance and the nature of the company means we always need our data fast, (it's disheartening for users and reflects bad on me when things are slow). This is where I find Tuning advisor to come up trumps! :-)
mister.magoo
mister.magoo
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4152 Visits: 7865
+1 for filtering in the Object Explorer of SSMS

+1 for partition functions

+1 for execution plans (both graphical and xml)

New ones - not mentioned so far.

XQUERY - Processing xml has improved a lot, it still has some way to go, but is much better.

FOR XML PATH - just for the ability to concatenate strings

Query Optimiser - That is one major bit of kit - without it we would all be wallowing in SQL 7 hell.

SSC - not strictly a part of SQL server - but certainly integral to my use of SS.

MM


select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);




  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Steph Locke
    Steph Locke
    Old Hand
    Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)

    Group: General Forum Members
    Points: 303 Visits: 870
    It might not sound like much but being able to highlight a string and press F1 to get help on the selected text is absolutely awesome in SSMS- it's not something you notice until you have to use MySQLs workbench or query browser and this functionality doesn't exist.

    All those times when the order of the arguments in an arcane function are a bit hazy, or when you need to know how it handles nulls and other little bits of trivia and you get it at the press of a button! An instantaneous answer on it is truly invaluable. On MySQL, it's open up the net, navigate to their webpage, navigate to the right section or use their hideously slow search engine and keep scrolling down until you find what you're looking for, 5 minutes later and you only just remember what you were looking for in the first place.
    TravisDBA
    TravisDBA
    SSCrazy
    SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

    Group: General Forum Members
    Points: 2010 Visits: 3069
    The Data Collector and CMS (Central Management Servers) both make a DBA's daily life much easier but I am very surprised how many people are not taking advantage of them.:-D

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"
    David Benoit
    David Benoit
    Hall of Fame
    Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

    Group: General Forum Members
    Points: 3410 Visits: 3650
    As Andy already mentioned, missing indexes in the graphical plan is a huge plus. They are usually pretty accurate or pretty close making it pretty helpful.

    I will have to say that sparse columns, for those that have a lot of data, can be a pretty well overlooked feature. There can be some great savings there if the situation is right.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
    GSquared
    GSquared
    SSC-Insane
    SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

    Group: General Forum Members
    Points: 23757 Visits: 9730
    The XML tools are what I see used the least where they could be used more. Both XQuery and For XML have a myriad of uses and improvements over prior tools. But I still see posts in the SQL 2008 forums here where people are instatiating XML objects using the SQL 2000 system procs.

    Filtered indexes are definitely a good feature. Work beautifully on large tables with bit fields that need to be filtered by routinely.

    There are plenty of others, I'm sure.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
    rclark-1124819
    rclark-1124819
    SSC Rookie
    SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

    Group: General Forum Members
    Points: 26 Visits: 136
    The absolute best, Pivots and for XML path to concat strings.

    Oh, and replace...etc.....
    fthiemonge
    fthiemonge
    Forum Newbie
    Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

    Group: General Forum Members
    Points: 7 Visits: 51
    I'm a big fan of making my own templates in the template explorer. Not many people in my office use them but they are a huge help getting you jump started when writing new code. Being a developer I only have templates for sprocs, tables, and functions, but I can see them being just as useful for other objects. One thing I wish they would contain is some sort of looping interface where for example I could have it prompt me for details regarding all of a new sproc's parameters. When writing the template I don't know how many params a given sproc may have but I know for each I'll need a name, data type, default (optional), input/output type (optional), and description for my header comment. It would be nice to say for a given sproc I have 10 parameters (or 10 grant statements, or whatever, just X number of something that fits a pattern), then have it automatically prompt me for this detail about each member. Maybe they'll provide such functionality in a later version.
    Go


    Permissions

    You can't post new topics.
    You can't post topic replies.
    You can't post new polls.
    You can't post replies to polls.
    You can't edit your own topics.
    You can't delete your own topics.
    You can't edit other topics.
    You can't delete other topics.
    You can't edit your own posts.
    You can't edit other posts.
    You can't delete your own posts.
    You can't delete other posts.
    You can't post events.
    You can't edit your own events.
    You can't edit other events.
    You can't delete your own events.
    You can't delete other events.
    You can't send private messages.
    You can't send emails.
    You can read topics.
    You can't vote in polls.
    You can't upload attachments.
    You can download attachments.
    You can't post HTML code.
    You can't edit HTML code.
    You can't post IFCode.
    You can't post JavaScript.
    You can post emoticons.
    You can't post or upload images.

    Select a forum

































































































































































    SQLServerCentral


    Search