Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

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 Microsoft Q&A or Stack Overflow

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add execution plan warning for hard-coded estimations

    When query plans have hard-coded estimates, like the 30% hard-coded estimate for < or > when adding multiple columns:

    SELECT * FROM dbo.Users u WHERE u.UpVotes + u.DownVotes > 10000000;

    Then the query plan operator that does that filtering should show a yellow bang. The estimates on that operator will be 30% of the number of rows in the table, regardless of whether the query uses a greater than, less than, and regardless of which number we put in the filter.

    More info & demos: https://www.brentozar.com/go/nobangs

    111 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Make ADS An Optional Install Alongside SSMS

    Starting with SSMS 18.7, Azure Data Studio is being automatically installed alongside SSMS with no option to not install it. ADS is still available as a standalone install, though.

    I'd like a way to make the install optional for people who don't need any ADS functionality.

    Particularly for admins putting SSMS on their SQL Server for whom additional unknown dependencies might not be tolerable to security teams, not having to remember to uninstall additional items every time they update SSMS would be helpful. Even with an automated deployment, it requires an installation and then multiple uninstaller runs.

    On top of…

    341 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    From Apr 24, 2019 (https://cloudblogs.microsoft.com/sqlserver/2019/04/24/sql-server-management-studio-ssms-18-0-released-for-general-availability/):
    Think of these two tools not as separate tools doing different things, but as one integrated tool. Each tool has different experiences built into it and can be launched from the other seamlessly.

    From Oct 20,2020 (https://cloudblogs.microsoft.com/sqlserver/2020/10/20/sql-server-management-studio-18-7-now-generally-available/):
    SQL Server Management Studio is a foundational tool for many working with Microsoft data solutions. First released in 2018, Azure Data Studio is a cross-platform and open source desktop environment for data professionals using the Azure Data family of on-premises and cloud data platform solutions. Architecturally, SQL Server Management Studio has long been combined with additional tools, including Profiler, Database Engine Tuning Advisor (DTA), and Database Mail. As Azure Data Studio continues to mature, the Microsoft data tools experience on Windows has become a combination of SSMS and Azure Data Studio. Beginning in the 18.7 release of SQL Server Management Studio, Azure Data Studio…

  3. Allow Memory Grant Percent To Be Set In Standard Edition

    In 2016 SP1 we got many features handed down to Standard Edition, but Resource Governor was not one of them.

    In Enterprise Edition, Resource Governor is frequently used to reduce the maximum memory grant percent down from 25. That prevents queries that you don't have control over from totally trashing your server. Since memory grant feedback is not available in Standard Edition, users aren't left with many options. Query hints are nice, but only if you can change the queries.

    Max grant percent should be either settable in Standard Edition, or decoupled from Resource Governor and settable at the database…

    17 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  4. Change limit/behaviour of msdb.dbo.suspect_pages table

    Currently the msdb.dbo.suspect_pages table has a 1000 row limit, once the table gets to 1000 rows it stops collecting new errors. This means that on servers where the suspect_pages tables has filled up you are unable to see if new errors are still being discovered.

    My suggestion would be to remove, or at least greatly increase the hard limit of 1000 rows in the suspect_pages table.

    Books online Documentation - Manage the suspect_pages Table
    https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/manage-the-suspect-pages-table-sql-server?view=sql-server-ver15

    "The suspect_pages table contains one row per page that failed with an 824 error, up to a limit of 1,000 rows."

    "Database administrators are responsible…

    178 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  5. comment the selected text in query editor

    Please provide a shortcut which can comment the selected text (not the complete line) in query editor window in SSMS by enclosing it between forward slash - asterisk and asterisk - forward slash.

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Cardinality Estimator - Specify Execution hints at object definition and/or execution level

    Today we can set execution context at different levels. In particular decide which Cardinal Estimator (CE) version to use to execute our workload.
    At Instance , session , database and/or query levels by using trace flags, database scoped configuration and/or query hints.
    There are cases where some workload runs better using the legacy CE and others with the current (or most recent) CE

    I believe it will be extremely useful to be able to specify execution content at object level (procedures and functions) so if the object is defined to use a particular CE, the execution plan will be generated…

    105 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    18 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Trace Flag/sp_configure Option to Allow Developer or Evaluation Editions to "Act" like Standard Edition

    One of the challenges for many customers who need to use Standard Edition is that both Developer and Evaluation Editions of SQL Server are the same functionally as Enterprise Edition. This means that in non-production scenarios/environments, without buying a full license of Standard Edition (or having MSDN), you are potentially using (or able to use) features not available in Standard. Dev and Eval should have a way to allow those who will ultimately be using Standard to constrain what features are used as well as any performance limitations in Standard so their eval/dev/testing efforts are accurate.

    332 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    18 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Reduce free space and optimize indexes for prepare database for a Read-Only state

    MSSQL should have a tool that allows users - reduce free space and optimize indexes to prepare a database for a state Read-Only.
    Current commands "shrink database/files" and "rebuild indexes" are against each other. The first reduce a free space but defragment all indexes, the second fragments indexes but add free space into the database.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  9. SQL Server vNext (post 2019) and NoSQL functionality

    Hello,

    This is an invitation for discussion to the SQL Server engine team and the community.

    IMHO, SQL Server vNext (post 2019) should beef up its NoSQL functionality.
    Specifically, its XML APIs.
    This area is dormant since 2005/2008 release.

    SQL Server currently supports the following:
    - a subset of XQuery 1.0, circa 2007
    - a subset of XPath 2.0, circa 2007
    - XSD 1.0 circa 2001

    The current w3c standards:
    - XQuery 3.1
    - XPath 3.1
    - XSD 1.1 circa 2012

    Everything is in place, even current support for the UTF-8 encoding in 2019.

    Famous Obamacare is implemented by using…

    593 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    102 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Add JSON data type for design table

    Hello!
    Some new DBMS, use JSON data type in the world.
    SQL Server has JSON-functions and supports very good JSON values.

    For example: xml data type has x-pad query, datatype in table and etc in SQL Server.
    Like this SQL can add JSON data type for column. and no need(to) parse ISJSON. this new feature is a datatype and no need (to) parse.

    Then we can expended data on this column by JSON Formatter in SQL Server for manage this data type, like MONGODB save Array.

    This datatype save array, and can save data types number and string by ISJSON…

    15 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Dynamic Sorting within SQL Stored Procedures

    although it is possible to perform a sort with the case statement, it is not possible to sort by different data types, this makes you have to convert dates and int (for example) to varchar, which makes the sort not behave correctly in these types of data. The other option is to build the raw query which increases the probability of error and adds complexity to the reading of the query, my suggestion is that the sort can be make dynamically with parameters (at this point I don't know if this is possible) but this is An example:

    ORDER BY…

    19 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  12. SQL Cluster does not failover on loss of local disk with tempdb

    My suggestion is to add a traceflag so we can force SQL to initiate a failover on losing access to the local drive the tempdb or bpe resides.

    Why ?
    With new hardware like NVME on LS32 VM's in Azure, or VmWare VM's with local NVME drives we can get a serious performance boost on tempdb and BPE.

    The local disk turns into a non-clustered resource on which your SQL installation depends and the cluster service has no way of knowing the health state of your local disk. If your TEMPDB local disk fails, the SQL Server instance does not…

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Add Extended Property : DatabaseUser

    Ref: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addextendedproperty-transact-sql?view=sql-server-ver15

    Currently the capability to add an extended property on a database for a USER is set to go away. I believe that this is due to some confusion between a database user account (normally tied to a SQL instance login), and a database schema.

    I would like to suggest a new Level0 extended property called [DatabaseUser] so that I can fully describe those accounts which have specifically been granted access to the database.

    This would require updates to at least the following :
    - sys.spaddextendedproperty
    - sys.sp
    dropextendedproperty
    - sys.spupdateextendedproperty
    - sys.fn
    listextendedproperty

    Suggested syntax:

    EXECUTE…

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  14. SSRS – Header/Footer should be able to be dynamically set in size and visibility

    We have an invoice situation where we would like to use an image as the footer in the page. This image should only print on a certain page depending on the content of the report, this image should also be able to scale with the footer as not all clients use the same size image for the footer. Currently in ssrs there is no way to dynamically hide/show the footer based on page number, additionally there is no way for the footer to grow/shrink depending on the content of the footer. If you set the footer to be .5in, it…

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  15. copy only backup checkbox

    In SSMS (SQL Server Management Studio) default the 'Copy-only backup' checkbox to checked on the 'Back Up Database' interface.

    This is the method our software developers use to make a copy of a production database for lower dev/test environment. When they cut and paste the backup it breaks the backup chain.

    The current default is uncheck to not create a Copy-only backup.

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Another option for creating/updating the dev/test environment(s) would be the “Export Data-tier Application” option in SSMS to produce a bacpac file. Through this method the backup chain of production is safe from unintentional disruption and the whole process can be automated through the command line utility SqlPackage.exe.

  16. Add CHANGE_TRACKING_CURRENT_VERSION to sys.change_tracking_tables

    If changetrackingtables had the last value of CHANGETRACKINGCURRENT_VERSION for each table, it would make much easier to detect which tables has changed since a previous moment in time.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Need to add DQS rules by batch

    Customer has a request to improve method adding Domain Rules in DQS. He has many rules to enter, is it possible to have a way to create rules by batch, for example import from files?

    From the DQS Client, currently we can only do this manually, enter the rule one by one.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. T-SQL: Improve CURSOR loop by making FETCH a subquery returning @@FETCHSTATUS

    By making FETCH into a valid subquery returning @@FETCHSTATUS, this simplifies the standard cursor loop to avoid repeating the FETCH clause. This approach has the advantage of being backwards compatible (new way is currently a syntax error, old way still works after the change).

    WHILE (FETCH NEXT FROM cursor INTO @var) = 0
    BEGIN
    PRINT @var
    END

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Extend the SQL Server WITH clause to create "function on the fly" similar to CTEs being "views on the fly"

    Now that SQL Server can inline functions, there's no reason it cannot do "functions on the fly", similar to how CTEs are "views on the fly". Technically those won't be functions but rather macros - because they'll be inlined into the code like C/C++ macros.

    Both scalar and tabular functions can be implemented - the latter allowing for CROSS APPLYing.

    Something like this:

    --

    -- Scalar Macro

    WITH MyScalarMacro MACRO
    (
    @arg1 INT,
    @arg2 INT
    ) RETURNS INT
    AS (
    RETURN @arg1 + @arg2;
    )
    SELECT
    MyScalarMacro(column1, column2),
    MyScalarMacro(column3, column4)
    FROM
    MyTable;

    --

    -- Tabular Macro

    WITH MyTabularMacro MACRO
    (…

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  20. Support Synapse Serverless pools in SSDT

    Currently when trying to connect to a serverless pool via Visual Studio you get the error "FUNCTION 'SESSIONPROPERTY' is not supported" in 2017 and the "The server version or database compatibility level is not supported" in 2019. This limits the ability to use source control and a good CICD practice for these databases. Although source control is available in Synapse Studio, it doesn't extend yet through to the database level and you have to script all your objects out into SQL scripts for Synapse to manage.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 223 224
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base