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. Deleting an Azure SQL database throws an error about Anonymous Login, but deletes the database

    Right click DB created by an unsucessful SSDT publish and choose delete, then click OK on the dialog to delete it.

    Things spin around but then an error is reported about NT AUTHOIRITY\Anonymous login (sp), and I have to click Cancel to close the dialog. Refreshing the databases list in Object explorer shows the db has been deleted.

    Here is the redacted details from the error message.
    --------
    ===================================

    Drop failed for Database 'MY_DATABASE'. (Microsoft.SqlServer.Smo)

    ------------------------------
    For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=15.0.18131.0+((SSMS_Rel).190606-1032)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Database&LinkId=20476

    ------------------------------
    Program Location:

    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.DropImpl(Boolean isDropIfExists)
    at Microsoft.SqlServer.Management.Smo.Database.Drop()
    at Microsoft.SqlServer.Management.SqlManagerUI.DropObjects.DoDropObject(Int32 objectRowIndex)
    at Microsoft.SqlServer.Management.SqlManagerUI.DropObjects.DropAllObjects(Boolean stopOnError)

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

    An exception occurred while executing…

    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 →
  2. فاطمه اسکندری پرسنل تعویض پلاک اتحاد

    فاطمه اسکندری پرسنل تعویض پلاک اتحاد

    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. 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 →
  4. 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 →
  5. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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 →
  7. 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 →
  8. SQL Server CTP 3.1 function error

    Call a function like this:

    SET @var_FirstPolicyID = dbo.f_IPD_GetFirstPolicyID(@p_PolicyID, DEFAULT, DEFAULT)

    causes SQL Server to throw the following exception:

    Msg 596, Level 21, State 1, Line 0
    Cannot continue the execution because the session is in the kill state.
    Msg 0, Level 20, State 0, Line 0
    A severe error occurred on the current command. The results, if any, should be discarded.

    This has been tested in both 2016 and 2017 and works ok.

    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 →
  9. 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 →
  10. Criteria pane handles strings, resembling decimals, incorrectly

    When using Criteria pane and want to filter by varchar(50) column using value 27208863,10353, it shows that it is treated like string, but only after the value was determined as decimal earlier, resulting in inserting wrong value to the query being executed.
    You have to insert the value in quotes manually to get correct results.

    27208863,10353 => '27208863.10353'
    '27208863,10353' => '27208863,10353'

    Same behavior in SSMS 17.7 and 18.1.

    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. Azure Data Studio loses parts of the Query Plan visual

    When switching between tabs in Azure Data Studio, if I have a query plan displayed then when switching back to that tab the lines between the operators have disappeared

    Steps to reproduce the bug:

    1 Run a query – any query
    2 Hit the Explain button to get the graphical query plan
    3 Switch to another tab
    4 Switch back to the query tab – the connection lines between the operators in the query plan have disappeared.

    Version 1.7

    2 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. SSMS 18.x cannot connect to SQL Server 2017 SSIS but 18.x is the version linked to for the 2017 Sql Server

    SSMS 18.x cannot connect to SQL Server 2017 SSIS but 18.x is the version linked to for 2017 Sql Server.

    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 →
  13. 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 →
  14. Register Servers SSMS Command Utility or Allow Changes to Registered Servers Default Location

    Some setups don't allow files saved to certain folders to persist after restarts. This creates a problem for users wishing to use the Registered Server feature. There are a couple ways to make it easier on users. One would be to add an option to import registered servers using the SSMS command utility. (SSMS *.regsrvr) The other would be to allow users to choose where SSMS saves and reads registered servers at startup. Currently, I have to open SSMS and then import the .regsrvr file everytime I open ssms. Thanks.

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

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  15. i got this problem, can't import data. Any help?

    "this feature is not currently available in this version or the database is not available" i got this problem, can't import data. Any help?

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

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  16. Just uninstalled ssms 18.1 and installed an older version instead.

    Wasn't a fan of 18.1 and when I'd switch between different tabs (windows), the windows wouldn't refresh. In otherwords, If I'm looking at stored procedure A on tab 1 and stored procedure B is open on tab 2, if i switch to tab 2, I still see code for stored procedure A. I just downgraded to SSMS 2016 (16.1) and don't have this issue. I also think SSMS 2016 is more visually pleasing then the newer version. I think sometimes in the unending pursuit to improve software, we end up actually making things worse......

    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. Intermittent "One or more parameters were not specified for the sub report" in SSRS

    I have an internal parameter that defaults to the User!UserID on all of the master and subreports as well as multiple visible parameters. Frequently, when I run the master report it runs no problem and some times it fails
    with the "one or more parameters..." message (same values). I resubmit and it works (I have to change something to get it to resubmit so I usually change a lower case a to an upper case A or something similar).

    I'm having problems isolating exactly what is causing 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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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 →
  19. 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 →
  20. Beim ziehen einer Tabelle mit der linken Maustaste in Editor kommt eine Fehlermeldun und das Studio kann nur im Taskmanager beendet werden.

    Beim ziehen einer Tabelle mit der linken Maustaste in Editor kommt eine Fehlermeldun und das Studio kann nur im Taskmanager beendet werden.

    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 476 477
  • Don't see your idea?

SQL Server

Feedback and Knowledge Base