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. Reinvestigate tempdb, it's issues and how we use it as a scratch pad

    The tempdb system database, as we all know is becoming "overused", and thus is more frequently becoming a bottleneck.

    I know we are recommending multiple data files, trace flags, etc in white papers dedicated to this subject. Those recommendations do improve matters, but ultimately we can still have a bottleneck there. Think about all the activity in the transaction log being generated due to row-versioning, sorting, online DBCC checks, temp tables, etc, etc, etc. And the database catalog having to be maintained, etc.

    We also have the commonly documented issues of collation problems and TDE.

    All these issues are becoming…

    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 →
  2. 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 →
  3. cannot access native client configuration

    Hi,

    We typically install only one SQL server which is to be accessed by one or more clients.

    Our software applications are using the 'SQL native client' to access the SQL server database. So we only install the 'SQL native client' for these systems. However, now we cannot review, modify or access the native client configuration as can normally be done by running the SQL server configuration manager. But the server configuration manager gets only installed when installing the SQL server itself, not when installing the client.

    We need to be able to configure the 'SQL native client' configuration when…

    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

    <=-=Dec 17 2009 6:12PM=-=>

    Thank-you for reporting this enhancement recommendation to us. We are currently investigating what options are available and how we can enhance the user experience.

    To help us identify the configuration experience you are looking for, when you say that you want to configure the SQL Server Native Client, are you referring to something along the lines of cliconfg.exe? Or, are you referring to ODBCAD32.exe?

    Regards,
    Jimmy Wu
    Microsoft SQL Server

    <=-=Dec 18 2009 12:03AM=-=>

    Although I am not familiar with the tool cliconfg.exe, it looks like this tool is meant to be used for configuring SQL Server 2000/MSDE?

    What I need is a way to configure the way ADO connects to SQL server with the SQL native client 2005 or SQL native client 2008 if this client was installed by means of the the available ‘sqlncli.msi’ windows installer packages.

    - Is there…

  4. [SSRS2008] Serious improvement required for expression debugging

    Hello,
    I have the following expression for the default value of a parameter of type "Date":

    =CDate(
    CStr(
    Year(DateAdd("mm", -1, Now())) * 10000 +
    Month(DateAdd("mm", -1, Now())) * 100 +
    1
    )
    )

    It doesn't work and I have absolutely no idea why. When I render the report the only error message I get is:

    "An error occurred during local report processing. <parameter name>"

    Which is not much better than useless.

    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 →
  5. Logging Report Model usage in the ExecutionLog

    Currently, when Report Builder is used to access a published report model in reporting services (2005 & 2008) a usage record is created in the ExecutionLog reporting Services database table, however it does not identify the specific Report Model that was accessed - the ReportID in the ExecutionLog / ExecutionLogStorage table references the root-level item in the Catalog table regardless of which Report Model is accessed.

    The main problem with this is that because the specific Report Model being accessed is not recorded in the execution / usage log, there is no way of identifying which specific Report Models are…

    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 →
  6. Add data type to Properties window for plan operator

    When I look at the output list of a plan operator, the properties for a column under the Output list have Column (redundant?), alias, Database, Schema, and Table. I would like to also see data type here (and collation for string values). I am guessing it has been left out because it would be difficult to determine implicit vs explicit conversion, vs. data type of underlying column(s), but I think it would be useful to see this where possible so that we can quickly gauge why a scan went out of control (e.g. varchar vs. nvarchar, or collation a vs.…

    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

    <=-=Jun 29 2009 11:08AM=-=>

    Dear Aaron Bertrand

    Thank you for the feedback. The show plan xml and the properties window do not contain the datatype presently. We look at adding this field in the properties window. I have marked this issue for consideration by the product team.

    Thanks,
    -Karthik

  7. Enhance copy and paste package behavior to include assigning new IDs to new package AND all its components

    In Integration Services, copying and pasting packages to enable reuse does not currently assign a new GUID to the pasted/new package. Additionally, the pasted/new package componets also are not assigned new GUIDs.

    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 →
  8. Windows Fileshare Report Delivery

    Fileshare deliveries from subscriptions in Reporting Services require user and password. As an administrator to reporting services it would be helpful if a stored system account of sorts could be used.

    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: 6

    <=-=Dec 29 2008 2:37PM=-=>

    Thanks for filing this enhancement request through connect.
    We will consider incorporating this in a future release of reporting services.
    Thanks

    <=-=May 14 2009 10:36AM=-=>

    Another enhancement that I would like to see is that where users should be able to change the network credentials used in report subscriptions in one central location.

    Currently when users setup windows file share subscription for report they have to enter their network credentials. Now when the users network password changes they have to go to every subscription they ever created and set the new password. This is cumbersome and users are resisting users the product for good reason.

  9. Reporting Services Shared Subscriptions

    The Shared Schedule feature of Reporting services works really well. However the more we have worked with the tool we have come across the need for a new/additional feature.

    In a similar fashion the ability to manage "Shared Subscriptions" would help to manage delivery of multiple reports simultaneously. Email and file shares across multiple reports could be changed through one interface as opposed to every single report.

    This feature is key to departmental and functional reporting that is either sent to large distributions or consumed by other applications.

    Thanks!

    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 →
  10. Built-in Printer Delevry Method for SSRS

    I would like to suggest that a Printer Delivery Method should be standard in SSRS, in addition to the current File Share and Email Methods.
    Currently, there is some sample code for adding a Printer Delivery Method (with disclaimers) but is would be much better if SSRS came with such this Delivery Method built-in.

    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 →
  11. Securing SQL server against SQL injection attacks

    I have found that securing the following objects within SQL server can effectively stop most if not all SQL injection attacks. By default SQL logins are granted select access to the following: Sysojects, Syscolumns. If an SQL server login is denied select on these objects the attack it stopped in its tracks.

    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. Debugging in BIDS

    Can't debug code in BIDS. Can't set breakpoints in the Report's Code area. Can't inspect/watch the Expressions in a object to see why it's not working.

    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

    <=-=Oct 30 2008 9:15AM=-=>

    Thank you for using SQL Server Reporting Services.
    We woudl like to improve the coding/debugging expereince and we will investigate this for a future release but we do have to balance against the general report authoring features which a majority of customers use and wish enhancements for.
    Thank you for your time and your patience.

  13. Make code in BIDS a first class citizen

    Accessing a report's Code section or an object's Expression is too clumsy. Additonally, there's no Intellisense either. I might as well be editing the RDL in Notepad!

    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: 13

    <=-=Oct 30 2008 9:14AM=-=>

    Thank you for using SQL Server reporting Services.
    The coding experience is an area we would like to improve and we will investigate further for the next release. With that said there are a lot of other features/improvements customer would prefer over improving the coding experience.
    Thank you for your time.

    <=-=Dec 30 2009 6:23AM=-=>

    Agreed – a report’s custom code really should be editable in a normal Visual Studio code editor window with full Intellisense support.

    Similarly, when making references to custom code functions in an expression it would be a great help to have Intellisense support for the function.

    <=-=Nov 20 2010 12:03PM=-=>

    I think having something similar to SSIS .net script task would be ideal. I’m looking forward to Denalit CTP2 (with hopefully SSRS changes included!!)

    Regards
    Emil

  14. Make Subreport a page break-able object too

    I just developed a series of reports where 3 separate reports had to be rendered as a single report for the same group item. Although I worked around the issue by nesting groups off of the same parent and enabling a page break for each group; it would have been a much more natural solution for me to have simply checked a box on the subreport's properties telling it to do so.

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

    <=-=Oct 30 2008 4:15PM=-=>

    Hello,

    Thanks for filing this request. We may consider this for a future release. For now, an easy workaround is to put the Subreport inside of a Rectangle, and set the page break on the Rectangle.

    Thanks,
    Chris B.
    SQL Server Reporting Services

  15. EXPR labels in text boxes in SQL Reporting Services 2008 are not useful

    Reporting services 2008 now just shows <EXPR> for most of my reports. In the past you could actually see the beginning of the formula and know what you were looking at. Now you have no clue and you have to go to the expression box to find out whats in there. For example I no longer see the text box that use to say:
    =ReportItems!ItemWriterHidden.Value.

    Now it just says <<EXPR>>. This is a productivity decline because I now have to click the box, and open the expression editor for that place holder to know whats inside of the text box.…

    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: 19

    <=-=Oct 25 2008 11:27PM=-=>

    I would add that it takes too many mouseclicks to get to the expression editor. A simple keyboard shortcut, like F2 in Excel, would be fabulous.

    <=-=Dec 2 2008 10:00AM=-=>

    Thank you for providing this feedback. We will consider adding a mode to show the textbox expressions back to Report Designer and Report Builder.

    <=-=Dec 12 2008 11:45AM=-=>

    Reposting:
    Thank you for providing this feedback. We will consider adding a mode to show the textbox expressions back to Report Designer and Report Builder.

    <=-=Apr 6 2009 1:18PM=-=>

    I concur, a keyboard shortcut would be great!

    <=-=May 19 2011 2:15AM=-=>

    I agree, a keyboard shortcut would definitely help here.

    Also, because you cannot see the expression, it is not possible to utilise the multiple text formatting on a single textbox.

    <=-=May 29 2014 12:21PM=-=>

    In a complex report with multiple groups and conditional rows, taking…

  16. Intellisense for custom code

    It would be great to have intellisense for custom code.

    We are in the process of releasing a custom assembly to help development teams with common report writing issues. Developers have gotten so used to having the intellisense they can't seem to do without it.

    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

    <=-=Jun 19 2009 11:28AM=-=>

    Thank you for posting this feature request. We will consider adding intellisense for custom code in a future release of Reporting Services. Since you mention developers, I’m assuming that you mean we should integrate this into BIDS (Report Designer), not Report Builder. If not, please do clarify. Thanks.

  17. WAN compression option

    It would be a useful option to provide the ability to compress data on the fly for client connections, in a similar fashion to the encrypt option when you connect to a database. For example, from the client application you could connect with:

    Data Source=sqlserver;Initial Catalog=master;Integrated Security=SSPI;Compress=yes

    It would be a great ability for remote offices connecting into a central database server over a slow WAN connection and would result in cost savings for small businesses. Larger businesses would probably use dedicated hardware like PacketShaper (http://www.bluecoat.com/products/packetshaper/specifications).

    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: 13

    <=-=Oct 31 2008 9:51AM=-=>

    Thank you for the interesting suggestion. We will take this feedback into consideration in a future SQL release.

    In the meantime, I recommend you trying SQL Server 2008 running on Windows Server 2008, with the client preferably running on Windows Server 2008 as well. SQL Server 2008 takes advantage of TCP enhancements in Windows Server 2008 specifically targeted at large data transfers over WAN networks. Our testing showed significant reduction in transfer times.

    You can learn more about TCP enhancements in Windows Server 2008 at http://technet.microsoft.com/en-us/library/bb726965.aspx.

    Thank you.

    <=-=Nov 3 2010 12:40PM=-=>

    Your suggestion of using Windows Server 2008 assumes control over the client’s operating system, which you may not always have. Baking this feature directly into SQL Server and the SQL Server provider for ADO.NET would be much preferred.

    By the way, this issue duplicates the following suggestion:
    https://connect.microsoft.com/SQLServer/feedback/details/412131/enable-network-compression-compress-tds-stream

    Combining…

  18. Make UnknownMemberName and AttributeAllMemberName attribute properties instead of dimension properties.

    I think user-experience would improve if these two properties were associated with attributes instead of with the dimension.

    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 →
  19. Adding Database Mirroring Dependencies

    Currently database mirroring does not provide for inter-database dependencies. In many cases an application requires more than one database to function correctly on the same server. While creating high availability solutions for customers a common question is frequently asked? How many databases does your application require to function correctly and can your application work correctly if the databases were on separate servers? In many cases application can not function correctly on separate servers leading customers to SQL Clustering.

    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 →
  20. Auto update statistics triggered more often on tables with less than 500 cardinality

    Hi,

    One of my customers gave us the folowing feedback on the auto update statistics algorithm.
    THe algorithm is presented here: http://support.microsoft.com/?id=195565 :
    The basic algorithm for auto update statistics is:

    � If the cardinality for a table is less than six and the table is in the tempdb database, auto update with every six modifications to the table.
    � If the cardinality for a table is greater than 6, but less than or equal to 500, update status every 500 modifications.
    � If the cardinality for a table is greater than 500, update statistics when (500 + 20 percent…

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

    <=-=Nov 10 2008 11:15AM=-=>

    Dear Customer, thank you for the suggstion on how to refine the statistics refresh conditions. While keeping stats up-to-date is generally a good idea, refreshing stats too often may have adverse conditions on system perf, including plan recompilations. We will consider this suggestion for the next major release (after SQL 2008).

    Sincerely,
    Yavor A
    SQL Core RDBMS team

    <=-=Jan 30 2012 6:30PM=-=>

    Hello,

    To explain potential notifications. This item was resolved as a duplicate of another. Connect will hopefully pick it up. The item is NOT closed.

    Regards,
    Boris Baryshnikov.
    SQL Server Engine

  • Don't see your idea?

SQL Server

Feedback and Knowledge Base