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. in-line comments not working in SSDT 14.0.61704.140

    Using an in-line comment indicator "--" is resulting in the DAX code being commented out all the way to the end of the equation, not just the code on that specific line; it is basically operating link an unclosed block comment indicator "/"... indeed you can actually close off the comment started with "--" with a block comment terminator "/".
    Block comments, obviously, are working fine.

    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

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

    Upvotes: 2

    <=-=Aug 10 2017 2:03AM=-=>

    We have the same issue. We just upgraded from version 14.0.61021.0 to version 14.0.61707.300
    The old version accepted all comment versions (—, //, /* */). The new version invalidated all our measures with comments since we use the // to indicate a single line of comments. Please fix this!

  2. Improved error message in sys.fn_xe_file_target_read_file when initial_file_name does not exist

    When you are using sys.fnxefiletargetreadfile and the parameters initialfilename and initialoffset you sometimes get this error message:

    "Msg 25722, Level 16, State 6, Line 1"
    "The offset 7680 is invalid for log file "test0131362101648490000.xel". Specify an offset that exists in the log file and retry your query."

    The problem is that you get the exact same error message in two cases:


    1. The initialfilename does not exist


    2. The initialfilename exists, but the initial_offset is not valid for that file


    It would be great if you could make…

    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

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  3. 'Ignore databases where the state is not online' not working in maintenance plan after applying SQL 2016 SP1 CU2

    After applying SP1 CU2 for sql 2016 enterprise my maintenance plans started to fail where 'all databases' and 'ignore databases where the state is not online' are selected. If i take the database online again the maint plan works. I have also deleted and set up a fresh maint plan and it still occurs. The only way these work now is to individually select the databases. This worked fine previously in SQL 2016 SP1 and CU1.

    The message in sql agent job doesn't really give much of a clue what is going on (just that it has failed) but error…

    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

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. Allow alias for rowversion/timestamp/xml

    Hi,
    please allow making aliases for the types:

    rowversion
    timestamp
    xml

    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

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  5. decimal 2

    Thanks on the current size of sql server decimal type.

    but because of the huge increase in data-sets that are reaching in terabytes and more, it would be good to have a second decimal, or another layer in decimal that can hold even more precision and scale.

    Regards.

    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

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Ottoman Language Collation

    Ottoman Language was an old traditional Turkish Language. Over 500 years, the language had been spoken and written in Anatolia, Asia and Africa. We have an archieve project in Turkey, but we struggle to develop the project without ottoman collation. Is it possible to add ottoman alphabet collation into collation list of sql server.

    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

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Getting "the path is not of a legal form" when doing file access in SSMS 17.0 restore dialog

    Getting this when trying to select a backup device:

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

    The path is not of a legal form. (mscorlib)


    Program Location:

    at System.IO.Path.LegacyNormalizePath(String path, Boolean fullCheck, Int32 maxPathLength, Boolean expandShortPaths)
    at System.IO.Path.NormalizePath(String path, Boolean fullCheck, Int32 maxPathLength, Boolean expandShortPaths)
    at System.IO.Path.GetPathRoot(String path)
    at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderBase.<EnumerateDrives>d_3.MoveNext()
    at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderEx.FillDrives()
    at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderEx.Initialize()
    at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderBase.Init(Boolean force)
    at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderBase.Init()
    at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreSelectBackupSource.AddFile()
    at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreSelectBackupSource.buttonAdd
    Click(Object sender, EventArgs e)

    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

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  8. system_health extended events session does not capture all events of the default trace, and should

    Before the SQL default trace is deprecated, it should have been completely replaced by the systemhealth extended events session. This is not specifically about traces being deprecated, but the default trace. The systemhealth session does not replace the default trace because it does not by default capture all events, for example, autogrowth events.

    I understand that extended events CAN record autogrowth events, but by default, the systemhealth session does not and the default trace does. As of now, for many diagnostic reasons, the default trace has not been replaced by the systemhealth session.

    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

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  9. Support Creation of Temporary Table Types

    Allow table types to be created temporarily, with lifespan and naming similar to temporary tables and temporary stored procedures.

    Currently, SQL Server allows external users/applications to pass lists and tabular-like data via table-value parameters. However, doing so requires that an appropriate table type exist on the server. If the needed type is not present, the user must create it. This requires that the user have permissions to create types.
    If the user lacks these rights or for some reason finds it undesirable to create a permanent table type (e.g. the need for the type is temporary and the user wants…

    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

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Aug 2 2017 5:03AM=-=>

    Thanks for this idea.
    The assumption is that someone who designs a database/interfaces already creates all necessary table types that clients will use, so it is unusual to see that someone needs to create and drop table type. We will keep this request in our backlog and let people vote for this.

  10. SSMS Default Data Source

    We are all the time using the SQL Server Import and Export Wizard. However, every time we use this wonderful tool, we have to choose the SAME datasource over and over. Could you make an enhancement to remember the last one used and to have that be the default the next time you go to use it? Thanks!

    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

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Titel

    DISCOVERCSDLMETADATA provides duplicate names and PowerBi Desktop reports an error while Loading Live Connecion OLAP Cube Schema

    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

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. Unwanted data deletion while inner query is taking longer time to execute

    Hello Team,

    While trying to delete the duplicate items using below sample query, we observed that some unwanted data is getting deleted from the table where we are trying to remove duplicates.
    In ideal situation, below query(Step#3) should run in single session and whatever is happening outside this session, should not get impacted because of this delete statement.
    However, if inner query is taking longer time to execute(lets say 5 minutes), whatever data is getting inserted into this table between start and end of the inner query, will also get deleted when outer delete statement executes.

    I have the alternate…

    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

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 0

    <=-=Jul 18 2017 11:25AM=-=>

    Hi Prashant,

    Based on the scenario you described – you’ll want to look at different isolation levels (non-default isolation levels).

    For example, snapshot and serializable isolation levels will prevent dirty reads, nonrepeatable reads and phantom reads.

    Best Regards,

    Joe Sack, Principal PM, Microsoft

  13. Application Role Insert failure after database upgrade to SQL 2016

    After restore a 2012 Database (that is using an application role) to a SQL 2016 environment the application role is broken and will not allow Inserts. The user gets an error "The INSERT permission was denied".

    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

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. Organize yellow the showplan tooltip in a way that makes sense

    Please see the image attached. The showplan tooltip displays information in seemingly arbitrary order. Please order the rows so that they are logically grouped.

    For example, actual and estimated values should always be next to each other. Even better would be to have two columns for them.

    Also the labels are inconsistent. Sometimes, it says "Actual X" and sometimes just "X" (e.g. "Number of Executions" vs. "Actual execution mode". They all should say "Actual/Estimated" in a consistent way.

    This improvement should take very little time to implement so it seems worth it. Right now finding anything there is just really…

    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

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add a feature to get OS-level stack traces from SQL Server to help with low-level query profiling

    For advanced query tuning it is sometimes very helpful to watch the actual OS-level stacks of SQL Server threads. I will attach an image of one to show what I mean. From the function names it is possible to tell in what exact operations SQL Server is spending its time. For example, one might see that a lot of time is spent in the expression service.

    Right now stacks can only be obtained in a cumbersome way: PerfView or Process Explorer running on the production machine.

    It would be very convenient to be able to have SQL Server directly provide…

    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

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Visual Studio 2015 crash when editing Name of ADO.NET Source component (SSIS)

    When i try to changa name of ADO NET Source component in my Data Flow diagram. And then press CTRL+S to save this changes. Visual Studio crash. I cant find any detail about the problem except this:
    Problem signature:
    Problem Event Name: APPCRASH
    Application Name: devenv.exe
    Application Version: 14.0.25420.1
    Application Timestamp: 57685d85
    Fault Module Name: DTS.dll
    Fault Module Version: 2015.130.4001.0
    Fault Module Timestamp: 5813fa15
    Exception Code: c0000005
    Exception Offset: 0007c9f6
    OS Version: 6.3.9600.2.0.0.272.7
    Locale ID: 1051
    Additional Information 1: 5861
    Additional Information 2: 5861822e1919d7c014bbb064c64908b2
    Additional Information 3: 1318
    Additional Information 4: 13181ae637ac2592fac0ca2dd662cdcc

    Read our privacy statement online:
    http://go.microsoft.com/fwlink/?linkid=280262

    If the…

    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

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 2

    <=-=Oct 5 2017 7:19AM=-=>

    We are having the same issue with SSDT 17.2 Build number: 14.0.61707.300. As soon as we open a package in our project, devenv crahshes with following details:
    Problem Event Name: APPCRASH
    Application Name: devenv.exe
    Application Version: 14.0.25420.1
    Application Timestamp: 57685d85
    Fault Module Name: ACEWSTR.DLL
    Fault Module Version: 16.0.4266.1001
    Fault Module Timestamp: 55ba1594
    Exception Code: c0000005
    Exception Offset: 0000ee37
    OS Version: 6.1.7601.2.1.0.256.48
    Locale ID: 1033
    Additional Information 1: 0a9e
    Additional Information 2: 0a9e372d3b4ad19135b953a78882e789
    Additional Information 3: 0a9e
    Additional Information 4: 0a9e372d3b4ad19135b953a78882e789

    This only occurs with SSIS projects using ADO.Net connectors.

  17. OVER CLAUSE() with identical PARTITION BY and ORDER BY field lists

    I am using ROWNUMBER() to create numbered rows within a CTE, and using the main select to choose a row to report. I have 3 records written for each CodeKey value, each with a different variable containing a value (I used 'A', 'B' and 'C' containing the fieldname concatenated with the CodeKey value). When I select the ROWNUMBER result, I get the summarization of all records within the CodeKey group, rather than the 1 field value associated with that row.

    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

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  18. Back Up and Restore options missing from Tasks menu in SSMS

    Microsoft SQL Server Management Studio version 14.0.17119.0 (17.1)

    When I create a database containing only numbers and periods in the name, e.g.: "5.0.17195.1" the Back Up and Restore options do not appear in the Tasks menu (right-click database > Tasks).

    Background: We have an automated process that deploys databases in our quality environment based on build numbers. Anecdotally, this was not a problem in previous versions of SSMS (2012, 2014). We have since updated the process to use underscores instead of periods, but this still feels like a UI bug since nothing prevents us from creating a database with periods…

    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

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  19. In-line comments are not working in SSDT 17.x

    Using inline comments ("--") is not working in SSDT 17.0 or 17.1 for measures in tabular models. Adding "--" before any line of code is commenting out all following code despite the presence of line breaks . Block commenting still works.

    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

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  20. Inconsistent results using OUTER APPLY, GROUP BY until ordering is forced via OPTION (FORCE ORDER)

    Please see attached for the problem query.

    The basic gist is a subquery produces rows per employee, where each employee has an AccountCode and a short term incentive payment amount (STIP) - these values are resolved via OUTER APPLY queries on the original Employees table.

    The requirement is now to show the total payment per account - so a simple GROUP BY over that result set with a SUM in the SELECT should be enough.

    When I run the query over the entire result set vs filtering to 1 specific account code, I get the same number of rows for…

    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

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

SQL Server

Categories

Feedback and Knowledge Base