SQL Server

Microsoft SQL Server powers your entire data estate by supporting structured and unstructured data sources. It builds on previous versions of SQL Server, which have been industry leading for four years in a row and a leader in TPC-E. It scales to petabytes of data and allows customers to process big data through PolyBase using T-SQL over any data. SQL Server has also been the least vulnerable database during the last seven years. SQL Server brings data insights with business intelligence capabilities that provide analytics at a fraction of the cost on any device along with advanced analytics with support for R and Python.

More details about SQL Server are available in the SQL Server documentation.
If you have a technical issue, please open a post on the developer forums through Stack Overflow or MSDN.


  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Make RS Log Files standardized and viewable in SSMS

    I like the way that SSMS makes log file available to the user, especailly where you can view multiple log files at once to see all events logged. However, missing is the RS log files. you have to search high and wide to find them. Once you do. they are very difficult to read in their native format.

    Why not make them comply with the format used by other log files and also make them avaiable in SSMS Log section

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Better "program name" for jobs in dm_exec_sessions

    When reviewing session activity using sys.dmexecsessions, I see items in the program name column like:

    SQLAgent - TSQL JobStep (Job 0x452FE49D5B63B84091F613691331151E : Step 6)

    Yuck. On a busy system, I am expected to either memorize all these job representations, or write my own query that joins and figures out what job that really is.

    If I capture session activity at a point in time, and then have to go re-query to figure out which job that is, I'm wasting potentially valuable time.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Jun 6 2007 12:40PM=-=>

    Aaron,

    Thanks for the report. We’ll investigate to see if a friendlier name makes sense….

    -Richard Waymire

    <=-=Oct 31 2008 10:21AM=-=>

    Hi,

    We are considering it for the next release,

    Thanks,

    Gil

    <=-=Jul 27 2009 9:54AM=-=>

    Aaron -

    Thank you for your feedback; but we won’t be fixing this for our next release.

    Thanks,

    Amy Lewis

  3. [Report Builder] Error Message during Regeneration

    During the regeneration of the model, if one table is missing, the whole regeneration process will cancel.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  4. SSRS/SSIS and content with HTML tags

    I would like to see SSRS/SSIS have the ability to convert strings that have html tags embeded in them to a readable format that can be displayed (in a report - SSRS) or exported (to excel - SSIS) without html tags.

    From what I can gather people have been asking for this since the 2000 beta.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  5. More SSMS keyboard shortcuts for execution

    OK, pie-in-the-sky here, but...

    When working in a query window in SSMS, primarily a "working development" window with several statements strewn about in various stages of testing/experimentation, it can be a pain (minor, but a pain nonetheless) to have to highlight the desired SQL before hitting F5.

    I propose (here we go) 2 SQL execution shortcuts:

    1) Execute from the cursor up and down all "connected" text. "Connected" meaning no all-white-space lines separating.
    2) Execute ONLY the entire line the cursor is on.

    For example, suppose the query window contained:

    SELECT TOP 1 * FROM MyTable

    SELECT <field list> FROM…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 37

    <=-=May 29 2007 9:08AM=-=>

    Hi Davidwv,

    Thank you suggesting the new shortcut. Currently we are revising all shortcut features and we will consider the selective execution with cursor location as a part of the feature for a future release of SQL Server.

    Regards,
    Eric

    <=-=Aug 5 2009 4:29AM=-=>

    This feature is in TOAD and a great feature it is too. Really hoping to see this arrive in SSMS.

    <=-=Nov 11 2010 1:04PM=-=>

    PL/SQL Developer has that feature too. I trust MS that we can welcome that feature in Denali!

    <=-=Jan 31 2013 5:37PM=-=>

    Hi!, thanks for writing in to Microsoft.

    We recently took a look at this feature request again and triaged it against several others and unfortunately, it did not meet the bar to be fixed. While we are closing this request as ’won’t fix’, we have taken note of this internally and we will…

  6. Changing the Green Animated Gif

    This is a rather simple, very low impact suggestion, but it would be nice to be able to replace the green animated gif that is shown when you generate a report, with your own gif of the same size.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Mark database objects as "global" across SQL Server instance

    We need means of marking database objects as "global" across the SQL Server instance. Similar to designating the "sp_" prefix, Best Buy would like to mark a UDF or stored procedure as globally executable and local to each user database - without making multiple copies of the same object.

    This was done (although not supported) in 2000 with undocumented system stored procedures and using sp_ prefix.

    Best Buy creates a number of maintenance stored procedures and functions, which are used by DBAs to manage user databases. Instead of duplicating code in each database we are creating them in master database…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Dec 10 2007 11:25AM=-=>

    Hi,
    Thanks for your feedback on this. We are looking into this feature request for enabling global procedures. We will investigate this further and if appropriate, take it up in a future release. Please feel free to contact us with any comments/suggestions.

    <=-=Dec 10 2007 11:25AM=-=>

    Hi,
    Thanks for your feedback on this. We are looking into this feature request for enabling global procedures. We will investigate this further and if appropriate, take it up in a future release. Please feel free to contact us with any comments/suggestions.

    <=-=Mar 23 2011 12:54PM=-=>

    Hello,
    I have resolved your request as duplicate of one below:

    http://connect.microsoft.com/SQLServer/feedback/details/310064


    Umachandar, SQL Programmability Team

  8. OBJECTPROPERTY property 'TableHasTextImage' does not support all LOB datatypes

    Return values for OBJECTPROPERTY(id,'TableHasTextImage') return 0 for tables containing XML, varchar(max) and varbinary(max), but it would be useful if there was a way of detecting these at table level.

    SET NOCOUNT ON
    CREATE TABLE mytext ( id int not null, textcol text )
    SELECT OBJECTPROPERTY(OBJECT_ID('dbo.mytext') ,'TableHasTextImage') AS TableHasTextImage
    /*

    TableHasTextImage

    1
    /
    CREATE TABLE myXml ( id int not null, xmldata xml )
    SELECT OBJECTPROPERTY(OBJECT_ID('dbo.myXml') ,'TableHasTextImage') AS TableHasTextImage
    /

    TableHasTextImage

    0
    /
    CREATE TABLE myvarbinmax ( id int not null, varbinmax varbinary(max) )
    SELECT OBJECTPROPERTY(OBJECT_ID('dbo.myvarbinmax') ,'TableHasTextImage') AS TableHasTextImage
    /

    TableHasTextImage

    0
    /
    CREATE TABLE myvarcharmax ( id int not null,

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Dec 10 2007 12:08PM=-=>

    Hi,
    Thanks for your feedback on this issue. We are deprecating the text/image datatypes from SQL Server. In a future release, we will investigate the possiblity of adding a substitute property to detect the presence of a LOB column in the table. Please feel free to contact us with any further suggestions/comments in this area.
    thanks
    Srini Acharya
    Relational Engine

  9. build dynamic MDX and stop requiring us to use StrToSet to parse params

    When you build an MDX report in Reporting Services and use parameters, you have to use StrToSet or StrToMember to parse the strings of MDX unique names.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Setting SQL Agent alerts

    Regarding creation of SQL Agent job alerts
    1) Allow use of the word filter to generate alerts without necessarily specifying a particular error number or a particular severity code.

    2) Allow for a &quot;Greater Than or Equal To&quot; value for severity.
    

    On the SQL Agent job Notifications:

    3) You need a better way to handle job failures for jobs that might get executed many, many times a day and might be failing for a while before someone notices.
    

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Jun 6 2007 10:38AM=-=>

    PDav,

    Thank you for your suggestion. We are considering these suggestions for a future release of SQL Server, but probably not SQL Server 2008. For future reference if you can put each suggestion in a separate filing it makes it easier for us to consider them individually.

    Thanks!

    -Richard Waymire

    <=-=Oct 29 2008 1:48PM=-=>

    We are considering it for SQL11.Thanks for the feedback!

    Gil

  11. Clearing dm_db_missing_index_*

    It would be great to be able to clear the index utilization exposed by the following DMVs/DMFs:
    sys.dmdbindexoperationalstats
    sys.dmdbindexphysicalstats
    sys.dmdbindexusagestats
    sys.dmdbmissingindexcolumns
    sys.dmdbmissingindexdetails
    sys.dmdbmissingindexgroupstats
    sys.dm
    dbmissingindex_groups

    This is the scenario:
    As a consultant you suggest some changes in the indexing strategies for a client.
    you want to "reset" the counters such us index usage, physical operations, missing indexes, etc.

    On the other hand, I don't know the cost of the implementation, but it would be nice to be able to reset the values at database level, or at instance level.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 34

    <=-=Feb 6 2008 10:15AM=-=>

    Eladio – Thank you for using Microsoft Connect.

    We agree the feature you requested should be useful, but we did not have the resources to do it in SQL Server 2008. We will keep your suggestion in mind going forward.

    As always, we appreciate your valuable input.

    <=-=May 9 2014 4:46PM=-=>

    Hello,
    After carefully evaluating all of the suggestion items in our pipeline, we are closing items that we will not implement in the near future due to current higher priority items. We will re-evaluate the closed suggestions again in the future based on the product roadmap.
    Thanks again for providing the product suggestion and continued support for our product.

    Jos de Bruijn – SQL Server PM

  12. Allow more control of Document Map display

    I would like to have control of how the document map is displayed in reports. In particular, I would like to be able to specify the text of the root node, and whether it should be expanded.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Enhance sys.dm_exec_query_plan to accept database_id

    This query is very expensive:

    SELECT *
    FROM sys.dmexecquerystats
    CROSS APPLY sys.dm
    execqueryplan(s.plan_handle);

    This is because sys.dmexecquery_plan() obtains server-wide information.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 3

    <=-=Feb 21 2008 2:14PM=-=>

    Dear Customer,

    Thank you for reporting the issue. We prioritized it and it could not fit on our SQL 2008 schedule. We are tracking it for the next release.

    Sincerely,
    Yavor Angelov
    Program Manager
    SQL Relational Engine

  14. identify unused aggregations

    SQL server has a dynamic management view called sys.dmdbindexusagestats which can tell you whether each index is being used.

    SSAS should have the same type management view for its aggs and indexes and attributes... if you've had a cube in production for a few months and a handful of aggs haven't ever been used, they should be removed... this would be an easy way to tell. This is sort of the flip side of Query Based Optimization.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Oct 15 2007 12:34PM=-=>

    There’s a feature in BIDS Helper that will help until something gets added to SSAS itself:

    http://www.codeplex.com/bidshelper/Wiki/View.aspx?title=Delete%20Unused%20Aggregations&referringTitle=Home

    <=-=Apr 28 2008 4:53PM=-=>

    Dear furmangg,

    Unfortunately, this feature will not be added for SQL Server 2008, but we are considering for the next major release.

    Thanks again for recommending this.

    The Analysis Services Team

  15. database ID hardcoded in XMLA

    The cube database the XMLA command will impact is hardcoded in the XMLA. There should be an option such that the database it is applied to is based upon the current database for the connection (which is roughly analogous to the Initial Catalog property of the connection string). That way, the same script can be run against one (or several) databases regardless of what it is named.

    With a MDX query, when you're running it in Management Studio, you have to make sure and check that you're connected to the right database or it won't work. But with XMLA commands,…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Report Builder Support of ValueSelection = FilteredList

    Currently, SSAS has a FilteredList option for the InstanceSelection property while the Report Builder ValueSelection doesn't.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add Analysis Services as an endpoint type

    I think if endpoint functionality was extended to Analysis Services, that would greatly extend its usability.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Online Partition Rebuilds

    You can rebuild an entire index online but you cannot rebuild just a partition online.

    This is related to feedback #242025.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 98

    <=-=Jan 18 2007 10:49AM=-=>

    Thank you for the feedback, we’ll look into this for future SQL Server releases.

    - Christian Kleinerman

    <=-=Sep 22 2011 7:47PM=-=>

    Almost five years and two releases later… This is a major pain point for big highly available databases. Come on, Microsoft, fix it.

    <=-=Apr 2 2015 7:59AM=-=>

    U can with SQL 2014

  19. Read-Only filegroups and Locking

    As Sunil Agarwal indicate on Storage Engine blog (http://blogs.msdn.com/sqlserverstorageengine/archive/2007/01/08/read-only-filegroups-and-locking.aspx#comments), locks are still managed on read-only filegroups. We are obliged to put the all databse in readonly to diable locks.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 3

    <=-=Jan 18 2007 11:36AM=-=>

    thanks for your feedback. Yes, we will consider this in future.

    <=-=Dec 8 2009 9:05PM=-=>

    I consider this a VERY IMPORTANT request. In the filed we are seeing more issues with the amount of memory being taken locking, and it’s assocaited CPU resources, etc.

    It would be FANTASTIC if I could place all my reference / read-only data into read-only filegroups and SQL Server would not bother with locking on those tables. Or perhaps always implement a table-level lock only, although is not ideal.

    - Victor

  20. Entity Filtering in Report Builder

    Based on end-user UI feedback, users are confused the Report Builder client re-filters the Entity pane to reflect the model relationships. This may make sense in the relational world, but if the report sources data from a dimensional model (star schema), it doesn't make much sense to show the measure group (fact table) when a dimension is dragged. As a result, the user must click on the measure group again to go back to the dimensions.

    In addition, the measure groups should'be placed at the end of the Entity list. Instead, they should be on the top (as in Excel)…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base