Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

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 Microsoft Q&A or Stack Overflow

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Incorrect Expensive Queries link on Performance Dashboard in 18.6 [Korean]

    The links except for [By CPU] in the expensive queries on Performance Dashboard don’t work correctly in 18.6 [Korean].

    The cause of this problem looks that the @OrderByCriteria value is NULL in the parameter below. When I click the [By Logical Reads] link, @OrderByCriteria should be N'Logical Reads', not NULL. Please review the links.


    ,@params=N'@OrderByCriteria NVarChar(max)',@OrderByCriteria=NULL

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. SSMS 18.6 Database Diagrams - Add Table dialog gets stuck

    The add tables dialog/pop-up in database diagrams does not immediately take focus and can get stuck, causing SSMS to hang.

    If a current diagram is opening, this causes a "loading" screen for all tables.
    If a new diagram is created and the add table dialog stays in the background, the properties pane does not load for objects, such as the relationships.

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. Azure SQL Edge - DATE_BUCKET can't be used in computed column

    When using DATE_BUCKET directly in a computed column definition, subsequent queries to the table will fail with a syntax error. Moving the DATE_BUCKET call to a user-defined function and invoking that in the computed column definition works properly.

    ALTER TABLE Table ADD Bucket AS DATE_BUCKET(day, 1, SourceDate, CAST('1900-01-01' AS datetime2))
    SELECT * FROM Table
    [S0001][1023] Invalid parameter 1 specified for Date_Bucket.
    
    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. Line breaks cause errors/unexpected behaviour sqlcmd on Linux

    When using sqlcmd on Linux, line breaks are not parsed correctly. For example, if you run the following:

    1> SELECT 'hello';
    2>
    3>
    4>
    5> GO

    The expected result would be:


    hello

    (1 rows affected)

    Instead you get:


    hello

    (1 rows affected)


    hello

    (1 rows affected)


    hello

    (1 rows affected)


    hello

    (1 rows affected)

    If you run the following:

    1> SELECT 'hello',
    2> 'goodbye';
    3> GO

    you would expect:


    hello goodbye

    (1 rows affected)

    Instead you get:

    Msg 102, Level 15, State 1, Server ptah, Line 3
    Incorrect syntax near 'goodbye'.

    The screenshots also demonstrate the behaviour different for Linux…

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  5. SSMS 18.6 MEF "Component threw an exception" Error

    I installed SSMS 18.6 this morning (on Windows 6.3 (Build 9600)).

    Around lunch time it threw this dialog box:

    Microsoft SQL Server Management Studio

    An exception has been encountered. This may be caused by an extension.

    You can get more information by examining the file 'C:\Users\djameson\AppData\Roaming\Microsoft\AppEnv\15.0\ActivityLog.xml'.

    OK

    in the XML file, the latest entries are:
    <entry>
    <record>503</record>
    <time>2020/07/29 20:46:15.995</time>
    <type>Error</type>
    <source>Microsoft.VisualStudio.ComponentModelHost.VsShellComponentModelHost</source>
    <description>A MEF Component threw an exception at runtime: System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Extensions\extensions.configurationchanged'. at System.IO.Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. SSMS v18.5.1 Object error when using Import Flat File

    When importing a file via the Import Flat File an Object Error is raised if the file is open in another application. The error does not mention that the file is opened or in use.

    On Screen Error:

    TITLE: Microsoft SQL Server Management Studio

    Object reference not set to an instance of an object. (Microsoft.SqlServer.Prose.Import)


    BUTTONS:

    OK

    Stack Trace

    Object reference not set to an instance of an object. (Microsoft.SqlServer.Prose.Import)


    Program Location:

    at Microsoft.SqlServer.Prose.Import.BcpProcess.set_UseSimpleDataType(Boolean value)
    at Microsoft.SqlServer.Import.Wizard.PreviewPageController.OnActivate()
    at Microsoft.SqlServer.Management.TaskForms.SqlWizardPageController.OnFirstActivate()
    at Microsoft.SqlServer.Management.TaskForms.SqlWizardPageController.Microsoft.SqlServer.Management.TaskForms.ISqlWizardPageController.SetActive()
    at Microsoft.SqlServer.Management.TaskForms.ControllerPage.OnSetActive()
    at Microsoft.SqlServer.Management.SqlWizardFramework.WizardFramework.ActivatePage(NavigationItem item, NavigationDirection direction)
    at Microsoft.SqlServer.Management.SqlWizardFramework.WizardFramework.ActivatePage(Page page, NavigationDirection direction)
    at Microsoft.SqlServer.Management.SqlWizardFramework.WizardFramework.GoToPage(Page page)
    at Microsoft.SqlServer.Management.SqlWizardFramework.WizardFramework.OnNext()
    at Microsoft.SqlServer.Management.SqlWizardFramework.WizardButtonsPanel.OnNext(Object…

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  7. Inlined scalar UDF returns incorrect result for scalar aggregate in some cases

    The code below returns incorrect results (23 not 100).

    The execution plan has a nested ANY(SUM(Number)) which appears to return the value at the first point SUM(Number) is not null

    CREATE TABLE dbo.Numbers(Number INT PRIMARY KEY);    
    INSERT INTO dbo.Numbers VALUES (23), (27), (50);
    CREATE OR ALTER FUNCTION [dbo].[fnDemo]()
    RETURNS int
    AS
    BEGIN
    DECLARE @Result as int, @Zero as int = 0
    SELECT @Result = SUM(Number + @Zero) from dbo.Numbers 
    RETURN @Result
    END    
    GO    
    Select dbo.fnDemo()
    

    (Found here https://stackoverflow.com/q/62311952/73226)

    And the following produces a stack dump

    CREATE OR ALTER FUNCTION [dbo].[fnDemo]()
    RETURNS int
    AS
    BEGIN
    DECLARE @Zero INT = 0
    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  8. "An item with the same key has already been added."

    SSMS crashes when trying to set CPU affinity on a machine with 'lots' of cores.

    Program Location:

    at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
    at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
    at Microsoft.SqlServer.Management.Smo.NumaNodeCollection.get_NumaCollectionFromId()
    at Microsoft.SqlServer.Management.Smo.NumaNodeCollection.AddNumaInDdl(StringBuilder stringBuilder)
    at Microsoft.SqlServer.Management.Smo.AffinityInfo.DoAlter(ScriptingPreferences sp)
    at Microsoft.SqlServer.Management.Smo.AffinityInfoBase.Alter()

    It shows NumaNode0 twice, and NumaNode1 once.
    CPU 18-35 on NumaNode0 (the first one)
    CPU 0-17 on NumaNode0 (the second one)
    CPU 64-99 on NumaNode 1

    Trace flag 174, 3226, 4199, 8002, 9481 are enabled.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  9. Error in SSMS 18.5 setting baselines in Vulnerability Assessment

    When running Vulnerability Assessments in SSMS 18.5, then trying to set a result as baseline, we receive the following error. This occurs on multiple machines against a SQL 2016 database. It works correctly in SSMS 17.9

    TITLE: Microsoft SQL Server Management Studio

    VA1095 - Failed to set baseline. (Microsoft.SqlServer.Management.ThreatDetection)


    ADDITIONAL INFORMATION:

    One or more errors occurred. (mscorlib)


    Could not load file or assembly 'Microsoft.Azure.Storage.Common, Version=11.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. (DataSec.VA.Core.Baseline)


    BUTTONS:

    OK

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  10. Bug in SQL Server 2019 inlining

    I have this scalar function:
    CREATE FUNCTION [dbo].[fConvert]
    (
    @SqlValue SQLVARIANT
    )
    RETURNS NVARCHAR(4000)
    AS
    BEGIN
    DECLARE @Result NVARCHAR(4000);
    DECLARE @SqlType NVARCHAR(100) = CAST(SQL
    VARIANT_PROPERTY(@SqlValue, 'BaseType') AS NVARCHAR(100));

    SELECT @Result =
        CASE 
        WHEN @SqlType = 'uniqueidentifier' THEN LOWER(CAST(@SqlValue AS NVARCHAR(4000)))
        WHEN @SqlType = 'date' THEN CONVERT(VARCHAR, CAST(@SqlValue AS DATE), 112)
        ELSE 'null' END;
    
    RETURN @Result;
    

    END;

    When I call this function like this:
    SELECT dbo.fConvert(CAST('5E15502B-30C9-4370-87D3-FEC505837814' AS UNIQUEIDENTIFIER))
    I get an error:
    Msg 529, Level 16, State 3, Line 4
    Explicit conversion from data type uniqueidentifier to date is not allowed.

    When I call it like this:
    DECLARE @guid UNIQUEIDENTIFIER…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  11. Replication Monitor no longer automatically connects to publisher in 18.5

    Since upgrading to SSMS 18.5, replication monitor no longer automatically connects to the publisher. I have to manually go into the publisher properties every time and manually connect. SQL Server 2016.

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. Please bring back the Databases Filter option in SSMS 18

    The ability to right-click on the Databases folder in the tree and pick "Filter" was in SSMS 17 but is no longer available in SSMS 18.4 (as of this post). Why was that feature removed? Can you please bring it back?

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    To be fair, I have no recollection of removing it from SSMS 18… and I just tried with SSMS 18.5.1 and I can filter databases and tables just fine.

    Is the menu item missing for you? Or the functionality missing/broken? It is not immediately clear what the attached pictures refer to.

    Please, enter another UV item if you have more details.

    Thanks,
    -Matteo

  13. [CONFIRMED] [BUG]: SSMS 18.2 = OK, 18.3.1 = BUG

    It turns out than in Windows 10 LTSC (haven't tried other versions) in SSMS 18.3.1 onwards up to 18.5, in the table designer, when you are creating a column and switch cell using the TAB key, Windows's beep sound effect plays.

    I can confirm this does NOT happen in SSMS 18.2, which is a bummer because I really want to stay on the edge and use the latest & greatest versions.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. SSMS 18.5 - Database upgrade session wizard and databases with a 'dot' in the name

    When I try to use the 'New Database Upgrade Session' wizard on a database containing a dot in the name (for example: my.database), then the error below is thrown. Even when the user has db_owner permissions on the specific database.

    ===================================

    User does not have enough permissions. (Microsoft.SqlServer.QueryTuningAssistant.QueryStorage)


    Program Location:

    at Microsoft.SqlServer.QueryTuning.Helpers.QueryTuningManager.CreateActiveSession(String compatLevel, String workLoadDays)
    at Microsoft.SqlServer.QueryTuning.Wizard.QueryTuningWizardController.QueryTuningSetupResultPageController.CommitChanges()
    at Microsoft.SqlServer.Management.TaskForms.SqlWizardPageController.Microsoft.SqlServer.Management.TaskForms.ISqlWizardPageController.CommitChanges()
    at Microsoft.SqlServer.Management.TaskForms.ControllerPage.OnSave()
    at Microsoft.SqlServer.Management.SqlWizardFramework.Page.OnWizardAction()
    at Microsoft.SqlServer.Management.SqlWizardFramework.WizardFramework.PagesConfirmCommit()
    at Microsoft.SqlServer.Management.SqlWizardFramework.WizardFramework.OnCommitJob(Object sender, EventArgs e)
    at Microsoft.SqlServer.Management.SqlWizardFramework.ConsoleJobsService.RunJob(IComponent jobOwner, EventHandler1 jobMethod, EventHandler1 errorHandler, Object[] arguments)
    at Microsoft.SqlServer.Management.SqlWizardFramework.ConsoleJobsService.RunJob(EventHandler`1 jobMethod, Object[] arguments)
    at Microsoft.SqlServer.Management.SqlWizardFramework.WizardFramework.OnCommit()
    at Microsoft.SqlServer.Management.SqlWizardFramework.WizardButtonsPanel.OnCommit(Object sender, EventArgs e)
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnClick(EventArgs e)
    at…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  15. SSMS 18.5 forgets remembered passwords again

    This seemed to be working ok in 18.4 i hadn't had this issue since upgrading, but now in 18.5 it instantly started occurring again. Immediately after installing 18.5 in fact, the existing stored credentials showed the password had been forgotten again, even if i re-enter it and tick 'Remember', it'll be forgotten again if, for instance, my connection is dropped and i need to reconnect to the server.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  16. SSMS 15.0.18330.0 import bacpac failed

    With the latest SSMS 15.0.18330.0 I'm unable to restore an Azure SQL Bacpac, error is triggered when "Importing datase".

    If I try to get more details (clicking on the "Error" link), I get an NRE :

    TITLE: Microsoft SQL Server Management Studio

    Object reference not set to an instance of an object. (Microsoft.Data.Tools.Schema.Sql)

    at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentPlanGenerator.DeploymentScriptDomGenerator.GenerateFragment(Int32 operation, IModelElement element)
    at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentPlanGenerator.DeploymentScriptDomGenerator.GenerateSteps(Int32 operation, IModelElement element)
    at Microsoft.Data.Tools.Schema.Sql.Deployment.OrderedStepGenerator.Add(DeploymentScriptDomGenerator scriptDom, IModelElement element, Int32 operation)
    at Microsoft.Data.Tools.Schema.Sql.Deployment.Analyzers.PlanMediator.BuildDependencyOrderedSteps(Int32 operation, List1 classOrder, List1 operationOrder, Dictionary2 changes, Boolean preserveGraphs, Dictionary2& relating, Dictionary2& related)
    at Microsoft.Data.Tools.Schema.Sql.Deployment.Analyzers.PlanMediator.BuildOperations()
    at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentPlanGenerator.OnGeneratePlan()
    at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentPlanGenerator.GeneratePlan(List
    1 drops)
    at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.BuildPlan()…

    13 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  17. SSMS: Freeze Column Headers When Scrolling

    It would be nice if we could "freeze" column headers in SSMS like in Excel, so it's a little easier to remember where we are in larger result sets, and get helpful screenshots of data.

    38 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. query designer - sort type selection with keyboard

    Query designer

    SSMS 17: in query designer, if you went to Sort Type column and tried to select a Sort type using the keyboard, you just pressed "d" and the respective combobox automatically selected "Descending" from the list.

    SSMS 18: this behavior has now changed. You have to either type the entire word ("Descending") or just select it using the mouse, which actually renders the keyboard useless for such a task.

    Please fix this greatly annoying thing to work as in SSMS17.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  19. SSMS 18.4 Saved connections reset when changing language

    Hi, I switched the language from "System (German)" to "English" and all previously saved connections in the combobox "server name" are gone.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  20. SQL Server 2019 CU3 CE 150 Cannot continue the execution because the session is in the kill state

    We get following error after testing our code on SQL Server 2019 CU3 in compatibility level 150. Error doesn't happen in 140.

    Error:
    Msg 596, Level 21, State 1, Line 0
    Cannot continue the execution because the session is in the kill state.
    Msg 0, Level 20, State 0, Line 0
    A severe error occurred on the current command. The results, if any, should be discarded.

    Seems like a combination of using a function that SQL sees as inlineable and group by with rollup.

    See attached file to replicate this issue.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base