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.

Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. SSMA Access - Convert Unique Index with NULL to a filtered Index

    SSMA Access - As you already identify these Indizes on conversion, you easily could automatically convert them to filtered index - please do so that would be extremely helpful.

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Table Folders

    Users should be able to add folders and sub-folders within a database. This would be especially useful in the case of the Tables folder. The amount of tables within a database can be overwhelming without additional organizational capabilities.

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  3. TimePeriod CLR possibilities in SQL

    Should be nice to have some timeperiod CLR assembly in SQL to allow intersection, overlap, combined duration, ... calculation in SQL.

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  4. Hello, can you please provide 'previous' and 'next' buttons beside the tabs of the query editors in SQL Server Management Studio?

    Above the query editor tabs in SQL Server Management Studio I only see a drop down button at the right. This behaves like Ctrl+Tab and Ctrl+Shift+Tab, but I would prefer clicking on previous and next buttons to quickly go to the next or previous open SQL editor tab in the order that these tabs are shown, not in the order that they were opened. The Ctrl+Tab / Ctrl+Shift+Tab functionality confuses me very much.

    Also in Visual Studio this behaviour of the existing next and previous buttons confuses me. Why not going to the next open editor instead of going to…

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Export sql results directly into a xlsx-Excel file with each result into a separate tab

    It would be nice to have a "one click" solution to export ALL sql results into ONE xlsx-Excel file. [When click on the Button "Execute" (F5)]

    Each result should be written into ONE separate Excel-Tab within the Excel-File.

    Column header information (column names) should also be included.

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Support standard escape sequences in strings (e.g. unescape "\t" into CHAR(9), "\n" into CHAR(10), etc)

    Most languages allow for a limited number of escape sequences in strings, such as: "\n" for newline (0x0A), and "\t" for tab (0x09). Currently we need to concatenate those values in as either CHAR(0x0A) / CHAR(10) or assign that to a CHAR variable and concatenate the variable in. For example:
    --------------------------------------
    DECLARE @CRLF CHAR(2) = CHAR(0x0D) + CHAR(0x0A), -- same as CHAR(13) + CHAR(10)
    @TAB CHAR(1) = CHAR(0x09); -- same as CHAR(9)

    PRINT 'first part' + @TAB + 'middle' + @TAB + 'end.' + @CRLF
    + 'Now on next line.' + @CRLF;
    --------------------------------------

    That concatenation is a lot more unwieldy…

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  7. T-SQL: simplified CURSOR loop

    Hi.

    Currently, to declare and iterate a cursor, one has to write the following:

    | -- Cursor declaration
    | DECLARE my_cursor CURSOR FOR
    | SELECT col1, col2 FROM ...;
    |
    | -- Variable declaration that holds individual values for each row.
    | DECLARE @var1 INTEGER;
    | DECLARE @var2 VARCHAR(10);
    |
    | -- Iteration
    | OPEN my_cursor;
    | FETCH NEXT FROM my_cursor INTO @var1, @var2;
    |
    | WHILE @@FETCH_STATUS = 0 BEGIN
    | -- Do stuff
    | FETCH NEXT FROM my_cursor INTO @var1, @var2;
    | END;
    |
    | -- Mandatory close if one wants to open the cursor again, else it…

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  8. T-SQL: add parameters/arguments to CURSOR declaration

    Hi.

    Cursors in T-SQL can be declared as

    | DECLARE my_cursor CURSOR FOR
    | SELECT ...;

    The query can access variables in the local scope. However, for the sake of code re-usability and flexibility, it would be best if CURSORs could accept arguments.

    Example (loosely based on Oracle's syntax):

    | DECLARE my_cursor CURSOR(@arg1 INTEGER, @arg2 VARCHAR(10), [...]) FOR
    | SELECT ... FROM ... WHERE col1 = @arg1 AND col2 != @arg2;
    |
    | OPEN my_cursor(1, 'asd');
    | FETCH NEXT FROM my_cursor INTO ...;

    The alternative right now is to declare @arg1 and @arg2 as local variables, which is ugly.

    Thank…

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  9. MultiSubnetFailover support for Reporting Services

    Please add support for MultisubnetFailover for Report Server. Per msdocs: "The use of MultiSubnetFailover, with the report server databases, is not supported."

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Add a feature to avoid ambiguous column names when adding new join to existing query

    Imagine we have a complicated multiline query from 2 tables

    A(pkA,a1,a2)
    B(pkB,fkA,b1,b2)
    and we have a query which we have not added table preffix for columns:

    select pkA,a1,a2,b1,bb2,....
    from A inner join B ON pkA=fkA
    where a1=1 and a2=2
    order by a1
    now we want to add self reference column fkSelfA to table A and we then want to change the self reference join to query, the query should all change to:

    select A.pkA,A.a1,A.a2,b1,bb2,SelfA.A1 as SelfA1
    from A inner join B ON pkA=fkA
    LEFT JOIN A SelfA ON SelfA.pkA=A.fkSelfA
    where A.a1=1 and A.a2=2
    order by A.a1
    As we can see…

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Polybase support struct data type in HDFS

    Polybase should add support for mapping struct data type in hdfs in parquet file. When I tried to read column in struct data type I managed to create external table but select give me this error:

    Msg 7320, Level 16, State 110, Line 2
    Cannot execute the query "Remote Query" against OLE DB provider "SQLNCLI11" for linked server "(null)". HdfsBridge::recordReaderFillBuffer - Unexpected error encountered filling record reader buffer: ClassCastException: optional group crm {
    optional binary accessNetwork (UTF8);
    optional binary acsId (UTF8);
    optional binary assetId (UTF8);
    optional binary dslamFrame (UTF8);
    optional binary dslamName (UTF8);
    optional binary dslamPort (UTF8);
    optional binary dslamSlot…

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  12. Please add database size in the Task->Backup Section

    Please add database size in the Task->Backup Section page. This will be helpful to see an estimation of the database size and decide if we can take a local or third party backups.

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Synonym Metadata Not Displayed when Querying via ODBC

    Can synonym metadata be displayed when querying via ODBC?

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  14. SQL Server vNext (post 2019) and NoSQL functionality

    Hello,

    This is an invitation for discussion to the SQL Server engine team and the community.

    IMHO, SQL Server vNext (post 2019) should beef up its NoSQL functionality.
    Specifically, its XML APIs.
    This area is dormant since 2005/2008 release.

    SQL Server currently supports the following:
    - a subset of XQuery 1.0, circa 2007
    - a subset of XPath 2.0, circa 2007
    - XSD 1.0 circa 2001

    The current w3c standards:
    - XQuery 3.1
    - XPath 3.1
    - XSD 1.1 circa 2012

    Everything is in place, even current support for the UTF-8 encoding in 2019.

    Famous Obamacare is implemented by using…

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Create Alpine Linux release of SQL server drivers for Docker Container Builders

    Docker Containers are great. However to take full use in the enterprise environment - you need quality DB drivers.

    Official Drivers are better than freetds - and works flawlessly in Redhat or Ubuntu. Yet for builiding containers - alpine seems at times better - creating alpine build of SQL server drivers would enable many enterprises to build SQL enabled containers

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  17. SSMS "Generate Scripts" functionality should have option to script objects to separate subfolders by schema and object type (like SSDT).

    SSMS's "Generate Scripts" functionality would be more useful if it gave to option to script objects to separate subfolders by schema and/or object type - like SSDT but without the arbitrary 1000 object count limitation per folder.

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. SSMS "Generate Scripts" options should include "Create or Alter" if compatible database engine edition is selected.

    The database-level "Generate Scripts" functionality in SSMS would be more useful the advanced option were "CREATE OR ALTER" were available instead of just CREATE or DROP AND CREATE. This would allow alterations to procedures and functions to be detected and integrated into distributed version control without dropping the objects (and losing permissions, query store plans, etc).

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Prevent Dialogs from Taking Focus

    When a dialog is opened in SSMS (or from ADS) it often takes focus. However, because there can be a delay, we often multi-task and start working in another window. The taking of focus from the working window to a dialog is frustrating and intrusive.

    Can we open dialogs without them taking focus?

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

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  20. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 195 196
  • Don't see your idea?

SQL Server

Feedback and Knowledge Base