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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Version 18.4 Remain problem when switch Query tab content is not refresh

    Version 18.4 Remain problem when switch Query tab content is not refresh

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. SSMS 18.4 looses filter from index when saving table

    With the table design window:
    Created a table with some fields and saved it.
    Run query to add a filtered unique index in order to prevent duplicates in some values.
    Added a field and FK to another table's ID and save the changes. The filter is removed from the index.

    If the table has data it fails complaining about duplicates on the unique index.

    If I generate a script of the changes it has everything but the filter on that field's index.

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. SSMS, table designer, no intellisense on dataType

    When creating a new table using the graphical designer, I used to be able to be able to type letters and it would select the datatype that matches the closest (effectively dropping me down to the listItem). Additionally, after I name a column and I press the tab key to get to the dataType column, an audio alert is triggered as if the tab key created some error.

    This behavior started happening in 18.3.1, I have rolled back to 18.2 to get the desired behavior.

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. Unable to turn off presentation mode

    In SSMS 18.3.1 and 18.4 the quicklaunch tasks PresentEdit and PresentOn do exist however PresentOff does not. Please can this be added?

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  5. sql server 2019 sys.dm_db_file_space_usage not correct !

    DMV sys.dmdbfilespaceusage shows incorrect data in column DFSU.allocatedextentpage_count
    It shows zero ( whilst the database holds for more than 4GB of regular table data )

    I have rebuilt all tables and indexes as well as updated spaceusage.

    DBLVL = 150 ( also testd with 140 )

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. Functions: return strings in else if are cut depending on other string returns

    Hello,

    after an upgrade to the newest docker version of SQL Server 19 (mcr.microsoft.com/mssql/server:2019-GA-ubuntu-16.04), previously we used SQL Server 2017 (mcr.microsoft.com/mssql/server:2017-latest), a function does not return the correct value anymore.

    Here is a simple Version of the function, which can reproduce the problem:

    ALTER FUNCTION [dbo].[testFunction] (@pVar nvarchar(50)) RETURNS nvarchar(50)
    AS
    BEGIN
    IF @pVar = N'a' begin

       return(N'a123456789');
    

    end ELSE IF @pVar = N'b' begin

       return(N'b12');
    

    end

    return(@pVar);
    END

    If you call following function with "SELECT [dbo].testFunction" the return is "a12", but i would expect "a123456789".

    It seems that the cut is dependent on the following return value,…

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  7. nosplash

    Trying to run SSMS 18.4 with -nosplash - it doesn't work

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  8. Fix debug so it correctly highlights the right row when stepping through code

    Fix debug so it correctly highlights the right row

    This bug is very annoying. I spent hours trying to figure out what causes it. I attached a test script. Try altering the length of the comments and you should be able to see the bug appear and disappear as you step through the code. Good luck

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  9. Fix debug so it correctly highlights the right row when stepping through code

    Fix debug so it correctly highlights the right row

    This bug is very annoying. I spent hours trying to figure out what causes it. I attached a test script. Try altering the length of the comments and you should be able to see the bug appear and disappear as you step through the code. Good luck

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  10. SQL Server 2019 Configuration Manager mistranslation

    In the Japanese version of Configuration Manager for SQL Server 2019, State is mistranslated as "都道府県".

    "都道府県" is the word used to represent an address.
    The translation of State is correct for "状態".
    (The translation is correct until SQL Server 2017.)

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  11. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. Install SQL Server 2017 and create a database on Red Hat

    Hi Team,

    I installed sqlserver on Linux and noticed that somehow the setup file looking for 'C:\binn\secforwarder.dll' and error ed out. but it went well and installation got successful here i attached screen shot for reference

    Thanks you

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  13. SSMS removing comments from my stored procedures

    SSMS 18.3.1 is removing all of my comments outside of begin statements when I create a store procedure.

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. Microsoft.Data.Tools.Schema.SqlTasks.targets magical behavior with SSDTPath variable

    In a SqlProj when compiling with MS Build Tools, if I override the SSDTPath parameter (from msbuild using /p:SSDTPath or within the sqlproj itself with <ssdtpath>mypath<ssdtpath>, the SSDT path is concatenated into the Import path even if I never reference it explicitly.

    So SSDTPath is concatenated onto the location of the SqlTasks.Targets file, producing a useless path to look for other files.

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  15. Unable to deploy SSIS packages from Visual Studio 2017 (15.9.17)

    When attempting to connect to a server the deployment wizard returns the following error:

    The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) (mscorlib)

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  16. SSMS 18.3.1 IntelliSense does not recognize MOVE TO as a valid option for DROP INDEX

    Management Studio, with IntelliSense enabled, does not seem to know that "MOVE TO" is a valid option for the DROP INDEX statement. "MOVE" is underlined in red with a tool tip of:

    Incorrect syntax near 'MOVE'.

    Yet, it's clearly not invalid since it does work :-).

    I have observed this behavior in SSMS 18.3 and 18.3.1.

    Not that this should matter, but I have tested with both SQL Server 2017 CU15-GDR and 2019 RC1.

    Below is a simple repro script to show that this option truly is valid:


    USE [tempdb];

    CREATE TABLE [dbo].[MoveTo]
    (
    [MoveToID] INT NOT NULL,
    [SomethingElse] VARCHAR(50)…

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  17. Make studio sharp again. Text is blurry and gray.

    It is hard to work with this Studio version. Text is blurry and low contrast.

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  18. SQL2019 and Common Criteria Compliance [Advanced Option]

    With the release of SQL2019, I was looking at the new Advanced Options for the instance. One that is not new is the [Common Criteria Compliance Enabled] setting. This setting is documented here [https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/common-criteria-compliance-enabled-server-configuration-option?view=sql-server-ver15] but the link it has for the script required to implement this once the setting has been turned on appears to only refer up to SQL2016/SP1.

    Where is the information/script for SQL2017 or SQL2019, or indeed anything AFTER SQL2016/SP1? In fact, I find the instructions in the referenced document to be incomplete and difficult to follow. As this appears to be specific version impacted,…

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  19. SQL Server Database on Linux running even when physical data file from disk is deleted

    Hello MS Team,

    While testing the SQL Server 2019 in Linux ubuntu, I created a database and tried to check how SQL Server locks the physical data file from getting deleted. I was surprised to see that I was able to delete the User(.mdf) file from the path in which SQL Server service was running.

    Furthermore, till I restarted the SQL Service it allowed me to run the query and make the transaction on the same database for which I deleted the data file (.mdf).

    I was able to create table , take backup of database which has missing physical…

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  20. UI with 4K monitor

    Hi Microsoft! I'm writing to reccomending to fix the UI. Try to use SSMS with a 4K monitor with 3840x2160 @ 250% of scaling, is a nightmare.

    Please, please please FIX this.
    I'm using the last one version, 18.4, but the problems are still present

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

    We’ll send you updates on this idea

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

SQL Server

Categories

Feedback and Knowledge Base