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. SSMS Overwritten credentials 18.4 (v15.0.18206.0)

    When having multiple server names (using SQL Server Authentication) that can have same login but different passwords a pacredentials are not stored "per instance" password it is being stored "per login" and overwritten each time when you try to login to different server with different password. Meaning you can log in (without enterning the password) to only lates instance that have a particular login.

    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. Latest version of SSMS 18.4 still installs to Program Files (x86) on 64 bit windows 10 Version 10.0.18362 Build 18362

    Every time a new SSMS comes out I uninstall the older version and then restart and try to run the install of the new one hoping it will install into Program Files as a 64 bit application but alas with version 18.4 still installs to Program Files (x86). Documentation says for my version of windows 10 it should be 64 bit compatible. Am I missing something? I don't see a separate install for 64 bit.

    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. EXCEPTION_ACCESS_VIOLATION when returning inlined UDF with UserDataAccess from stored procedure

    SQL Server version: Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
    Script to reproduce erorr:

    USE tempdb;
    GO

    DROP TABLE IF EXISTS dbo.test_tbl;
    GO
    CREATE TABLE dbo.test_tbl(val int NOT NULL);
    GO

    INSERT INTO dbo.test_tbl(val) VALUES (0);
    GO

    CREATE OR ALTER FUNCTION dbo.test_fn(@val int)
    RETURNS INT
    WITH SCHEMABINDING
    AS
    BEGIN
    IF EXISTS(SELECT val FROM dbo.test_tbl) -- UserDataAccess
    RETURN @val;
    RETURN 1;
    END
    GO

    CREATE OR ALTER PROCEDURE dbo.test_proc(@val int)
    AS
    RETURN dbo.test_fn(@val);
    GO

    EXEC dbo.test_proc @val = 10;
    GO

    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 →
  4. Management Studio Tabs Don't Refresh

    In the latest version of Management Studio, the tabs don't refresh when you toggle between them. The contents of the previous tab are still displayed. You have to resize the window to force a refresh.
    SQL Server Management Studio 15.0.18206.0
    Microsoft Analysis Services Client Tools 15.0.1567.0
    Microsoft Data Access Components (MDAC) 10.0.18362.1
    Microsoft MSXML 3.0 4.0 6.0
    Microsoft Internet Explorer 9.11.18362.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 10.0.18362

    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 →
  5. Bad Cardinalities for 'between' values on Histograms depending on predicate value length

    Reproduces in SQL Server 2017

    SET NOCOUNT ON
    DROP TABLE DK;
    CREATE TABLE DK (K nvarchar(5) not null);
    GO
    INSERT INTO DK VALUES('AAAAA');
    INSERT INTO DK VALUES('B');
    INSERT INTO DK VALUES('CCCCC');
    INSERT INTO DK VALUES('DDDDD');
    INSERT INTO DK VALUES('EE');
    INSERT INTO DK VALUES('F');
    GO 8

    SELECT * FROM DK WHERE K = 'AAAAX' OPTION (RECOMPILE) --Estimate 8 rows
    SELECT * FROM DK WHERE K = 'AAAX' OPTION (RECOMPILE) --Estimate 8 rows
    SELECT * FROM DK WHERE K = 'AAX' OPTION (RECOMPILE) --Estimate 1 rows
    SELECT * FROM DK WHERE K = 'BXXXX' OPTION (RECOMPILE) --Estimate 1 rows
    SELECT * FROM…

    3 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 →
  6. 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 →
  7. 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 →
  8. 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.

    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 →
  9. 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 →
  10. sql server 2019 sys.dm_db_file_space_usage not correct !

    DMV sys.dm_db_file_space_usage shows incorrect data in column DFSU.allocated_extent_page_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 →
  11. 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](N'a')" the return is "a12", but i would expect "a123456789".

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

    4 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. 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 →
  19. 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 →
  20. 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 →
← Previous 1 3 4 5 263 264
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base