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. 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 "Greater Than or Equal To" 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

  2. 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

  3. 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 →
  4. 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

  5. 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

  6. 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 →
  7. 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 →
  8. 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 →
  9. 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

  10. 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

  11. 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 →
  12. Jobs created by Reporting services - For cache specific expiry

    The SQL Server jobs, that are created to expire the report from the cache, contains GUIDs as their name and this becomes very hard for the end users and DBA to manage the jobs.
    It would be great if there is a way end users can define the names for these jobs without affecting the functionality of the reporting services.

    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. SSRS: Add support for target when using actions

    When using actions in SSRS I miss the option of targeting the action to a new window, parent windows (that is report) and so on.

    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 →
  14. expose way to enumerate parameters from within a report

    I would expect that there would be an easy way to loop through all the parameters in a report from within that report.

    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 →
  15. sqlFunction should have a schema parameter

    The sqlFunction statement does not accept a schema name so all sqlFunctions created this way default to dbo.

    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: 26

    <=-=Dec 13 2007 1:21AM=-=>

    Thanks for the great feedback.

    We’re currently seriously looking at it to see if it can fit our new release schedule.

    -michael

    <=-=Dec 8 2013 3:46PM=-=>

    There’s a workaround for the postdeployment script:

    if object_id(‘dbo.myCLRFunction’) is not NULL begin
    alter schema myschema transfer dbo.myCLRFunction
    end

    I’d love to see this implemented as something like this (from the regex article)

    [Microsoft.SqlServer.Server.SqlFunction] [Schema(Name = “myschema”)] public static SqlBoolean RegexMatch(SqlChars input, SqlString pattern) { Regex regex = new Regex(pattern.Value, Options); return regex.IsMatch(new string(input.Value)); } <=-=Nov 23 2015 1:52PM=-=>

    Another work around I’m doing myself is I create a schema called Sys and I made it the default schema. All my CLR functions etc go in the sys schema where I have all utility related things. Then I gave everything else it’s own schema and I specifically refer to them everywhere. So I got rid of dbo entirely.

  16. SSMS, neue SQL Scripts per solution Explorer anlegen

    Im Solution Explorer kann man per rechte Maustaste ein neues Script erzeugen, dass auch gleich ge�ffnet wird, z. B. SQLQuery3.sql . Wird das Script umbenannt, so wird der Dateiname im Tabreiter des SQL-Scriptes nicht aktualisiert.

    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 a server property to specify data retention period for data stored in Analysis Service query log

    We are using SQL Server database to store Analysis Service query log data. Comparing to Analysis Service 2000, Analysis Service 2005 seem to log a lot more information to the query log, resulting in rapidly growing query log database for busy applications. We have a requirement to log every query on production servers. After just a few weeks into production, the query log database has grown to over 4G in size. What's the best way to deal with large amount of query log data? Apart from developing our own customized data purging mechanism, it will be very helpful to have…

    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. ROLAP should utilize MOLAP indexes on other dimensions

    Build a simple cube with one measure group called MyFact which is MOLAP. That measure group should have a date dimension called Date which is MOLAP. It should also have a huge dimension called Huge which is ROLAP.

    Now run the following queries (clearing the cache in between each):

    select [Measures].[My Measure] on 0,
    Exists(
    [Huge].[Key Attribute].[Key Attribute].Members
    ,[Date].[Date].&[20070401]
    ,"MyFact"
    ) on 1
    from MyCube

    select [Measures].[My Measure] on 0,
    NON EMPTY [Huge].[Key Attribute].[Key Attribute].Members
    from MyCube
    where [Date].[Date].&[20070401]

    Note that in both cases, the first SQL query it fires off is basically a select * from the huge dimension…

    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 →
  19. BACKUP Encryption

    We all know that we can open up a BAK or TRN file using any text editor and see something readable. Anybody who can grab a hold of the backup files can simply restore it to any SQL Server instance and see the data inside the backup file.

    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: 5

    <=-=Sep 4 2007 11:40PM=-=>

    This is a very valid point. Might be a challange to read a terabyte backup with notepad. Securing backups, which tend to hang out on disk drives these days and not carried away tape drives anymore, is a very valid request.

    <=-=Nov 15 2007 1:03AM=-=>

    HI cpdaniel,

    thanks for reporting this issue. We will investigate and update this space accordingly.

    Regards
    Vinod

    <=-=Nov 15 2007 1:05AM=-=>

    HI bass_player ,

    ignore previous note. Thanks for reporting this issue. It is valid security issue you are suggesting and we will consider this for our future release.

    Regards
    Vinod

    <=-=Dec 18 2007 1:27PM=-=>

    This is functionality that we are planning to implement, however it will not make it into the SQL 2008 release. Your Connect entry and the other votes for it will help make sure that it is ranked appropriately in planning the next release. Thank…

  20. Usage Reporting in Reporting Services

    To be able to track report usage, size, and execution times, it would be nice to have some built in, supported reports.

    Samples of this are available here: http://www.codeplex.com/MSFTRSProdSamples/Wiki/View.aspx?title=SS2005!Server%20Management%20Sample%20Reports&referringTitle=Home.

    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