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. Replace the import wizard with Power Query

    Instead of using the outdated import wizard (not the new one that was released recently in SSMS), a new one should be created that leverages the Power Query engine (aka the M language) to import data into SQL Server.

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

    We’ll send you updates on this idea

    under review  ·  3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Support for Temporal Relation Predicates first defined in ISO 9075-1:2011 (SQL:2011)

    Temporal Comparison/Relation Predicates:
    CONTAINS, OVERLAPS, EQUALS, PRECEDES, SUCCEEDS, IMMEDIATELY PRECEDES, and IMMEDIATELY SUCCEEDS

    Having these predicates would reduce a lot of the effort and pitfalls involved in writing temporally sensitive queries.

    I don't know the formal syntax proposed by ISO, but simply having these predicates can reduce up to four separate and hard-to-read expressions into a single one.

    Ex:
    WHERE (dt1start, dt1end) CONTAINS (dt2start, dt2end) -- span dt1 is completely within span dt2
    WHERE NOT (dt1start, dt1end) OVERLAPS (dt2start, dt2end) -- no part of span dt1 overlaps span dt2
    ... etc.

    As…

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  3. SSMS Pinned tabs persisted

    When a tab is pinned, it would be useful if it could be 'locked' so when a new session is started those pinned tabs are still pinned

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  4. sql 2017 reporting services self migrate from previous versions

    Update reporting services standalone installer to self migrate from earlier versions of reporting services. The process is currently a real pain as it takes a lot of extra work to move to the latest SQL reporting services when the previous versions just upgraded it in place.

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  5. DIVIDE function in T-SQL

    The languages MDX and DAX both have a DIVIDE function, which has the following syntax:

    DIVIDE(<numerator>, <denominator> [,<alternateresult>])
    The alternate result is specified as the result when a division by zero is encountered. If it isn't specified, NULL is returned.

    This would be a fine addition to the T-SQL language.

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Support for INCLUDE on inline index creation

    Sadly, the below sample CREATE TABLE command fails. While support for certain features have been added to inline index creation syntax since it's original release, INCLUDE'd columns are not yet supported.

    Please add syntax support for inline creation of indexes with INCLUDE specifications.

    ```sql
    drop table if exists foo;
    go
    create table foo (

     a int primary key
    
    ,b int
    ,c int
    ,index d (c) include (b)

    );
    go
    ```

    References:
    1. Official docs: "Include not supported."
    * https://docs.microsoft.com/en-us/sql/database-engine/whats-new-in-sql-server-2016?view=sql-server-2014#inline-specification-of-clustered-and-nonclustered
    2. msdn blog: filtered index & columnstore support added for inline index syntax
    * https://blogs.msdn.microsoft.com/arvindsh/2015/05/31/inline-index-definition-in-sql-server-2016-ctp2/

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

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Scalar MAX function

    It would be nice to have a scalar MAX function (name it S_MAX) that returns a maximum of two numbers. Right now you have to use CASE or write your own TVF and CROSS APPLY it, both are quite clumsy. Same for minimum of two:

    SELECT
    SMAX(1, 0) --yields 1
    ,S
    MIN(1, 0) --yields 0

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

    We’ll send you updates on this idea

    under review  ·  5 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  8. SSDT 17.x - Unable to preview SSIS OLE DB Data Source when using Oracle Connector

    I have an SSIS packages that queries an Oracle data source. When trying to preview the query in the data source configuration window, it errors out.

    Technical Details:
    Visual Studio 2015, Update 3, Version 14.0.25431.01
    SSDT 17.4 (Build 14.0.61712.050)
    Oracle Client 12.1.0
    OLE DB Connector: Oracle Provider for OLE DB

    Error Details:

    There was an error displaying the preview. (Microsoft Visual Studio)

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

    The system cannot find message text for message number 0x80040e51 in the message file for OraOLEDB. (OraOLEDB)


    Program Location:

    at Microsoft.DataTransformationServices.Design.UnsafeNativeMethods.ICommandWithParameters.GetParameterInfo(IntPtr& pcParams, IntPtr& prgParamInfo, IntPtr& ppNamesBuffer)
    at Microsoft.DataTransformationServices.Design.DesignUtils.GetQueryParameters(ConnectionManager connectionManager, String sqlStatement)
    at Microsoft.DataTransformationServices.Design.PipelineUtils.ShowDataPreview(String sqlStatement, QueryParameter[] parameters, ConnectionManager…

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

    We’ll send you updates on this idea

    under review  ·  6 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add SSMS Option to show NULL value Differently than 'NULL' text

    It would be nice if SSMS could be used to help distinguish between NULL values and the 'NULL' string value. Perhaps show NULL in grey? Just spent 6.5 hours troubleshooting what turned out to be a string 'NULL' inserted by someone rather than NULL, and if it had been clear on the initial query results grid, I'd have found that much more quickly.

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

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Deploy issue for SSDT database extended property / external tables

    Deploy issue for SSDT database extended property / external tables

    Summary:
    Deployment of an extended property 'MS_DESCRIPTION' on an external table fails, if the Extended property is scripted together with the external table.

    Deployment of an Extended property 'MS_DESCRIPTION' on an external table succeeds, if the Extended property is added in a postdeployment script.

    If something is changed, redeployment of the database fails, because the extended property 'MS_Description' can't be deleted.

    The following code is produced:
    EXECUTE spdropextendedproperty @name = N'MSDescription';

    This code would be correct:

    EXEC sys.spdropextendedproperty
    @name = N'MS
    Description',
    @level0type = 'Schema', @level0name =…

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  11. Fix the Problem of Converting Hijri Dates to Gregorian Dates

    Currently Microsoft tsql function called Convert() is not able to convert the Hijri date 'yyyy-02-30' to its corresponding Gregorian Date, here are the details of this issue

    https://social.msdn.microsoft.com/Forums/en-US/b86b0cf6-280d-436e-ba92-ff168794c420/error-in-converting-hijri-date-to-gregorian-date?forum=sqlnetfx&prof=required

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. CEIP Service cause noisy error log

    We found that CEIP Service causes following error log messsage in production server.

    CImageHelper::Init () Failed load of symbol file with path = D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\;D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\BINN Error Code 0xc0000004


    • 0xc0000004 : The specified information record length does not match the length that is required for the specified information class

    following attached file is event log that I collected.
    Version of prod server is following (which is on AZURE):
    Microsoft SQL Server 2016 (SP1-CU5) (KB4040714) - 13.0.4451.0 (X64) Sep 5 2017 16:12:34 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Datacenter 6.3 <X64> (Build…

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

    We’ll send you updates on this idea

    under review  ·  4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  13. DATETRUNC(datepart,datevalue) instead of dateadd-datediff

    The generally accepted way to truncate some part of a datetime is:
    DATEADD(datepart,0,DATEDIFF(datepart,0,datevalue))
    To save us from much typing, and probalby a good amount of CPU due to a good implementation, I propose we create a new function exactly for that:
    DATETRUNC(datepart,datevalue)
    which rids the datevalue of any component LESS than datepart (ie, truncates it to the dateart level)

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  14. SSRS report builder not working after applying SQL update

    I have noticed that I can no longer use the “Report Builder” functionality in SSRS (while opening it from Report manager URL) after patching SQL Server 2012 Sp4 with recent CU KB4057116.

    Window Server 2008 R2 Standard
    SQL Server 2012 SP4 (11.0.7001.0)
    Getting below error after installing KB 4057116

    https://support.microsoft.com/en-us/help/4057116

    Following errors were detected during this operation.

    * [26/02/2018 10:15:22] System.Deployment.Application.InvalidDeploymentException (HashValidation)
    
    - File, interop.shdocvw.dll, has a different computed hash than specified in manifest.
    - Source: System.Deployment

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

    We’ll send you updates on this idea

    under review  ·  8 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  15. CDW from 2016 to 2017 ends with "Property HasMemoryOptimizedObjects is not available for Database"

    Hi
    I'm trying to copy a couple of databases from a SQL2016 to SQL2017 using the Copy Database Wizard.
    I'm using SQL Management Object Method in SSMS 17.3
    SSIS Proxy account is sysadmin on both instances and local admin i Windows on both servers.
    When running the job I get the error "Property HasMemoryOptimizedObjects is not available for Database '[DATABASENAME]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.
    The databases has no Memory Optimization configured.

    If I try to use detach/attache methods I can't select any of the databases witch…

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

    We’ll send you updates on this idea

    21 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add sftp to SSIS

    Add sftp component to SSIS

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  17. SSRS - Bullets and Number Lists in HTML

    SSRS text fields formatted as HTML which contain an <ol> or <ul> tag get list numbers or bulets (respectively) which do not have the font size specified in the text box properties. For example, a numbered list with a text box font size of 8pt gets numbers with a font size of 10pt. A bulleted list gets a symbol font with a font size of 10pt. This modified the line height and modifies the list spacing from the default line height as well.

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  18. Query store create database

    If you enable Query Store on model, then attempt to create a database, Query Store will be enabled on the new database.

    However, if you attempt to create a database using a non-default collation, the CREATE database fails with a deadlock on sys.sysschobj, in the middle of a DQS transaction. (I'm using 2017 CU4)

    I should be able to specify a non-default collation when creating a database, and not have DQS cause a failure.

    --Enable Query Store on model
    ALTER DATABASE model SET QUERYSTORE (OPERATIONMODE = READWRITE);
    GO
    --Create a database using any collation other than your

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  19. 7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  20. sql server on Linux reports 100% cpu when using RING_BUFFER_SCHEDULER_MONITOR to monitor

    RINGBUFFERSCHEDULER_MONITOR - reports that sql server uses 100% cpu but that is not true.

    e.g.

    <Record id="17239" type="RINGBUFFERSCHEDULER_MONITOR" time="4619440182">
    <SchedulerMonitorEvent>

    &lt;SystemHealth&gt;
    
    &lt;ProcessUtilization&gt;100&lt;/ProcessUtilization&gt;
    &lt;SystemIdle&gt;0&lt;/SystemIdle&gt;
    &lt;UserModeTime&gt;0&lt;/UserModeTime&gt;
    &lt;KernelModeTime&gt;0&lt;/KernelModeTime&gt;
    &lt;PageFaults&gt;0&lt;/PageFaults&gt;
    &lt;WorkingSetDelta&gt;0&lt;/WorkingSetDelta&gt;
    &lt;MemoryUtilization&gt;100&lt;/MemoryUtilization&gt;
    &lt;/SystemHealth&gt;

    </SchedulerMonitorEvent>
    </Record>

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base