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. Directional relationship Error in SSAS Tabular reports as Memory Error or Unhandled Exception

    We are using the on Premise SSRS Report Server. We are connecting to a SQL2016 Tabular model (its is a very simple model we are using for training) Date Table, Sales table, Suppliers Table. The links are Dates M-1 Sales M-1 Supplier.

    When building some simple charts in PowerBI Desktop everything seems fine. You can build a chart showing Sales By Month for 2016 and add some calc measures so you get YTD values

    But if you then build a chart showing total sales and try and use a field from Suppliers as a category you get a broken visual…

    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 →
  2. Can't attach anything

    Despite this Microsoft Connect form saying attachment was successfully uploaded, the attachment never appears, even weeks later.

    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 →
  3. ODBC Driver 13.1 for SQL Server Inconsistent Metadata

    I'm submitting this as a bug, I think, related to the ODBC Driver 13.1 for SQL Server, but it could be related to the Database Engine; to that end, I'm putting this into the "SQL Engine" category.

    Four-part names when using a linked server from SQL Server 2016 to SQL Server 2016 using the MSDASQL provider with the "ODBC Driver 13(.1) for SQL Server" driver sometimes (inconsistently) generates an error: 'The OLE DB provider "MSDQSQL" for linked server "LinkedServerName" supplied inconsistent metadata for a column'.

    The same four-part name query works using the deprecated SQL Server 2012 Native Client and…

    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 26 2017 7:44AM=-=>

    I’m not sure how, but this was created under “ConnectAnonymousUser” after I clicked “Submit”.

    <=-=Jul 26 2017 7:49AM=-=>

    I’m not sure how, but this was created under “ConnectAnonymousUser” after I clicked “Submit”.

    <=-=Jul 26 2017 8:00AM=-=>

    I’m not sure how, but this was created under “ConnectAnonymousUser” after I clicked “Submit”.

    <=-=Oct 6 2017 2:38PM=-=>

    Thanks for reaching out. The issue you are seeing is within the MSDQSQL OLEDBODBC bridge driver. Back in 2011 we announced SQL Server 2012 Native Client deprecation. However, we later announced that didn�t apply to SQL Server 2012 Native Client driver for linked server scenarios (among other things). So we recommend you keep using linked server in your scenario. You can read the details of the announcement here: https://blogs.msdn.microsoft.com/sqlnativeclient/2017/08/15/ole-db-supportability-guidelines/

    We’ve also announced a new OLEDB Driver that will be shipping in the near future. You can find the…

  4. Restoring a database giving a false error

    When i'm restoring a SQL 2016 database on a different SQL 2016 instance through the GUI, the restore goes without errors. But on completion, the next error occurs:

    Restore of database 'name prohibited' failed. (Microsoft.SqlSever.Management. RelationalEngineTasks)

    Additional information:
    System.Data.SqlClient.SqlError: Cannot resolve the collation conflict betweel "SQLLatin1GeneralCP1CIAS"and "Latin1GeneralCIAS" in the equal to operation (Microsoft.SqlServer.SmoExtended).

    The database is online, but in single user mode.

    We did get the database to work correctly by detaching and re-attaching the database.

    We're working on VMware virtualization with SSD.

    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 →
  5. SMO Restore Timeout

    The default timeout - 10 minutes - cannot be changed. Setting another value, like 0, for the ConnectionContext.StatementTimeout property has no impact.

    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 →
  6. SSMS 17.1 Drag and drop to open .sql files on two monitors often opens the file on the wrong monitor

    Drag and drop to open .sql files on two monitors works inconsistently when having one set of tabs in the main application, and one set of tabs on the other monitor. Dragging an .sql file to one set of tabs often causes it to be opened in the other set. This seems to be largely dependent on the last place a file was previously opened.

    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 →
  7. Trigger When Sql Data Sync Group Changes

    Please add the ability to create a trigger in an SQL Data Sync Group so that when there is a change in the rows, I can send a push message via Notification Hubs.

    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 →
  8. Dont auto change Page Orientation by width vs height

    Hello I'm from Indonesia.
    I had problem with .net reporting. Even create use report viewer or visual studio, the problem still common. I had to use paper size 8.5" width and 5.5" height. We called this half letter with alias "Faktur" size. The problem is report automatically change the orientation to landscape because width are larger than height. And report detected as Statement Paper Size, cant be force even i create custom size because the size are same but the orientation is wrong. Even the report detected as Statement, the orientation is fixed as Landscape, cannot change to Portrait.
    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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  9. Trace Flag 652 doesn`t disable read ahead read manager in a specific case

    i was testing different scenario and found Trace Flag 652 doesnt disable Read ahead Read manager
    While scanning the full index using IAM Structure..
    I understand that this won
    t make any effect on the product, but these kind of stuffs are great for learning.
    Tested on Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2016.

    Sample Below:

    -- BEGIN: BUILD THE TEST DATA
    BEGIN TRAN

    select top 1000000
    rownumber () over ( order by (Select null)) n into Numbers from
    sys.all
    columns a cross join sys.all_columns

    CREATE TABLE [DBO].FRAG3 (
    Primarykey int NOT NULL ,
    SomeData3…

    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 →
  10. SSAS 2014 (Multidimensional) - CONCAT function has different behavior when used in T-SQL vs a named query in SSAS DSV

    When using the CONCAT() function in a T-SQL query, the user can concatenate more than 2 strings. When using CONCAT in the source query for a named query in the Data Source View in SSAS (Multidimensional), the user can only concatenate two strings.

    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 →
1 2 228 229 230 232 Next →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base