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 Stack Overflow or MSDN.


  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Don't deprecate database diagrams.

    I design large scale databases visually with the diagram feature of SQL server. I cannot comprehend how a db designer would tackle a large scale ER model. What is the reason for the deprecation and what is the planned alternative?

    1 vote
    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 →
  2. SSMS 508 compliance

    Trying to determine 508 compliance for SSMS; any guidance available?

    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 →

    Our 508 Conformance documentation can be found the the following link
    https://celaaatprod.blob.core.windows.net/public/1e153b8b-985d-4b0e-9ef9-5fd4170e0c84/52e451a1-b639-4fbe-94ae-55de5d66e06c/SQL%20Server%20Management%20Studio%2018.Windows.RevisedSection508.docx

    This document along with those for other accessibility standards can also be reached by https://cloudblogs.microsoft.com/industry-blog/government/2018/09/11/accessibility-conformance-reports/ and searching for “SQL Server Management Studio”

    Thank you for reaching out,
    Erica

  3. SSMS - Delete the saved user when logging in

    I wish to be able to delete only some saved users from the login screen.
    I know there is a file that I can delete and clear this record, except I did not want to delete all and only those that I no longer use.
    If possible the connections of the instances too.

    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 →

    If you are referring to the “Connect to Server” dialog, then one thing you can do is something like this:

    - Click on the “Server name” combobox (the down-arrow icon)
    - Select the server you want to remove
    - Hit the “DEL” key

    You should be able to do the same thing when you select “SQL Server Authentication” and you work in the “Login” combobox.

    You need SSMS 18.x for that to work on Logins.

  4. Could you also unlock TDE for the Standard Edition? Due to new legal regulations in DE/EU (General Data Protection Ordinance), many databas

    Could you also unlock TDE for the Standard Edition?

    Due to the new legal regulations in the DE/EU (General Data Protection Ordinance), many databases should be encrypted.

    For many small/medium sized companies it is impossible to switch to Enterprise.

    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. Identify Slow Queries in Stored Procedures

    Slow queries in stored procedures are difficult to find. After much searching on Google and some enhancing, I use the query below to find slow queries. The 3 ORDER BY clauses find the slowest query per execution, the query with the highest total time, and the query that executes the most. It is very helpful to know which query in which stored procedure is slow. I suggest adding this or something similar to the "Reports->Standard Reports" area of SSMS.

    SELECT qs.totalelapsedtime,

             qs.last_execution_time, qs.execution_count, qs.total_worker_time,
    
    so.name,
    SUBSTRING(st.text,qs.statement_start_offset/2+1,
    ((CASE WHEN qs.statement_end_offset = -1 THEN DATALENGTH(st.text)
    ELSE qs.statement_end_offset END) - qs.statement_start_offset)/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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Why must one perform a full backup to add to an AG, when the wizard does a full backup?

    When adding a database to an availability group, one must perform a full backup, before meeting the prerequisites.
    However, once you do this, the wizard just performs another full backup anyway.
    This seems redundant.
    Why not just let the wizard do this, and not make it a requirement, as it's going to happen anyway?

    1 vote
    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 →
  7. 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 →

    We take a number of inputs into consideration when triaging issues. Business impact (severity of the issue) as well as Votes (or likelihood of a customer being impacted) are just two of the factors we consider when triaging.

    We do not simply use votes alone.

  8. Enable batch mode for all queries

    As of SQL 2014 batch mode is tied to whether the query reference any columnstore index in any way or not. It is not tied to actually retrieving data out of a columnstore index. For example you can make any query at all use batch mode by joining to a zero-row columnstore dummy table:

    LEFT JOIN ZeroRowsCsDummyTable on 0=1

    The optimizer deletes that join and there is zero performance impact. Real speedups can be observed in many query by mechanically slapping this onto queries.

    So apparently the engine supports batch mode in all queries and it is profitable to use…

    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 →

    We have rolled out the public preview of batch mode on rowstore starting with SQL Server 2019 CTP 2.0 and coming soon to Azure SQL Database. We still won’t have this run for * all * queries given that it isn’t appropriate for all workload types, but we will expand the query optimization search space based on heuristics. Described here: https://docs.microsoft.com/en-us/sql/relational-databases/performance/intelligent-query-processing?view=sql-server-2017#batch-mode-on-rowstore

  9. SSMS install location

    SSMS should not be "magically apple installed" to wherever it pleases. it should ask me where the #$@% I want it to live. How the hell do you drop such a simple and basic feature? Rationalize all you want about how nobody needs it, or it has a small footprint so it's ok, or ... or ... - but it's stupid.

    Simple stuff MS, stop turning into Apple and find your way again... atm you're lost on every simple thing and customers like my enormous company are starting to fall away... (We dropped dozens of sql server installs this year)

    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. Intellisense for REPLACE function is useless

    Please have a more helpful Intellisense description for the REPLACE function...

    You need to come up with something better than REPLACE(expression nvarchar(1), expression nvarchar(1), expression nvarchar(1)) RETURNS nvarchar(1)

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

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  11. SQL Temporal

    Have you ever had to create databases using Temporal Database design Patterns using any current day Relational Database?
    Doesn't SQL Server now have the horse power to handle advanced database designs?

    How about adding Temporal capability to SQL Server to either the Engine or as an Add On the way Analysis Services, Reporting Services, etc.

    The classic example is to have a contact database that is able to track the changes to last names for married women. You have a contact table, but you also need a table to track the last names of the women and it's effective date.…

    0 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 →
  12. Release Service Pack 2 for SQL Server 2012

    Service Pack 1 for SQL 2012 was released over a year ago. Since then, numerous bugs have been fixed. They are available in cumulative update packages (10 to date). However, Microsoft recommends customers not to install these cumulative updates unless affected by one of the fixed bugs. That creates a dilemma for SQL Server administrators. You do not want to install a package if Microsoft recommends against it, but you also want to take pro-active action so that you can squash the bug BEFORE it affects you.

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

    We’ll send you updates on this idea

    completed  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Add rowcount to live query statistics.

    This is an issue I noticed whilst running the query mentioned in this feedback item https://connect.microsoft.com/SQLServer/Feedback/Details/1955647

    After the hash build input is completed the nested loops requests one row at a time and because the inner side of the nested loops join is slow all the other sub trees appear slow too and the percent complete increases for all of them in parallel.

    This does not help to pinpoint the busy operators.

    If the actual rows was displayed on the plan itself rather than buried in the properties window it would be possible to see at a glance that it…

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

    We’ll send you updates on this idea

    completed  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  14. SSRS 2016 Open Excel Workboos in Office Online Server 2016 (OOS)

    The new SSRS portal is great, however the one thing it really needs is the ability to render excel workbooks in the browser. With OOS 2016 being a standalone product now, surely it wold be relatively easy to allow it to integrated with the new SSRS portal and render uploaded excel workbooks with pivot tables.

    0 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 →

    Upvotes: 1

    <=-=Feb 16 2017 4:48PM=-=>

    Thanks for your feedback – As communicated in a blog post on the Reporting Services team blog, we intend to include support for Excel Workbooks and viewing in browser in the next release of RS. This would leverage OOS accordingly – as such, I have closed this item as a duplicate of the work we already have planned.

    Thanks,

    The SQL Server BI Team

  15. Allow users to disable phone-home feedback in SQL 2016 Developer, Express, and Evaluation Editions

    By default, SQL Server 2016 phones home with telemetry data as described in https://support.microsoft.com/en-us/kb/3153756. Let users disable that telemetry in Developer, Express, and Evaluation Editions.

    0 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 →

    Upvotes: 325

    <=-=Jun 2 2016 10:19AM=-=>

    From https://www.microsoft.com/EN-US/privacystatement/SQLServer/Default.aspx, “It is possible that personally identifiable information may be captured in memory or in the data collected from open files, but Microsoft does not use it to identify you.”
    My developers must write and use interfaces to bank cores. Because of https://support.microsoft.com/en-us/kb/3153756, my developers will potentially be sending MS the bank accounts, names, addresses, social security numbers, birth dates, and various passwords for millions of US citizens. This is unacceptable.

    <=-=Jun 2 2016 11:26AM=-=>

    I was going to install it on my report server but I can’t if this isn’t fixed because even the potential of leaked data is serious to my clients. In fact, I already keep a SQL express version separate for my internal reporting from my non-express SQL Server engine to minimize exposure. That means I’ll need to stick with 2014 which is too bad as I…

  16. SSMS: Improve Actual Plan window interface

    There is an improvement in Showplan in SQL Server 2016 and upcoming SQL Server 2014 SP2 that includes different metrics for each plan operator like:

    ActualElapsedms="160"
    ActualCPUms="158"
    ActualLogicalReads="2466"
    � etc.

    It would be nice to see these properties exposed in the Operator properties window in SSMS, not only in XML. And more important to see ActualElapsedms (or an option to choose between the extended option) directly under a plan operator icon, like we see an operator cost percentage.

    Another improvement is to see the actual and estimated row count directly under a plan operator, because the difference between them is…

    0 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 →
  17. Display published version number somewhere in SSMS so user can tell what version they are running

    Display published version number somewhere in SSMS so user can tell what version they are running without having to derive it from obscure information.

    Displayed version in Help/about appears to not have anything to do with the published version number.
    eg: current version according to the site users are sent to by the updater prompt in SSMS is v16.5.3 but the version for SSMS listed under help about is 13.0.16016.4.

    0 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 →

    Upvotes: 2

    <=-=Feb 13 2017 10:30PM=-=>

    Hi DBithead,
    Thanks for reporting this issue. We are aware of that and indeed fixed it. You should see this in a future version of SSMS (you can see it today if you give the SSMS 17.0 RC2 a try): the help/about will show pretty clearly that this is “v17.0 RC2” right at the top of the window. You’ll still see the precise file version of some components in the grid below, as they may provide useful informations when troubleshooting issues.

    I’m going to resolve and close this issue for now.

    Thanks,
    -Matteo

  18. Regex

    Hello,

    Would it be possible to have a natively function to test a regular expression?

    thank you

    0 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 →
  19. Please add sparse column support to nonclustered columnstore indexes

    Sparse columns are very useful for a star schema.

    0 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 →

    Upvotes: 1

    <=-=Jul 13 2017 11:01AM=-=>

    Thanks for your suggestion.
    Columnstores process data significantly differently from traditional rowstore tables, and I suspect there would be little to no difference between the way that a columnstore would process a sparse column vs how it would process a NULL value in the column. Columnstores already compress out duplicate values from columns as part of their compression functionality.
    Is there a benefit to your queries from having sparse columns?

    <=-=Oct 10 2017 8:48AM=-=>

    We switched to clustered columnstore, pls close this issue.

  20. Replication for SQL Server on Linux

    We currently run our application using on-premise SQL servers defined as subscribers.
    There is a plan to add client from Linux to run with one of the subscribers.
    If SQL Server 2017 on Linux had a replication we would install instantly.

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

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base