SQL Server

Microsoft SQL Server 2017 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 2017 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.

Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. ssdt 2017 analysis service

    Slow M queries to import tables or create relationship in VS 2017 SSDT Analysis Service (SSAS) 2017 tabular model with Teradata data source and DirectQuerymode enabled, > 10 + mins to import a few tables. Temp workaround is to use native query. Please improve performance for the new Get data experience in VS SSAS project.

    1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    • CmdExec Proxy Account for SQL Server Agent doesn't load full Profile / User Registry Hive

      I have a SQL Server agent job that has a single CmdExec step that executes a NetBackup program. This job works fine when the account running the job is a member of the sysadmin server role.  In this case the command is executed under the context of the domain account to which SSA is configured to run with.  Both the database engine and SSA are using the same domain account which is also in the local administrators group in the OS. 
      If I remove the account running the job from the sysadmin server role, I then need to setup a…

      1 vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
      • SSIS Dedicated Installation

        SSIS is clearly a developer/ETL tool that is not dependent on the SQL Server database engine. We actually don't install Integration Services on our database servers. Many times we hand-off the installation to the LOB teams to install on their dedicate SSIS servers. It's time to decouple, separate SSIS from the SQL Server Installation. Just like SSRS, SSIS needs to be a standalone product installation.

        1 vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
        • dm_db_stats_histogram missing row when column/histogram step contains NULL

          When statistics on a nullable column contain a NULL sys.dm_db_stats_histogram will not return a row for the corresponding histogram step (when RANGE_HI_KEY is a NULL). DBCC SHOW_STATISTICS returns all steps including the aforementioned missing one. Without all the histogram levels dm_db_stats_histogram is not usable.

          I can confirm this behaviour with INT and VARCHAR columns, I haven't tested other data types). I have attached the reproduction code and a screenshot. Any questions please let me know. Thank you.

          SQL Version: 14.0.3025

          1 vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
          • Notebook for SSMS

            I would like an add-in to SSMS that work like the notebook RMarkdown in RStudio. In RMarkdown the code is written in the notebook and where run the result is saved in the notebook. For SSMS I think that saving the message, the queryplan and eg top 10 of the resultset (if any). The purpose is to have an “autogenerated log” of the code I run and what happened (changes or result).

            1 vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
            • SSMS v17.6 crashes on job schedule properties dialog

              1 . Connect to a server instance you wish to establish logshipping from
              2. Right-click on the database you wish to logship and choose ‘Tasks’ -> ‘Ship transaction logs…’
              3. Configure primary database settings then click ‘add’ under the secondary config…
              4. Connect to the intended secondary, set options for initialize secondary database (I usually use ‘yes, generate…’)
              5. Click the ‘copy files’ tab, set a location, and then hit ‘schedule’
              6. This error will show up:

              7. If you click the ‘restore transaction log’ and hit the ‘schedule’ button there, the same error shows up:

              1 vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
              • TDE support for msdb

                Please add support for encrypting msdb. Confidential information may be in jobs or in sent emails. There are probably other places too.

                Optimal for me would be to just follow the behavior of tempdb. I understand why that may not be desirable, especially for the automatic decrypt.

                1 vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                • Row filtering by a condition at bulk insert

                  It would be very useful to have a possibility to specify in the format file or in the bulk insert statement a "WHEN" option to filter out / skip rows of the input file not matching a condition. Something similar than Oracle's data loader's WHEN option. It would be important to not parse the rest of the row, just to find the next row terminator and continue with the next row (allowing multiple column configurations).
                  This single option would allow to import structured input files, avoiding the usage XML, which is very slow and memory demanding in case of XML…

                  1 vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                  • determine cause error row in long data

                    when we work to a table with long data we don't know which row is cause of error in insert\update !

                    1 vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                    • Incorrect permissions check in sp_updatestats for non-sysadmin user

                      Stored procedure sp_updatestats won't run when you are a MEMBER of db_owner but not the actual db_owner account. The permission check is incorrect, it compares the user sid rather than checking role membership. See my notes at:

                      https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-updatestats-transact-sql?view=sql-server-2017#comments-container

                      1 vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                      • Reduce PAGELATCH_XX on Heavy Concurrent INSERT

                        PAGELATCH_UP/EX waits rack up large volumes of wait time during critical overnight processing of millions of rows of data. Despite reducing the "items-per-write" down to 2000, well under the threshold for lock escalation, we see these waits during a single elapsed 60 minutes amount to over 8 hours for the _UP type.

                        Our calculation engine is highly multi-threaded and uses Azure Nodes for complex inventory management/distribution/ordering. SQL has become the bottleneck on writes.

                        With ACID requirements in mind, it isn't feasible to post to files and bulk insert to take advantage of the optimized batch-insert logic from 2016 onwards.

                        Would…

                        1 vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                        • Retain CR/LF on copy or save

                          Since upgrading to SSMS version 17.6, the Tools...Options...Query Results...SQL Server...Results to Grid...Retain CR/LF on copy or save, has stopped working. When copying the grid, and pasting in Excel, any CR/LF in the grid cells, are being split into new rows. I want to keep everything in a cell in SSMS, to paste in a single cell in Excel.

                          Before upgrading to this version, checking this box worked as I want it to. However, now that checkbox seems to do nothing.

                          1 vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                          • declare @VarName as [Schema].[Table].[Column]%Type

                            I would like to reuse a Variables type from a Columns Type. There would be no need to check the ColumnType anymore - and if a column is altered the Stored Proc should be recompiled.

                            1 vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              under review  ·  1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                            • SSRS 2017 subscriptions date format

                              Several users have an error message when they try to create/modify subscriptions with a date parameter that have a default value (using internet explorer).
                              In the log file of reporting service I see this error:

                              System.Data.SqlClient.SqlException: Converting a varchar data type to a datetime data type has created a value out of bounds

                              No problem with Chrome.
                              Good date format "dd/MM/yyyy". Wrong date format in IE "MM/dd/yy".

                              I found a workaround with adding French(France) in the languages configuration in IE client. Instead of French(Belgium) wich has a different date format.

                              Is it possible to configure SSRS to use only server…

                              1 vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                under review  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                              • CEIP Service cause noisy error log

                                We found that CEIP Service causes following error log messsage in production server.

                                CImageHelper::Init () Failed load of symbol file with path = D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\;D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\BINN Error Code 0xc0000004

                                - 0xc0000004 : The specified information record length does not match the length that is required for the specified information class

                                following attached file is event log that I collected.
                                Version of prod server is following (which is on AZURE):
                                Microsoft SQL Server 2016 (SP1-CU5) (KB4040714) - 13.0.4451.0 (X64) Sep 5 2017 16:12:34 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Datacenter 6.3 <X64>…

                                1 vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                • Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.ProcessQueueItems

                                  SQL Server should not crash when it encounters issues w/ database mail or SMTP.
                                  A SQL Server 2017 instance suddenly started crashing (terminated unexpectedly) every few minutes. When I discovered SMTP service was stopped & restarted it, the crashes ended.
                                  A search through the Windows event log revealed that when database mail tried to send w/ the SMTP service offline, it generated an exception that caused the SQL Server service to terminate unexpectedly.
                                  Obviously, this is not acceptable behavior. SQL Server should handle & report such exceptions w/o issue. I have not encountered this problem on other versions of SQL…

                                  1 vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                  • join hint in sys.dm_db_column_store_row_group_physical_stats couses error when the database option parametrization is set to FORCED

                                    SQL Server 2016 build 13.0.4466.4
                                    Database: AdventureWorks2016 (works on any database)
                                    Query:
                                    select db_id() AS database_id,
                                    ISNULL(AVG(convert(decimal(10,2),(100 *((cs2.[rowsin_deltastore_count] *1.0) /
                                    ((CASE WHEN cs1.[total_rows_count] = 0 THEN 1 ELSE cs1.[total_rows_count] END)* 1.0))))),0)
                                    as [percent_open_deltastore] from
                                    (select object_id, index_id, SUM(total_rows) as [total_rows_count] from sys.dm_db_column_store_row_group_physical_stats
                                    group by object_id, index_id) as cs1
                                    join
                                    (select object_id, index_id, SUM(total_rows) as [rowsin_deltastore_count]
                                    from sys.dm_db_column_store_row_group_physical_stats where state = 1 group by object_id, index_id) as cs2
                                    on cs1.object_id = cs2.object_id and cs1.index_id = cs2.index_id

                                    Error:
                                    Msg 8622, Level 16, State 1, Line 1
                                    Query processor could not produce a query plan because of the hints defined in this query.…

                                    1 vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                    • New security role for SQL Agent - SQLAgentAdminRole

                                      I feel the SQL Agent roles are too limiting. If you want to allow freedom in a development, or assign management of SQL Agent jobs to a person; even SQLAgentOperatorRole doesn't do much. This means SysAdmins are still required to assist others in altering/removing jobs.

                                      I propose a new role that allows the member to do anything with SQL Agent, like a member of SysAdmin, but without the access to all other parts of SQL Server that SysAdmin provides.

                                      4 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                                      • SSDT/ SSIS background of drop down menus is black

                                        When opening a execute package task and there looking at the parameter bindings the background is black and the font color is black as well.

                                        Environment
                                        Microsoft SQL Server Data Tools for Visual Studio 2017 (SSDT)
                                        Version 15.6.6
                                        VisualStudio.15.Release/15.6.6+27428.2037
                                        Microsoft .NET Framework
                                        Version 4.7.02556
                                        SQL Server Integration Services
                                        Microsoft SQL Server Integration Services Designer
                                        Version 14.0.3002.101

                                        Windows 10

                                        1 vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Opening Schema Compare Options crashes SSDT

                                          I open a saved schema comparison and press the arrow in front of "Application Scoped" on the "Object Types" tab. This makes SSDT crash immediately.

                                          Microsoft SQL Server Data Tools for Visual Studio 2017 (SSDT)
                                          Version 15.6.6
                                          VisualStudio.15.Release/15.6.6+27428.2037
                                          Microsoft .NET Framework
                                          Version 4.7.02556
                                          SQL Server Data Tools 15.1.61801.210
                                          Microsoft SQL Server Data Tools

                                          1 vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 400 401
                                          • Don't see your idea?

                                          SQL Server

                                          Feedback and Knowledge Base