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. Procedure shutdown server

    Wrong procedure shutdown SQL server 2014/2016, if run it twice.

    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 →
  2. setup blocked

    "Something has blocked setup from continuing."
    "Windows 8 is not supported. Please upgrade your operating system to continue."
    I am running Windows 10 Pro 64-bit, this error makes no sense to me when upgrading from 18.9.1 to 18.9.2, log file attached...

    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 →
  3. Query editor not allowing me enter carriage return, copy paste etc whats wrong

    Cannot enter text into query panel. Can only type on one line but delete, carriage return, ctrl v, ctry c dont work.

    Please help

    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 →
  4. SSMS: Scripting server property change generates "@configvalue" param of sp_configure as string instead of number

    In SSMS (tried on both 18.8 and 18.9.1), in Server Properties -> Advanced, I change a setting and click "Script" instead of "OK" and a new query editor tab is opened containing the following T-SQL:

    EXEC sys.sp_configure N'cost threshold for parallelism', N'20'
    GO
    

    Notice how the value of 20 is scripted out as an NVARCHAR string literal instead of as a number. It should be as follows:

    EXEC sys.sp_configure N'cost threshold for parallelism', 20;
    GO
    

    Take care,
    Solomon...
    https://SqlQuantumLift.com/
    https://SqlQuantumLeap.com/
    https://SQLsharp.com/

    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 →
  5. 100% CPU usage when an in-memory OLTP database is in recovery state and recovery takes much time in SQL Server 2019

    Hi Team,

    We are facing the 100% CPU usage issue when an in-memory OLTP database is in recovery state in SQL server 2019 as like 2014 and 2017 versions. Also DB recovery takes much time. Are we going to release any fix with CU or still do we need to use trace flag 9944 for workaround?.

    Thanks.

    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 →
  6. Identity increment is jumping in SQL Server database please fix it.. most trouble it.. important case..

    Identity increment is jumping in SQL Server database please fix it.. most trouble it.. important case..

    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 →
  7. avoid truncate for data extraction from DACPAC graph tables data - truncate vs edge constraint

    it is possible to extract DACPAC containing table data. This works also for graph tables containing edge constraints. But it is not possible to restore the data from the DACPAC because the restore process uses truncate, and this is not valid on tables with edge constraints.

    How to reproduce:
    - create graph tables (nodes and edges)
    - define edge constraints
    - fill the tables with data
    - extract to a dacpac using the /Action:Extract and /p:ExtractAllTableData=TRUE
    - try to restore dacpac with data using /Action:Publish
    - see the errors

    Updating database (Failed)
    *** Could not deploy package.
    Warning SQL72038: The…

    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 →
  8. An error converting a value in an INSERT statement to float always cancels the current transaction, as opposed to other errors which do not

    Given the following table:
    CREATE TABLE [dbo].[tIdValue](
    [Id] [nchar](10) NOT NULL,
    [DefaultValue] [float] NOT NULL,
    CONSTRAINT [PK
    t_IdValue] PRIMARY KEY CLUSTERED ( [Id] ASC )) ON [PRIMARY]
    GO

    The 3rd INSERT statement is reached despite the 2nd INSERT statements failing on duplicate primary key, that is, the error in the 2nd statement doesn't cancel the transaction:

    -- Initial row with ID '02345'
    INSERT INTO dbo.t_IdValue (Id, DefaultValue) VALUES ('02345', 200.0);

    BEGIN TRANSACTION;
    -- This should throw an error since it's a duplicate primary key
    INSERT INTO dbo.tIdValue (Id, DefaultValue) VALUES ('02345', 123.0);
    -- This should still run since

    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. Invalid class string when opening maintenance plans in SSMS 18.9.1

    Possible bug:
    When opening a maintenance plan in SSMS 18.9.1 from a remote server, I get an "Invalid class string" error.
    Also states "Value cannot be null.
    Parameter name: component (System.Design)"

    If I run 18.8 on the server directly or remotely, I have no issue opening the plans.

    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 →
  10. suboptimal execution plan when column consists only of NULLs

    The last query in attached script genereates bad plan. Instead of index seek it ends up doing table scan. Fixes/ workarounds include:
    - remove the B1 = @p1 part.
    - run query with literals. Suprisingly adding OPTION(RECOMPILE) doesn't fix the query
    - add OPTION(OPTIMIZE FOR UNKNOWN).
    - Remove the B1 column from the index.

    Most surprisingly, if I compare histogram for index with column B1 and without they seem identical. Yet provide wildly different estimates

    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 →
  11. bug starting from sql 2017, multistatement function kills connection in case of timeout

    timeout multistatement function kills connection in case of timeout

    problem with sql 2019 (works ok on sql 2014)

    create database test1
    go
    use test1
    go
    set nocount on
    go
    create table OneBigTable1 (a int, b int)
    go
    declare @a int = 0 while @a < 10000 begin insert into OneBigTable1 select @a, @a & 255;set @a = @a + 1 end
    go
    SET ANSINULLS ON
    GO
    SET QUOTED
    IDENTIFIER ON
    GO
    CREATE or alter FUNCTION dbo.testkill03()
    RETURNS @RET TABLE (
    A int
    )
    BEGIN

    declare @A int;
    select @A = count(1) from OneBigTable1 b1
    inner loop join
    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 →
  12. found one bug

    found this bug today. the pop up message is unable to close on ssms.

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

    Invalid operation. The connection is closed. (System.Data)


    Program Location:

    at System.Data.SqlClient.SqlConnection.GetOpenConnection()
    at System.Data.SqlClient.SqlConnection.get_ServerVersion()
    at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.SqlScriptEditorControl.OnFillServerDBs(Object sender, CmdWithExtraParamsEventArgs a)

    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 →
  13. Bug report: SSMS crashes when change of relationship between tables is made in Diagram

    When one opens properties for a relation between two tables in a diagram and changes one of the tables, SSMS crashes.

    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 →
  14. Sql server mangment studio v18.9.1 crash when opening database diagram

    SQL Server Management Studio 15.0.18384.0
    SQL Server Management Objects (SMO) 16.100.46367.54
    Microsoft Analysis Services Client Tools 15.0.19535.0
    Microsoft Data Access Components (MDAC) 10.0.19041.1
    Microsoft MSXML 3.0 6.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 10.0.19042

    Do you have a solution for that?

    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. SSAS tabular process full mistakenly reports error "Cannot order by ..."

    Our tabular database contains ~3e10 rows in the fact table.
    A ProcessFull sometimes reports mistakenly the error "Cannot order ''[] by [] because at least one value in [] has multiple distinct values in [].", without any names in the brackets.
    We verified all columns with "sort by column" property set to another column (select * from $SYSTEM.TMSCHEMA_COLUMNS where SortByColumnID>0) and all these column return a single value:

    select v.ColumnName, count(distinct v.SortColumnName)
    from olap.vViewName as v
    group by v.ColumnName
    having count(distinct v.SortColumnName) > 1

    Sometimes, without any changes to the underlying data, the process full finishes without any errors.

    So…

    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 →
  16. Subscription with multiple days in a month in german language

    Subscription with multiple days in a month

    Screens an Problem description:
    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d501f734-64d2-4d55-a400-b3f0184ba7b1/subscription-with-multiple-days-in-a-month?forum=sqlreportingservices

    Subscription with multiple Month as Range will not work in german language.

    German-Language use comma as decimal seperator. SSRS only accepts comma but all Browsers missinterpret the String e.g "1,4" as decimal.

    Please Fix the Bug.

    Ideas:
    *Format Textbox as Text
    *Create alternative Seperator like ";"

    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 →
  17. 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 →
  18. SQL Server LocalDB and Windows Sandbox

    Bug:
    SQL Server LocalDB (and Express) do not start in Windows Sandbox.

    Steps to reproduce:
    Launch - Windows Sandbox

    Download & Install - Microsoft Visual C++ 2015-2019 Redistributable
    https://aka.ms/vs/16/release/vc_redist.x64.exe

    Download - SQL Server 2019 Express
    https://go.microsoft.com/fwlink/?LinkID=866658

    Download Media -> LocalDB -> Download
    Install LocalDB

    Use Command Prompt/Powershell to start the default service which fails

    Details
    While the root cause of this issue is still unknown to me, my testing has showed that this is specifically an issue with Windows Sandbox/SQL Server. The above steps work fine on a new VM with Hyper-V as well as a fresh installation of Windows…

    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 →
  19. Error ocurres only the first time query is run (Aggregates on the right side...)

    A little bit of background story:
    After migrating our databases to SQL 2019 we've started to notice randomly ocurring "Aggregates on the right side of an APPLY cannot reference columns from the left side." error.
    After some digging we've found some old scalar function that is using MIN function in a way I can't really find a reason for it to be used in this manner, however the facts are:
    1. UDF is working 100% on SQL Server versions prior to 2019.
    2. Error ocurres ONLY on the first run. Consecutive runs give no error.
    3. Result of the scalar…

    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. SSMS crash when local computer doesn't have access to azure storage account

    This is observed while carrying out database restore operation. If local computer's IP is not allowed to access azure storage and we try to restore a backup from that azure storage, SSMS crashes as soon as we select a blob from such azure storage account.

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

SQL Server

Categories

Feedback and Knowledge Base