Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

Under Appreciated Features Expand / Collapse
Author
Message
Posted Friday, December 17, 2010 6:43 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 14, 2011 12:52 PM
Points: 14, 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.
Post #1036493
Posted Friday, December 17, 2010 6:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 9:55 AM
Points: 201, Visits: 404
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
Post #1036500
Posted Friday, December 17, 2010 6:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 23, 2014 7:52 AM
Points: 118, Visits: 173
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!
Post #1036507
Posted Friday, December 17, 2010 7:05 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 12:00 AM
Points: 1,787, Visits: 5,725
+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


  • MMGrid Addin
  • MMNose Addin


  • 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

  • Post #1036509
    Posted Friday, December 17, 2010 7:09 AM


    SSC-Enthusiastic

    SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

    Group: General Forum Members
    Last Login: Monday, August 11, 2014 1:55 AM
    Points: 162, Visits: 835
    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.
    Post #1036511
    Posted Friday, December 17, 2010 7:14 AM


    Ten Centuries

    Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

    Group: General Forum Members
    Last Login: Tuesday, September 16, 2014 2:03 PM
    Points: 1,335, Visits: 3,069
    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.

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
    Post #1036513
    Posted Friday, December 17, 2010 7:16 AM


    SSCrazy

    SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

    Group: General Forum Members
    Last Login: Yesterday @ 7:07 AM
    Points: 2,107, Visits: 3,583
    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
    SQL Tentmaker
    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
    Post #1036517
    Posted Friday, December 17, 2010 7:20 AM


    SSCoach

    SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

    Group: General Forum Members
    Last Login: Friday, June 27, 2014 12:43 PM
    Points: 15,444, Visits: 9,596
    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
    Post #1036518
    Posted Friday, December 17, 2010 7:23 AM
    Grasshopper

    GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

    Group: General Forum Members
    Last Login: Thursday, September 4, 2014 3:37 PM
    Points: 23, Visits: 84
    The absolute best, Pivots and for XML path to concat strings.

    Oh, and replace...etc.....
    Post #1036522
    Posted Friday, December 17, 2010 7:33 AM
    Forum Newbie

    Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

    Group: General Forum Members
    Last Login: Tuesday, March 22, 2011 7:50 AM
    Points: 5, 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.
    Post #1036530
    « Prev Topic | Next Topic »

    Add to briefcase ««12345»»»

    Permissions Expand / Collapse