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. Am using SSMS 17.8.1. The Find/Replace functionality is lacking a quick RegEx reference button.

    The older Find/Replace SSMS functionality provided a quick button reference to commonly used Regular Expression notation. That was always a good reminder, since your RegEx notation differs from implementation in other commonly used tools like Notepad++ etc. Please put it back in.

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  2. SSRS Subscription Enumeration/Management by Date

    We would like to enumerate and manage SSRS subscriptions by date (either created date, or last modified date, or last executed date). This is an easy and generic way to partition the data when there is an extremely large number of subscriptions in the reportserver catalog.

    The ReportServer catalog scales up poorly where subscriptions are concerned, and many of the subscription operations perform table locks. In addition to database concurrency issues, the ReportServerService uses large amounts of CPU when enumerating subscriptions.

    If we could ListSubscriptions for a date range, then at least we could segregate the data and work on…

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  3. SSRS Subscription Name/Value Pairs for Search and Management

    Would like to use SSRS subscription API to attach custom indexing keys (or tags, or name/value pairs) to subscriptions. The keys could then be used in related API requests to subsequently retrieve all subscriptions that are associated with a key.

    Currently the SSRS subscription API allows you to search subscriptions only by owner and by report item.

    This is insufficient when integrating SSRS into a custom enterprise solution where there are many other factors to consider when managing large numbers of subscriptions. For example, a SQL Server developer may want to attach some organization code, or a cost center code,…

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  4. SSRS Subscription Management is Slow; Need a Faster ListSubscriptions Operation

    We use the subscription and notification API extensively. It scales up poorly. Most of the subscription-related database operations are locking entire tables (eg. Subscriptions table).

    Would like to be able to be able to enumerate subscription ID's more quickly (getting the ID's at a minimum). Please include as a SOAP or REST API method to enumerate all subscription ID's without necessarily locking up the ReportServer catalog tables. Suggest naming the method "EnumerateSubscriptionIdentifiers", and the client could follow this method call by getting additional details for any of the individual ID's without locking the entire catalog for long periods of time.

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Linux backup failed

    In SQL Server 2017 RTM CU9, I am unable to backup a large database to a mounted NFS share. I am able to backup master to the same share successfully. The large database uses in-memory tables as well.

    Microsoft SQL Server 2017 (RTM-CU9) (KB4341265) - 14.0.3030.27 (X64) Jun 29 2018 18:02:47 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Linux (Red Hat Enterprise Linux Server 7.5 (Maipo))

    This is the service status after the failed backup:
    [root@tsgcpinfdb0101 rc3.d]# systemctl status mssql-server
    ● mssql-server.service - Microsoft SQL Server Database Engine
    Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
    Active: inactive (dead)…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. SSMS shows current CU in current query editor

    Since SQL Server 2017 uses modern lifecycle and won’t have any service pack, could it be possible to show the current CU in the footer of a query window instead of RTM?

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  7. SSAS Designer showing empty phantom/duplicate tables

    Working with an SSAS multidimensional cube that was developed using SSDT 17.3, the Data Source View for the cube is showing multiple phantom tables as the data source view is changed/refreshed. This is happening when looking at the Data Source View for both cubes as well as dimensions.

    The Data Source View object itself does not show any issues, cube functionality does not appear to be affected when it is deployed and processed.

    When trying to use the "Copy Diagram from" function, Visual Studio crashes on me.

    The issue has persisted as I've upgraded to 17.4, as well as testing…

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

    We’ll send you updates on this idea

    under review  ·  14 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  8. SSRS Date Parameter Allow Nulls but date picker is enabled

    Has anyone run into this problem with SSRS where you have the date parameter set to "allow null" and the default value is set to (NULL) but when you run the report from the web page the datepicker is enabled even though the Null is checked like below. Which allows the user to pick a date even though the Null box is checked. When I run it from the SSRS server or from VS in preview mode the datepicker is correctly disabled until the check box is un-checked. Is this a bug or something else?

    I have to use the…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  9. Integrate Power Query "Web" connection type on SSAS 2017 (on-prem)

    It is absolutely necessary to have Web connection type in power query on-prem. At this time is not possible to read Excel files published SharePoint online and i think this is a very strong limitation.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  10. 4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  11. SSMS - Allow Toggling of SqlCmd Mode in Script

    I think it would be beneficial to have the ability to toggle SqlCmd mode inside a query window / script.

    My end goal is to attach a script to an email that someone can open and execute without doing anything else (script contains :CONNECT SqlCmd command to execute against the correct connection).

    Right now we currently have to open the file and then toggle SqlCmd mode, which isn't terrible, but could be better.

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  12. VS2017 and SSDT Graph table with custom columnstore index wrong publish script

    VS 15.7.4
    SSDT 15.1.61804.210

    We have a SQL Server Database project with a Graph table and we created a Clusted Columnstore Index in it as follow:

    CREATE CLUSTERED COLUMNSTORE INDEX [IXCCSindex_name]

    ON [schema_name].[table_name];
    

    Trying to publish it from VS, wrong t-sql script is created:

    CREATE CLUSTERED INDEX [IXCCSindex_name]

    ON [schema_name].[table_name] ([$edge_id]);
    

    CREATE CLUSTERED COLUMNSTORE INDEX [IXCCSindex_name]

    ON [schema_name].[table_name] WITH (DROP_EXISTING = ON);
    

    The first CREATE INDEX fails, to successfully publish the index we had to remove square brackets specifying column name:

    CREATE CLUSTERED INDEX [IXCCSindex_name]

    ON [schema_name].[table_name] ($edge_id);
    

    CREATE CLUSTERED COLUMNSTORE INDEX…

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  13. VS2017 and SSDT publishing Graph Database objects created before schemas

    VS 15.7.4
    SSDT 15.1.61804.210

    We created a new SQL Server Database Project in VS2017 and imported a database that uses Graph DB features.

    Trying to publish the project we receive and error indicating one schema is missing (a custom schema that contains graph database objects).
    We dug into publish t-sql script and we found that CREATE TABLE statements for graph db edge tables were placed before CREATE SCHEMA statements, therefore, publish won’t ever complete successfully.

    To complete deploy we had to move CREATE SCHEMA statements above and run the script manually.

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

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. VS2017 and SSDT doesn't import every Graph Database Objects

    VS 15.7.4
    SSDT 15.1.61804.210

    We created a new SQL Server Database Project in VS2017 and imported a database that use Graph DB features.
    We found that not every edge tables were impoted in project, it seems only tables with custom columns were imported.
    Edges with graph metadata columns only are ignored.

    You can see an example in the screenshot.

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  15. SSAS2016(SP2) - False error message when parsing a DAX measure containing INTERSECT()

    This was seen with intersect but will probably occur with similar set based functions when comparing values to a literal in the form:

    INTERSECT(
    VALUES(MyTable[StringColumn]),
    UNION(ROW("TestStrCol", "Value1"), ROW("TestStrCol", "Value2"))
    )

    This generates an error message along the lines of "Intersect cannot compare data types of string and variant"

    The error is seen as genuine by SSDT and prevents a deployment. However, building a model using the .NET Tabular Object Mode, the model can be deployed and the INTERSECT() function works as expected.

    There is enough information in the DAX code to infer that the columns in the ROW() statement are…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  16. Fix intellisense in OVER clause (SSMS)

    Intellisense in SSMS is great, but it appears that it doesn't work inside an OVER clause.

    Could this be fixed?

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  17. SSMS (a/o 17.7): String was not recognized as a valid DateTime. (mscorlib)

    When writing a new SQL Agent job, and entering a date/time into a datetime parameter, the job failed to execute, throwing the error:

    String was not recognized as a valid DateTime. (mscorlib)

    When trying to retrieve the properties pane of the job step that failed in SSMS, it errors out and the job details window closes with the same error.

    Local regional settings was set to Canada (which has a default DD/MM/YYYY format), which seems to also be the same format used by SSMS when writing the job details. SQL Server and SSMS cannot re-interpret dates such as June 26…

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  18. SSMS slow when right-clicking an index for a table

    Sometimes SSMS is very slow to open windows/menu when connected to Azure databases. Can you fix that?

    All data provided by SSMS can also be obtained via system management views using a simple SELECT statement. SSMS needs to pull a lot of data from SQL Server to build the GUI and thus can be slow under certain circumstances. Another option that provides a little better experience is the new SQL Operation Studio.

    https://docs.microsoft.com/en-us/sql/sql-operations-studio/download

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  19. Bug in Merge Replication snapshot agent with FILESTREAM and UNIQUE constraints

    The snapshot agent fails when running on a publication that contains a merge article with FILESTREAM columns and a UNIQUE constraint.
    The full description of the bug with repro script and workaround can be found here: https://spaghettidba.com/2018/07/03/a-bug-in-merge-replication-with-filestream-data/

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  20. DATETRUNC(datepart,datevalue) instead of dateadd-datediff

    The generally accepted way to truncate some part of a datetime is:
    DATEADD(datepart,0,DATEDIFF(datepart,0,datevalue))
    To save us from much typing, and probalby a good amount of CPU due to a good implementation, I propose we create a new function exactly for that:
    DATETRUNC(datepart,datevalue)
    which rids the datevalue of any component LESS than datepart (ie, truncates it to the dateart level)

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base