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. SSMS 17.3 excessive memory usage

    SSMS consumes large amounts of memory & CPU, even when idle. Disabling intellisense has no effect

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

    We’ll send you updates on this idea

    archived  ·  8 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. SQL Management Studio strips stored procedure comments when connecting with Column Encryption Setting Enabled

    When connecting to SQL Azure using the "Column Encryption Setting = Enabled" connection setting (in order to use Always Encrypted), any ALTER PROC statement strips comments and reformats the submitted SQL when saving the SP. When connecting to the same database WITHOUT that connection setting, stored procs can be saved as expected, including comments and user formatting.

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

    We’ll send you updates on this idea

    4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. Schema not reported in the ERROR_PROCEDURE function

    When an error is raised by the error handler, the name of the trigger/procedure is reported by the ERROR_PROCEDURE() function. However, it does not include the schema.

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

    We’ll send you updates on this idea

    archived  ·  2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. Delete rows from a temporal history table

    I can see why deleting records is not possible for a temporal history table. However I have to implement a system which can due to GDPR compliancy. Currently I'm using a transaction to disable system versioning, delete the necessary records and enable it again. However turning system versioning back on causes timeouts when dealing with tables with millions of records.

    Is it possible to add an option, which can even be defaulted to off, to allow deleting records from a temporal history table?

    4 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 →
  5. Increase Ram Memory Limit in SQL 2014/2016 Standard to 256GB and Core support.

    Hello, SQL Standard's RAM limit of 128GB is aging fast. Please allow both versions to support 256GB of ram. MS SQL Enterprise often prices Microsoft out of the market with newer tools due to performance limitations (ram limits, core limits etc) and feature limits (which are not better with 2016 R1 such as columnstore indexes).

    Please "adjust" every few years the limitation. A bump from 128GB to 256GB for 2014/2016 Standard Ram support would be helpful while not extreme.

    The same with cores which are extremely limited in standard. "24 cores" is rare, please bump this to "4 sockets or…

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

    We’ll send you updates on this idea

    archived  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  6. UserVoice indeaquate for SQL Server requests/needs.

    For SQL Server support/requests/wishlist/complaints, this Uservoice site is grossly inadequate!
    The problem is that for such a long-lived platforms like Office and SQL Server, requests for familiar/repeated items over time (like "Source Control" for one very good example) yield worthless or long-irrelevant results because the response from MS for requests on/about previous versions of the platform/product/tools are simply ignored or left open - many from 5+ or 10+ YEARS AGO.

    Seriously, I have a problem with something like the current version of SSMS, on "Source Control" and any search here turns up topics for discussion that are still open and…

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

    We’ll send you updates on this idea

    archived  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. sergvasiltsoff@hotmail.com

    Seems we have strange error 41332 "Memory optimized tables and natively compiled modules cannot be accessed or created when the session TRANSACTION ISOLATION LEVEL is set to SNAPSHOT" but "WITH (SNAPSHOT)" table hints works (except snapshot isolation level) for memory-optimized tables.
    Looks a bit strange for me and blocks some implementations.
    Repro is very simple - we need a memory optimized table (durable or not) and attempt to select data using "snapshot" isolation level.

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

    We’ll send you updates on this idea

    archived  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  8. Indexed Views - Option for Delayed Seperate Index creation Process - Akin to Full Text Indexing

    Indexed Views would be a fantastic feature � if I could ever use them!
    Unfortunately Microsoft�s implementation of these has so many restrictions on their creation � that I can�t use them in the real world.
    I need highly normalised narrow tables in order to support data integrity and prevent update anomalies.
    I would like to join these automatically by the system, into entity based views that are easy to understand for users � and fast for them to query � without the huge hassle, expense and risk of data anomalies, inherent with creating and maintaining a data warehouse and…

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

    We’ll send you updates on this idea

    archived  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  9. Changing the report parameter name doesn't change the parameter name in related cascaded parameter datasets

    When you create an analysis services report with multiple parameters using the Visual Studio report builder, first of all it FORCES you to use cascaded parameters (bad assumption). Then, if you go to the report parameters and change the name of one of the parameters, it does not change that parameter name in all the datasets that it created for your other parameters that have a dependency on it. As a result, the report won't build and you have to manually update the MDX query in each parameter dataset.

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

    We’ll send you updates on this idea

    archived  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  10. SSRS 2008 export formulas to Excel

    As per books online - http://msdn.microsoft.com/en-us/library/ms143380.aspx , support for exporting RDL expressions to Excel as formulas has been dropped in SQL 2008.

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

    We’ll send you updates on this idea

    archived  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Cannot debug script component

    Cannot debug a script component, this is contrary to BOL
    Debugging a Script Component
    To debug the code in your Script component, set at least one breakpoint in
    the code. You must close the VSA IDE to run the package. However, when
    package execution enters the Script component, the VSA IDE reopens and
    displays your code in read-only mode. After execution reaches your
    breakpoint, you can examine variable values and step through the remaining
    code.

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

    We’ll send you updates on this idea

    archived  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. Sql Server managment studio for Mac Os

    Are there plans for SSMS in Mac Os. It will be grate if there was as version like that.

    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. 建议优化windows服务器下安装.net

    用你Windows系统就是为了轻松方便的点点点来操作,现在安装一个sqlserver需要安装.net3.5,安装3.5提示的问题搞了我大半天没搞好,网上查找的都是各种命令设置,用命令行操作我为啥不换linux?你以为全部公司都是互联网公司?离线安装个net3.5exe搞的麻烦一批。不能搞的操作点点点?

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

    We’ll send you updates on this idea

    archived  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  14. Resultgrid in Azure Data Studio

    Separate the ResultGrid from the editor in terms of styling. I would like a white grid with a dark theme editor.

    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 →
  15. Please stop SSMS from "Expire". That is so annoying. Its already free to download

    Please stop SSMS from "Expire". That is so annoying. Its already free to download

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

    We’ll send you updates on this idea

    archived  ·  0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. SSMS 18.6 Crashes on Startup

    18.6 will launch past the splash screen and then immediately crash with no error message. I have removed SSMS, Visual Studio, and SQL Complete and reinstalled only SSMS 18.6 fresh and the issue persists. I also could not run 18.5.1.

    I have tried every method from stackexchange and various blogs and nothing is successful. The only way I can run SSMS is to install 17.9.1. I am happy to provide event viewer error details if someone can help me troubleshoot.

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

    We’ll send you updates on this idea

    archived  ·  3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  17. The coding for see.exe.dwn

    upload the main data to a backup backup sever so it is accessible only through the code I will upload I the next data set.

    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. RID Lookup to Heap with non-unique index should not have Compute Scalar

    There are sometimes good reasons for a table to be a heap. Example, when no single index gets more than 20-25% of accesses. In theory, the RID Lookup to a Heap is less expensive than the Key Lookup to a clustered index. Then it is better for 100% of query plans to involve the Lookup to heap, instead of 75-80% having a Key Lookup.
    But I noticed that there is a Compute Scalar operation following the Index Seek (Nonclustered), but before the RID Lookup when the index is not unique. In actual execution, this doubles the true cost of the…

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

    We’ll send you updates on this idea

    archived  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  19. dark mode

    Dark Mode is not anymore available in SSMS 18 GA !

    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 →
  20. Why has operator precedence changed in 2005?

    There is an old connect item (id 127183, I cannot find its status), and a question on here (https://feedback.azure.com/forums/908035-sql-server/suggestions/32912443-unusual-operator-precedence). The problem/bug/feature is that something like SELECT -100/-100*10 gives an unexpected result (0 rather than 10). This is due to the fact that the unary - operator is given the same precedence as the binary - operator. This behavior is (somewhat) documented, but still unexpected, as most (all?) other programming languages give unary operators a much higher precedence. In SQL Server 2000, unary operators did have a higher precedence. Why was this changed? And will it be changed back?…

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

    We’ll send you updates on this idea

    archived  ·  0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 41 42
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base