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. Replacing a table with a named query break the model

    Replacing a table with a named query will result in a bunch of error messages like the following one:

    Error 1 The Nullable property for the Attribute 'SomeColumnCD' is false, but the referenced Column 'dboSomeTable.SomeColumnCD' is nullable. The Nullable property for the Attribute must match the nullability of the Column. SomeReportModelReportModel.smdl 0 0

    (several errors below...)

    Although i just replaced the table with named query, I would expect (as replacing a table with a nq normally means that you want to filter the table in some way, either horizontal or vertical) that the meatdata would stay…

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

    <=-=Mar 23 2007 1:51PM=-=>

    How do you work around the issue of table column attributes, such as nullable, not being set in a named query that uses the table?

    How can I change the column attributes of the column returned by the named query?

    <=-=Mar 26 2007 3:21AM=-=>

    THe only workaround was to set them manually.

    <=-=Oct 11 2007 11:59AM=-=>

    Thank you for reporting this issue. We will consider fixing it in a future release.

  2. Autogeneration of a single entity

    Autoregeneration does not work the way people think of. Clicking on autogenerate for a particular entity let me assume that only the one entity which was clicked by me is regenerated (as the first wizard page also shows me only the clicked entity). But although only one entity is clicked, the whole process of regenerating all attributes / aggregates of every other entity is started. So what is the difference if I click on autogenerate for the whole model rather than clicking on a single entity ?

    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

    <=-=Apr 5 2007 2:37PM=-=>

    Thank you for this feedback. When regenerating an item, we review the roles and related entities also. We will review this rquest and see if there are ways to change this in a future release of Model Designer.

    <=-=Oct 25 2007 2:09PM=-=>

    Thank you for this feedback. When regenerating an item, we review the roles and related entities also. We will review this rquest and see if there are ways to change this in a future release of Model Designer.

  3. Autogeneration is misleading

    Autoregeneration does not work the way people think of.

    If you create a model based on a datasourceview using the wizard, you can select whether you want to include either attribute / attributes etc. Let�s assume that you only select attributes in the first place. Afterwards (after creating hierarchical folders, tuning the model, setting the properties etc., doing a bunch of work) you notice that you will also need the aggregates on some attributes. Launching the Report Model wizard again will bring you the selection screen for choosing the aggregates, but after repopulation no additional aggregates are created.

    Is there…

    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 →
  4. Moving many items to folders is very slow

    Moving items to folders is really slow. If several entities are selected, e.g. 40, the speed of moving these to a folder is dramatic slow. Although the speed increases with each and every folder, there is room for speed improvement. We only have a small entity model with about 350 tables. I would assume that having more than this, or moving more than 40 would kill the whole process.

    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. Move perpectives out of the model (or side by side)

    One weakness of the current project model for the report model is, that you can�t really work on one model with more than one person. We used to establish one common model where different perpectives define the way the user will have a look on the data. Cause of the perpectives being part of the model not of the actual project as a separate file / object, only one person can work at a time on the report model. This may lead to the point where you duplicate models, only to work with more than one developer on it, leading…

    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

    <=-=Apr 5 2007 2:33PM=-=>

    Thank you for the suggestion. We will consider adding this feature in a future version of Model Designer.

    <=-=Oct 25 2007 1:38PM=-=>

    Thank you for the suggestion. We will consider adding this feature in a future version of Model Designer.

  6. A Better more useful Data Driven report manager

    It's very annoying having to pry into report server logs for data driven reports.

    It would be nice to simple click on the subscription and view the individual log for each email that went out and have the ability to re-do reports that had a problem by clicking a few check boxes and force send now.

    as of now:
    A) I cannot tell what went wrong in a subscription with an error like this:
    Done: 3 processed of 3 total; 3 errors.
    I need at least the ability to see who didn't get the email, was it the server or…

    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 2007 1:42PM=-=>

    Wasn’t there a set of sample reports available from Microsoft that would give you usage statistics for reporting services? I can’t even find that in the new SQL 2005 report pack.

    <=-=Oct 11 2007 9:37AM=-=>

    Thanks for the feedback. We agree that the ability to monitor and manage subscriptions could be much improved. Because of work in other areas of the product, it looks like we will not be able to make any changes in this area for SQL 2008. However, improvements in this area are high on our list for the follow-on release.

  7. Support for XML Paper Specification (XPS) Output Format

    Please provide the capability to render to XPS documents directly from SQL Server Reporting Services (SSRS). We are standardizing on XPS for our workflow and document management but many of the documents we need to work with are generated by SSRS and right now there is no good option to create XPS documents other than to use the XPS Document Printer driver that gets installed with .NET 3.0. While this works for one at a time printing it doesn't offer us the option of automation or using schedules to generate the XPS documents.

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

    <=-=Feb 14 2007 9:42AM=-=>

    Thank you for taking the time to request this feature. We will consider adding this functionality in a future release of SQL Server Reporting Services.

    <=-=Jun 27 2007 5:34AM=-=>

    This would be a welcomed addition to reporting services.

    <=-=Nov 19 2007 7:20AM=-=>

    Today I was notified that this issue has been changed from closed to active. Does this signal that there is some news about XPS support from SSRS?

    <=-=Jan 28 2008 2:38AM=-=>

    Customer has requested this feature. This would drive their adoption of SQL Server, and prevent a move to a competitor technology.

    <=-=Jan 8 2009 12:04PM=-=>

    This is the #1 item in choosing to utilize PDF or XPS. It also is a consideration as to whether or not to use Reporting Services or another technology.

  8. OVER clause enhancement request - TOP OVER

    SQL Server 2005 introduced only partial support for the OVER clause. It is our strong believe that a more complete implementation of the OVER clause should be prioritized highly in consideration for future enhancements in SQL Server. A more complete implementation of the OVER clause can help in solving many common business problems with simpler, more intuitive, and faster solutions than available today and also substantially reduce the need for cursors.
    The following paper details the feature enhancement requests:
    http://www.insidetsql.com/OVERClauseandOrderedCalculations.doc
    The current feedback item addresses the OVER clause enhancement request - TOP OVER, discussed in the…

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

    <=-=Apr 3 2007 2:10AM=-=>

    TOP OVER” can be written as this in SQL Server 2005 ( top 3 with each group)

    SELECT [Type],
    Number,
    RecID
    FROM (
    SELECT [Type],
    Number,
    ROW_NUMBER() OVER (PARTITION BY [TYPE] ORDER BY Number) AS RecID
    FROM master..spt_values
    ) AS x
    WHERE RecID BETWEEN 1 AND 3
    ORDER BY [Type],
    Number

    <=-=Sep 11 2007 4:49PM=-=>

    Note: This feedback is for a series of requests for OVER clause enhancement. These items will be looked at both individually and together in future feature design.

    This feature unfortunately did not fit into our schedule for SQL Server 2008. Based on customer input, we had prioritized ORDER BY for aggregates and the ROW/RANGE feature, but in the end decided that in order for this feature to be truly useful, we needed to implement more functionality than time would allow. This is…

  9. AdomdServer.MDXValue needs ToObject() method

    In an MDX sproc, if I have an MDXValue object, I can't tell what it's underlying type 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 →
  10. FOR XML PATH/ROOT -- needs to handle variables

    The Path and Root options of FOR XML need to be able to support variables. It seems strange that I can only supply a litteral...

    The ideal thing would be to support an NVARCHAR for the name of the node/root node.

    DECLARE @pInnerName NVARCHAR(50)
    DECLARE @pOuterName NVARCHAR(50)

    SET @pInnerName = 'Inner'
    SET @pOuterName ='Outer'

    SELECT
    col1 "col1",
    col2 "col2"
    FROM
    tmpTable
    FOR
    XML PATH(@pInnerName),
    ROOT(@pOuterName)

    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 9 2007 3:52PM=-=>

    Dear Cedric

    My apologies for the late reply. We have received your request and may consider it in a future release as part of a more general parameterization of queries. The current recommended workaround is to use dynamic SQL.

    Best regards
    Michael

  11. Style toggling in Reporting Services

    I could not do it on the textbox because if I do it on the textbox - the effect will be applied to all member of the group and it will make them expand at the same time. and collapse at the same time.

    What I need to do in this case as I showed on the example below that user want to click on specific member of the group and it will make that member only become Bold when just that member of the group being click on and all other member of the group still in collapsed state.

    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. Online index rebuild for tables with text, ntext, varchar(max), nvarchar(max), etc

    It would be very handy if when using the ONLINE = ON flag set for an ALTER INDEX command if there is a TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX), IMAGE, VARBINARY(MAX) or XML datatype column it automatically switches to ONLINE = OFF.

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

    <=-=Jan 3 2007 2:45PM=-=>

    Hello,

    Thanks for your suggestion. We are looking into removing the current restrictions on online index build in a future release.

    Sameer Verkhedkar
    SQL Server Engine
    [MSFT]

    <=-=Aug 30 2011 1:23PM=-=>

    This issue has been fixed in Denali, the next release of SQL Server

  13. Maximum Transaction Length Setting At Server Level

    Long running transactions are often indicative of some form of coding error but they can impact on other users of the system.

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

    <=-=Jan 19 2007 1:26PM=-=>

    I would also be happy for it not to apply to anyone in a system admin role.
    Regards,
    Greg

    <=-=Jan 19 2007 1:26PM=-=>

    I would also be happy for it not to apply to anyone in a system admin role.
    Regards,
    Greg

    <=-=Feb 5 2008 2:53PM=-=>

    Thank you for your suggestion.
    We will consider this for a future release. This is not a simple feature to implement, as there are legitimate cases for very long-running user transactions, and canceling them would cause significant loss of work.

  14. Allow pre-calulation of calculated measures at processing time

    I have a calculated measure which is core to the analysis of my cube. The calculation is done over a large amount of data. Currently, the measure is only calculated when I run a query and it runs very slowly... in the order of minutes on my development machine, which to me defeats the object of having OLAP and calculated measures. I might as well have done the calculation in the MDX query.

    If the calculation was wrong, this would then be visible as an error during processing, rather than at query time.

    Or could we be allowed to specify…

    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 →
  15. SQL Agent Should Notify on Step Failures

    A critical need is to be able to have SQL Agent report on step failures, not just job failures.
    I have several jobs in the BI world that have multi-steps, but they are not dependencies. So if one fails, I should be notified, and still have the other steps execute.

    Right now, the only recourse is to create many different jobs, which is a maintenance nightmare, or create individual steps to manually send an email. This too is very cumbersome.

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

    <=-=Dec 11 2006 3:09PM=-=>

    Thanks for letting us know the frustrations you experience looking for a more granular notification of errors in your agent jobs. I have put your suggestion on the list of architectural changes we will consider as we lay out our next major release.

    In the meantime, you might consider using SSIS, in particular their event handler, to send the email you want on the failure of any individual task in the package.

    Thanks again,

    jkh

    <=-=Oct 31 2008 10:18AM=-=>

    Hi,

    We are considering it for the next release,

    Thanks,

    Gil

    <=-=Jul 22 2009 1:54PM=-=>

    Thank you for your feedback; unfortunately we won’t be fixing this for our next major release. You can consider using SSIS and their event handler or catching the errors yourself and making a call to sp_send_dbmail.

    Thanks,

    Amy Lewis

  16. Security enhancements

    Consider:


    1. Allowing expression in the allowed/denied sets to void the filter as explained in more details here (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=984244&SiteID=1).


    2. It could be nice if SSAS supports [Hierarchy].AllowedMembers/[Hierarchy].DeniedMembers to address cross-dimension security scenarios. Even better, it could have been nice if there was an option to apply a global allowed set filter (similar to setting a filter in the cube browser) which will slice the cube across all dimensions. More details here (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=984176&SiteID=1)


    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. Moving Database Files

    The only way to move a file without bringing the dataabse offline is to:

    1) add a file to the filegroup
    2) shrink the existing file, usin gDBCC SHRINKFILE with EMPTYFILE
    3) removing the old file

    This results in 100% fragmentation. There should be a way to move a file, keepin gthe DB online and not fragmenting the objects contained in the file.

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

    <=-=Dec 1 2006 5:12PM=-=>

    Thanks for the feedback. This is a known issue. In SQL Server 2005, we add this increasing fragmentation information in BOL for DBCC SHRINKDATABASE and warn customers not to run shrink unless it is absolute necessary.

    We will address this issue in future releases.

  18. KJTAP-CyberSavvy: Report Manager- Report Parameter Page

    When accessing the parameters page in Report Manager the parameters do not work as they would when running the actual report. This makes it more difficult to change the default parameters for specific customers and also makes it more difficult for cusotmers to create their own linked report using parameters different from the deployed defaults.

    90% of our parameters are guid values which confuse customers when they see them in the parameters page as they are expecting to see the labels tied to the parameters as they would in the Report or Subscription page.

    Scenario 1:
    This causes a delay…

    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

    <=-=Apr 8 2011 7:02PM=-=>

    Thank you for filing this DCR Deborah.

    After further investigation we have decided not to consider adding this feature to SSRS’s SQL Server 2008 or SQL Server 2008 R2 releases. Having said that, we will consider this during the planning for the next SSRS major release.

    HTH
    Prash

  19. PowerPivot - Minor Suggestion - Add Explicit Menu Option for SharePoint List Data Feed Import

    Many people don't realize that you can import SharePoint lists in PowerPivot via a data feed. One major reason for this lack if discoverability is that, unlike Reporting Services, a SharePoint data feed option is not listed in the From Data Feeds menu.

    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. Week number ISO 8601 in Reporting Services

    Reporting Services expression engine does not support ISO8601 week number.

    DatePart(�ww�, Fields!MaDate.Value)

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

SQL Server

Categories

Feedback and Knowledge Base