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. Database with auto create statistics OFF gives a warning, even after enabling auto create stats, running the query and disabling it again.

    Consider the next test data:

    -- create database
    USE [master]
    GO
    DROP DATABASE IF EXISTS my_test;
    CREATE DATABASE my_test;
    GO
    ALTER DATABASE my_test SET AUTO_CREATE_STATISTICS OFF;
    ALTER AUTHORIZATION ON DATABASE ::my_test TO sa;
    USE my_test
    GO

    -- create dbo.tabela1

    CREATE TABLE dbo.[tabela1]
    (
    [Id] int NOT NULL identity(1,1),
    [kol1] varchar(20) NOT NULL,
    [Kod] int NULL,
    CONSTRAINT [PK_tabela1] PRIMARY KEY NONCLUSTERED([id] ASC) WITH (ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON),
    CONSTRAINT [BK_tabela1] UNIQUE CLUSTERED([Kol1] ASC) WITH (ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON),
    );
    GO

    -- create Index

    CREATE UNIQUE NONCLUSTERED INDEX [AKF_tabela1_Kod]
    ON dbo.[tabela1]([Kod] ASC)
    INCLUDE ([id],[kol1])
    WHERE ([Kod] IS NOT NULL) …

    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 →
    • I'd love to see better documentation from Microsoft around the GPO problems encountered when installing Machine Learning Services.

      Thee are various problems encountered when installing Machine Learning Services on a Windows Server or Windows 8/10 machine that is part of a domain. In particular, group policy options prevent the LaunchPad service from starting, a problem not apparent on non-domain joined machines. This in turn prevents Machine Learning services being used as the troubleshooting is challenging to put it mildly, which in turn PREVENTS ADOPTION of a flagship part of the SQL Server product line that gives you a clear edge over competitor's offerings. You're actually preventing adoption of your own cutting edge technology by making it too difficult,…

      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

        1 comment  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
      • TRUNCATE TABLE command in SSMS doesn't recommend tables as other command do.

        When I type "INSERT INTO " with a space and either wait or press CTRL+Space, I get a list of recommended objects via IntelliSense that I can insert into.
        If I type "TRUNCATE TABLE " with a space, and press CTRL+Space, no IntelliSense suggestions are displayed.
        I expect SSMS to show me a list of suggested tables, based on the database that the query is currently running against.
        This has been tested in SSMS 17.9.1 both by itself as the first line, and with a USE statement preceding it.

        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 →
        • Query Store report for forced plans fails when sorting by certain columns

          When using the Query Store built-in report 'Queries with forced plans' you can click the column headings in the top left pane to sort the data.

          If you choose 'last query execution time' or 'last forced plan execution time', the report clears and the pane displays the message 'Couldn't connect to database'.

          All other columns seem to sort correctly

          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 →
          • Potential bug in sql Microsoft SQL Server 2017 (RTM-CU5) (KB4092643) - 14.0.3023.8 (X64)

            create table #data (JobHistoryId2 int, jobName varchar(100) )
            create table foo (JobHistoryId int, jobName varchar(100))
            insert foo values(1,'one'),(2,'two')
            insert #data values(1,'one')
            begin tran
            delete from foo where JobHistoryId in (select JobHistoryId from #data)
            select count(*) from foo -- deletes all data but the statement (select JobHistoryId from #data) has an error.
            rollback tran

            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

              4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
            • SSMS 18 Preview 5 - Object Explorer window is floating when double clicking from Explorer

              In SSMS 18 Preview 5, if I double-click on a .sql file in File Explorer, it starts SSMS but the Object Explorer window is floating. When I start SSMS normally (not with the file association), the Object Explorer window is docked on the left.

              It should keep the same window configuration regardless of how it is started.

              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 →
              • 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 →
                • trunc(date)

                  Since moving from Oracle to Sql Server, I've really missed the trunc function for dates.

                  The TRUNC (date) function returns date with the time portion of the day truncated to the unit specified by the format model fmt. The value returned is always of datatype DATE, even if you specify a different datetime datatype for date. If you omit fmt, then date is truncated to the nearest day.

                  @Today = trunc(sysdate)

                  Much better than monkeying around with converting datetime to string and back to a datetime.

                  2 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

                    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                  • Ignore BUCKET_COUNT in schema compare

                    Ignore BUCKET_COUNT in Schema Compare

                    Due to data set size, I have different settings for BUCKET_COUNT in dev, test, and prod environments. Schema compare keeps on flagging those tables.

                    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 →
                    • We need web-based SQL Server Management tools

                      Because we will think let Ops team can query or update some data, SSMS is too powerful and everyone must install it on the client. I think you maybe have tool it likes the azure sql database that has the web base sql query editor in our company

                      5 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

                        1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                      • Enable users to select all with exceptions

                        When trying to select multiple columns we are met with the issue of having to list each one if we do not wish to view all of the columns at once. For example, if I wish to view all of the columns except for one, I have to list each one I want. I propose that we be able to select all with exceptions to it. All except one.

                        2 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

                          0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                        • 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 →
                          • Support Overloading in DATALENGTH() as in CHECKSUM()

                            CHECKSUM() accepts and arbitrary list of columns or "*" when being iterated over data rows.

                            I would like to be able to use DATALENGTH() in the same manner instead of typing out DATALENGTH(Col1) + DATALENGTH(Col2). Although - in fairness DATALENGTH(NULL) is currently NULL, so this might require a breaking change to return 0 instead of NULL to support concatenation in this way.

                            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 →
                            • Persist unsaved queries, the way Notepad++ and Visual Studio Code do.

                              Persist unsaved queries, the way Notepad++ and Visual Studio Code do. Reopening the files (saved or not) with the pending changes they had after the previous session.

                              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 startup is particularly slow

                                ssms startup is particularly slow

                                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 →
                                • SELECT vs INSERT INTO SELECT different number of rows with recursive cte

                                  I would like to ask for clarification if this behavior is "by design" or is it a bug.
                                  The idea is that recursive CTE returns 6 rows, but when combined with INSERT INTO ... SELECT it has only 4 rows.

                                  Example: https://dbfiddle.uk/?rdbms=sqlserver_2017&fiddle=43994e3e6fd8c3228b60a3323c0689ef

                                  Usage of MERGE or any blocking operators like `TOP (100) PERCENT`/`ORDER BY 1 OFFSET 0 ROWS` will cause that both SELECT and INSERT INTO SELECT have the same 6 rows.

                                  https://dbfiddle.uk/?rdbms=sqlserver_2017&fiddle=b3fcfcd39dcee90aff68629f894f8c97

                                  Original source: https://stackoverflow.com/questions/50157079/sql-server-cte-loop-insert-all-record-together

                                  2 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

                                    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                  • SQL Management Studio in French indicates an update version, but new version is only in english

                                    SQL Management Studio in French indicates an update version, but new version is only in english. Not a big issue but I have always a wrong notification on startup

                                    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 →
                                    • New tool which can automate the entire configuration of SQL Server AlwaysOn, DB Mirroring and others

                                      I have developed an idea where the entire execution of configuration of AlwaysOn for upto 5 replicas can be executed with in 10 -50 minutes
                                      The tool can be built as web based tool and user can login and execute the request , this tool can be extended to other activities like log shipping, db mirroring , DB Refresh and many more , this saves more 3 - 4 hours time

                                      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 →
                                      • Start-SQLInstance and Stop-SQLInstance doesn´t works on SQL Server 2016

                                        Start-SQLInstance and Stop-SQLInstance doesn´t works on SQL Server 2016

                                        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

                                          1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                        • In "Options \ SQL Server Object Explorer \ Scripting", "Script Statistics and Histograms" not available

                                          Script Statistics and Histograms is not available when setting scripting defaults.

                                          It is available when we select Specific Database and access "Tasks" \ "Generate Scripts".

                                          But, not available when we access Menu and select the Menu Options :-
                                          a) Options
                                          b) SQL Server Object Explorer
                                          c) Scripting
                                          d) Script Statistics

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

                                          SQL Server

                                          Feedback and Knowledge Base