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. SSMS not putting the domain name for Availability Group Failovers

    We have AGs in a different domain than our AD. When we try to failover with the wizard it tries to connect as our AD user but without the domain name attached to the server so it fails because serverName.ADdomain.net doesn't exist but serverName.hosteddomain.net does. We found a workaround of clicking options, login tab, then SSMS will display the server name with the correct domain.

    With that said, today while implementing the workaround the serverName was wrong. It showed our QA environment instead of the Prod environment.

    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 →
    • Combined change tracking and temporal table, outputting change and changetype

      My suggestion is basically a 3-part temporal table, adding to the existing _history also a _change(log) table automatically keeping record of the changes and changetypes (update, insert, delete), so that the next table up (thinking a layered dwh here) can recieve delta records as inserts only

      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 →
      • Concatenating varchar(max) columns into a string should work like varchar(n)

        Currently, if you execute a statement like:
        DECLARE @str varchar(max);
        SELECT @str = '';
        SELECT @str += [SomeColumn] + ',' FROM SomeTable WHERE someCondition=true ORDER BY someColumn;

        The @str variable will contain all the requested values in the sting, PROVIDED the "SomeColumn" column is varchar(n). If it's varchar(max), then the value of @str will just be the LAST value of "someColumn".

        This difference in behavior seems like a bug. The SELECT statement should really work the same way regardless of varchar(n) or varchar(max). In fact, if you add a CAST() to cast the varchar(max) column to varchar(n), suddenly it works…

        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 →
        • 'Add Table...' context menu disabled when trying to add more tables in View Designer

          This bug only occurs when connected to an Azure SQL Server:
          In Object Explorer, selecting Views > New View
          Then selecting one or more tables by pressing the [Add] button.
          Then press [Close]
          If you then want to add additional tables by right-clicking the context menu, the item 'Add Table...' is disabled.
          Please make this item selectable.

          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 →
          • SSRS 2016 to be logged in using SAML 2.0 based authentication.

            Hi Team, I came across a requirement where my client wants SSRS 2016 to be logged in using SAML 2.0 based authentication. Client's existing applications are already running on SSO SAML 2.0 based authentication & he doesn't want to logon separately into SSRS either by Windows or Forms Authentication. What he wants is user should get Authenticated as per eixsting SSO SAML based authentication in SSRS as well. I tried various approaches but none worked. Can you shed some light on this?

            Regards,
            Sameer

            0 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
            • VSTA

              Why can't I debug a SSIS Scipt Task
              In ETL package with Target SQL 2012 i can when Scriptlanguage is VB / C# 2010 i can in in the VSTA editor / VS 2017.
              But cannot debug Script task (target SQL 2016) with Visual Basic C# 2015) in VS 2017

              Reproduce by:
              Create package, set Target SQL version to 2016
              Adding Script Task with breakpoint.
              Breakpoint gets skipped over here, so force debugger with code:
              Debugger.Break
              Debugger.Launch()

              Nice error

              PS I already disabled Resharper.
              https://youtrack.jetbrains.com/issue/RSRP-469962

              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 →
              • Columnstore REORGANIZE command increases modification_counter on table statistics

                Reorganizing a columnstore index can, in some cases, cause the modification_counter on the table's statistics to increase. This is unexpected because while the underlying structure of the table is being changed, the data itself isn't being modified. This can lead to issues where SQL is automatically updating statistics the next time a query is executed against the table in cases where the modification_counter increases a significant amount because of the REORGANIZE. This has been particularly problematic for our large fact table with 150+ billion rows and full scan statistics across 40+ columns.

                Attached is a reproduction script with three examples:

                14 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 →
                • error message from query on view over linked server inconsistent/unexpected

                  I have a linked server, with mappings for one user, let's call 'im 'foo':

                  EXEC
                  master.dbo.sp_addlinkedserver
                  @server = N'RMTSRV'
                  , @srvproduct=N'rmtsrv'
                  , @provider=N'SQLNCLI'
                  , @datasrc=N'rmtsrv'
                  , @catalog=N'test'

                  EXEC
                  master.dbo.sp_addlinkedsrvlogin
                  @rmtsrvname = N'RMTSRV'
                  , @locallogin = N'domain\foo'
                  , @useself = N'False'
                  , @rmtuser = @rmtuser
                  , @rmtpassword = @rmtpassword;

                  I then have a view:

                  go
                  create or alter view TEST_VIEW as
                  select * from openquery([RMTSRV], 'select * from test_tbl;');
                  go

                  grant select on TEST_VIEW to [domain\foo];

                  -- and test, as sa:

                  execute as login = 'domain\foo';
                  select top 10 * from TEST; -- works
                  revert;

                  -- expected-to-fail test
                  execute as login…

                  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 →
                  • SSMS refresh statistics name on key rename

                    Using SSMS object explorer to rename a key (clustered primary key). The corresponding index name refreshes but the statistics name does not. Highlighting the Statistics folder and clicking refresh shows the new name. SSMS 14.0.17277.0

                    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 →
                    • Login Securables view not working for Availability Group permissions

                      I just discovered a bug in SSMS while working on Login permissions on Availability Groups.
                      I can give permissions on AG such as Alter, Control,Take Ownership etc. for a Login through Securables screen on Login Properties view.
                      However, after this operation Login properties->Securables window does not show these permissions.
                      When I search for securables and choose Availability Groups, they pop 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 →
                      • JSON_MODIFY is not working properly in SQL Server 2017

                        Here is my code:

                        DECLARE @info NVARCHAR(MAX) =
                        '{
                        "searchQuery":{
                        "reportType":"ReportedHcEcg"
                        },
                        "pageQuery":{
                        "pageNumber":1,
                        "pageSize":10,
                        "sortColumnName":"Urgent, UploaDateTime",
                        "sortOrder":"Desc"
                        }
                        }'

                        SET @info = JSON_MODIFY(@info, '$.searchQuery.reportType', NULL)
                        SELECT @info

                        When I try to remove the reportType field in 2nd line of code my output should be the one by removing reportType from searchQuery like below

                        {
                        "searchQuery":{

                        },
                        "pageQuery":{
                        "pageNumber":1,
                        "pageSize":10,
                        "sortColumnName":"Urgent, UploaDateTime",
                        "sortOrder":"Desc"
                        }
                        }

                        Instead of that it is like below

                        {
                        "searchQuery":{
                        "pageSize":10,
                        "sortColumnName":"Urgent, UploaDateTime",
                        "sortOrder":"Desc"
                        }
                        }

                        It just deleted first value of pageQuery and replaced it with search query. This looks strange !!!
                        I can not…

                        0 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 →
                        • grid results data hidden with no ellipses

                          When I query data, I've noticed in recent versions of SSMS that if the data goes beyond the visual outline of the cell, the value gets truncated, but sometimes the "..." is missing. This has led me multiple times now to look into the missing data (especially for fixed width columns) just to find out the rest of the value is hidden (but not showing "...".

                          My Grid Results is in Microsoft San Serif, 10pt.

                          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 →
                          • Dark theme ignored in Object Explorer

                            Dark theme created from Settings file attached.
                            All windows except object explorer have dark background.

                            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

                              3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                            • Cast As Float Issue - Bug or Feature ?

                              The CAST as FLOAT from VARCHAR fails when there is a space between the minus sign and number.

                              SELECT CAST('- 1' AS FLOAT) gives 'Error converting data type varchar to float.'

                              SELECT CAST ('- 1' AS MONEY) works OK - example of a similar CAST that behaves differently.

                              In this situation, I would prefer the CAST AS FLOAT to behave in the same manner as the CAST As MONEY

                              This issue was indentified because data is keyed in manually and some personnel inserted a space between the minus sign and number while most personnel did not insert the extra space.

                              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 →
                              • Implement all Cypher functionnalities for MATCH pattern

                                It would be very important for developpers to have all functionnalities implemented for the MATCH pattern in order to use powerfull of graphs databases.

                                OR and NOT operators are not yet implemented, and also "OPTIONAL MATCH" clause.

                                I know that graph database is new concept in SQL Server and perhaps some enhancements will be add to the future version, but we must have a roadmap if it's possible.

                                Thanks

                                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

                                  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                                • SQLAgent job failed after rename domain security group

                                  Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64)
                                  Developer Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor)

                                  Job info:
                                  job_id: 701B8D58-5D17-4A5A-ADA5-8F0AE2EA1941
                                  originating_server: VM-TESTSQL
                                  name: Test
                                  owner: domain\user_testsql

                                  User "domain\user_testsql" is a member of domain security group "domain\group_testsql"

                                  Group "domain\group_testsql" is a member of SYSADMIN sql server role

                                  After I renamed "domain\group_testsql" to "domain\group_testsql_new", job "Test" failed with error message:
                                  "The job failed. The owner (domain\user_testsql) of job Test does not have server access."

                                  Is it expected behavior or not?

                                  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 →
                                  • Duplicate fact tables in SSAS Cube Data Source View

                                    I found out that duplicate fact table is always created after you add a new measure from the same fact table in the cube data source view. So many measures you add from the same table so many duplicate tables you will get. After you save and close cube designer the images of duplicate tables changes into blank frames with the same fact table name. There is no way how to get rid of these duplicate tables. When you need to move table or arrange the design you will see the duplicates hidden under the original fact table. Such 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 →
                                    • SharePoint delivery extension for native mode

                                      We want to get rid of SSRS SharePoint integrated mode (because it is deprecated) in favor of SSRS native or most likely Power BI report server. Unfortunately in native mode it is not possible to set a SharePoint library/folder as a target of a subscription. This is a show-stopper for upgrade. Please add this delivery extension.

                                      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 →
                                      • 3 words Desepstion. Time. True. Ther are no Limet ind the femenet of eath. It Would be helpful if there was are server to snap wisdome

                                        3 words Desepstion. Time. True. Ther are no Limet ind the femenet of eath. It Would be helpful if there was are server to snap visdom, of the endLees Masse of lorste souls. intelligence is not are througt or idear.
                                        ET IS ENERGI THAT TRAY TO FINDE ARE WAY TO STABYLISE.
                                        I AM SORRY my wordblindnees, dearli the greater of godte energi.

                                        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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Unable to create event handler for custom event pipeline component event

                                          I developed a custom source pipeline component.
                                          As per Raising and Defining Events in a Data Flow Component (https://docs.microsoft.com/en-us/sql/integration-services/extending-packages-custom-objects/data-flow/raising-and-defining-events-in-a-data-flow-component), I configured a custom event:

                                          ```C#

                                          public override void RegisterEvents()
                                          {
                                          var stringType = Microsoft.SqlServer.Dts.Runtime.DtsConvert.VarTypeFromTypeCode(TypeCode.String);
                                          var intType = Microsoft.SqlServer.Dts.Runtime.DtsConvert.VarTypeFromTypeCode(TypeCode.Int32);

                                          var paramNames = new string[] {
                                          "Form Name", "Form Id", "Form Path", "Table name",
                                          "Row index",
                                          "Column name", "Target type", "Value"
                                          };

                                          var paramTypes = new UInt16[] {
                                          stringType,stringType,stringType,stringType,
                                          intType,
                                          stringType,stringType,stringType
                                          };

                                          var paramDescriptions = new string[] {
                                          "The name of the form","Form ID","Form path","Name of table in which error occurred",
                                          "Zero-based row index",
                                          "Name of column in which error…

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

                                          SQL Server

                                          Feedback and Knowledge Base