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

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

    We’ll send you updates on this idea

    6 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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…

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

    We’ll send you updates on this idea

    18 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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.

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

    We’ll send you updates on this idea

    18 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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…

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

    We’ll send you updates on this idea

    60 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Change execution plan terminology

    SQL Server has since almost forever used the terms "Actual Execution Plan" and "Estimated Execution Plan" for execution plans with and without added run-time counters. And this has since almost forever caused confusion and misunderstanding.

    Erin Stellato, Grant Fritchey, and me, with the help of Pedro Lopes, have prepared a proposal for better terminology. Terms that better describe the reality and have less chance for confusion.
    See https://sqlserverfast.com/blog/hugo/2020/02/stop-the-name-calling-execution-plan-terminology/ for a more detailed explanation.

    Together with Erin and Grant, I request Microsoft to change the terminology in their tooling. In the next release of Management Studio, please replace "Estimated Execution Plan"…

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

    We’ll send you updates on this idea

    unplanned  ·  7 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add support for ISO/IEC SQL SEARCH clause to recursive CTEs in T-SQL

    ISO/IEC SQL supports a SEARCH clause in recursive CTEs (what they call with list element). This clause allows you to indicate the recursive search order in a graph structure as BREADTH FIRST or DEPTH FIRST by some ordering column. Using this clause, you also define a new sequence column that indicates the ordinal position of the current row based on the desired search order. This feature enables you to order hierarchical/graph data for presentation purposes using the two aforementioned search orders, both of which are quite commonly needed.

    Here’s the syntax for the search clause:

    WITH <CTE name> ( <column…

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

    We’ll send you updates on this idea

    3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Create a new DMV that Exposes CPU Utilization Information

    One common way to get CPU utilization by SQL Server is to query the sys.dmosringbuffers DMV. This DMV is undocumented and unsupported. It also sometimes returns incorrect information (with negative values or values over 100%) on some systems. This usually happens on systems that have more than 64 cores. I have attached a sample query that uses sys.dmosringbuffers for this purpose.

    It would be very useful to have a new DMV (that was supported and documented) that would more reliably return this information.

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

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add support for ISO/IEC SQL CYCLE clause to recursive CTEs in T-SQL

    This request shouldn’t be confused with request 40923541 (https://feedback.azure.com/forums/908035-sql-server/suggestions/40923541).
    ISO/IEC SQL supports a CYCLE clause in recursive CTEs. This clause allows you to identify cycles in a graph. It allows you to define a new column that indicates when a cycle is detected with the current row based on some column(s), and return a new column with your chosen value indicating that a cycle was found (e.g., 1, ‘Yes’, etc.), and some default value when it isn’t (e.g., 0, ‘No’, etc.). This feature also prevents the query from failing when a cycle is detected; it just stops pursuing…

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

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  9. Dynamic data deidentification (dynamic data masking enhancement)

    Existing data masking feature has limitation - when query is executed it compares the data to actual value stored in row. This allows brut force attack on dynamically data masked column to output the actual record for the column which is attacked. Even though presented column will display masked number but attacker knows the original value of that field.

    Instead of comparing the original value stored inside the database, if feature allows me with trace flag or any other way to compare data to masked value. It will result in completely unknown records and attacker will not be able to…

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

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Allow Resource Governor to control the CAP of the TOTAL IO in MB/s

    We need to define the maximum total disk throughput (MB/second instead of IOPS) per Resource Pool and to be able to cap the total maximum throughput on the SQL Server Instance level in Resource Governor.

    The current offering of MAXIOPSPER_VOLUME allows us to control one common value across a number of different volumes, where IOPs is not a very constant, since SQL Server does a wide range of different block sized operations.

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

    We’ll send you updates on this idea

    2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  11. In DROP TABLE statement, make table order irrelevant

    Current behavior is described in the docs: "If both the referencing table and the table that holds the primary key are being dropped in the same DROP TABLE statement, the referencing table must be listed first."

    It would be great to not worry about order.
    It should be possible to list the tables in any order as long as any foreign key referencing tables that are being dropped, are also being dropped in the same statement.

    11 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. Add support for Row Pattern Recognition in T-SQL (SQL:2016 features R010 and R020)

    The ISO/IEC 9075:2016 standard (aka SQL:2016) introduces support for Row Pattern Recognition (RPR) in SQL. Similar to using regular expressions to identify patterns in a string, RPR allows you to use regular expressions to identify patterns in a sequence of rows.
    To me, it's the next step in the evolution of window functions. If you think that window functions are profound and useful, RPR is really going to bake your noodle.
    RPR has limitless practical applications, including identifying patterns in stock market activity, handling time series, fraud detection, material handling, shipping applications, DNA sequencing, gaps and islands, top N per…

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

    We’ll send you updates on this idea

    under review  ·  9 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Restore a table from a backup

    Hi Msft team!
    I'm writing to reccomending a new feature that will help us a lot! Every time that we have data issues (truncate or DML by accident) we need to restore the entire database or filegroup and that takes a lot of time! it will be awesome if you can add the posibility to restore a table from a backup or restore to a point in time directly from SSMS instead off the whole process.
    I hope this helps!
    Thank you!

    1,033 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    100 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  14. Connect to Database option in SQL Connection Prompt of SSMS?

    Show Database selection along with the Server Name in the SQL Connection Prompt SSMS as many of the times it confuses when it needs to go to options and select the database you want to connect or even, when you only want to connect to the master only, then it may confuse the user why it is not connecting. Improving SSMS UX by promoting visibility of connection properties will help a lot.

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

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Query plans with MSTVFs in them don't include time populating the table variable

    Imagine if you will, that you're using a multi statement table valued function. When you run a query that calls it, it may run for a very long time, but when you look at the operator times in your query plan, the time spent in the MSTVF isn't anywhere obvious.

    The time will show up in the plan properties as elapsed time, so it is associated with the query somehow. I think it would be beneficial to present the time spent in the function in the TVF operator.

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

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Change Default SSMS behavior when connection to Azure Sql blocked by firewall

    It would be nice if when you try to connect to Azure Sql that when it is denied because of a firewall there was a couple of extra options

    1 work like it does today, but update the default name to be a little more descriptive. Include the username that you should have when they login.

    2 a link to the portal directly to the SQL blade
    3 cancel the connection.

    More info for 1. The problem is you can have a select of users who should b able to log in and manage SQL. The problem is they tend…

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

    We’ll send you updates on this idea

    2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add support for standard nested window functions in T-SQL

    The ISO/IEC SQL:2016 standard defines a concept called nested window functions that allows you to nest two kinds of window functions as an argument of a window aggregate function. The idea is to allow you to interact with row markers representing strategic points in windowing elements like the beginning or end of the partition, beginning or end of the frame, the current outer row, and the current inner frame row.
    The two standard nested window functions are the nested row number function and the nested value_of expression at row function.
    The former allows you to refer in an argument of…

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

    We’ll send you updates on this idea

    8 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Need to be able to list files in Azure BLOB storage, not just open them

    in Azure SQL Database, OPENROWSET does a great job of reading files (like CSV/TSV files) from Azure BLOB storage.

    But there's currently no way from within Azure SQL Database to read the list of files that are currently in a container. That's a significant feature gap.

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

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Allow trusted services in Azure SQL server firewall

    This feature is currently available on Storage Account, it will permit the following :


    • Grant access to Azure services registered in the same subscription.

    • These trusted services will then use strong authentication to connect to our SQL Server securely.

    19 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 →
  20. Allow index creation for tables within a SNAPSHOT isolation level transaction

    While it is possible to create a table including an index within a SNAPSHOT transaction (in my specific case, a temporary table) and then populate it with data, it is not possible to create a table, add data to it, then add the index.

    There are many cases when using temp table processing where the performance penalty for adding data to an already-indexed table can make the operation take 2x the amount of resources or even more. For large tables, this can make it impractical to use SNAPSHOT isolation even in cases where it would otherwise be very desirable.

    Requesting…

    5 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 →
← Previous 1 3 4 5 211 212
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base