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. Why is it so hard to reduce a database disk filesize?

    Today it is quite hard and many steps are involved in shrinking the disk-footprint of a database and often when you try the options in SQL management studio the effect is now what you desired.

    In the SQL manager there's two options, Shrink file and shrink database..... and within the two options there's plenty of different options. and some options are a bit unclear/fuzzy what they mean and how they actually do work.

    Sure, that's great with options for the "power-user", but why do I need to shrink each file individually? that's alot of unecessary clicks....

    So, my point 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 →

    Upvotes: 0

    <=-=Nov 1 2006 7:15AM=-=>

    Graphical presentation of freespace and frag could be handy. As regards “shrink everything”, that seems to covered by DBCC SHRINKDATABASE. I think the idea of a wizard would have very limited appeal because shrinking would/should be a very rare occurence in nearly every case.

    <=-=Nov 1 2006 5:52PM=-=>

    Thanks for the feedback. We will look into this issue for the next release of SQL Server. We will see if we could improve shrink functionlity and supportability and/or GUI.

  2. localize rfeport parameters

    To make a multilingual Portal with Report Services the Parameter Prompts have to allow expressions like the rest of a report. A secound idea would be a manual override of the language settings in the report manager. Because if you are on a foreign Computer by a client or a public station you cant adjust the language settings of the IE.

    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

    <=-=Nov 9 2006 6:49AM=-=>

    We will be addressing this issue (parameter prompts as expressions) in the next major release of Reporting Services.

    <=-=Nov 9 2007 8:21AM=-=>

    I am VERY happy to hear that this will be resolved. This is a huge issue on European market with countries were several languages are used. Basicly we had to build a tool that creates translated versions of rdl files. Everything else on SSRS2005 we could localize using custom assemblies, and in case of Report Manager, some creative use of .NET reflection (because one can’t create new satellitte assemblies for different languages for Report Manager). Unfortunately this method of reflection did not work for report parameter prompts.

  3. New Compressed DataType

    Hi

    When storing large amount of text/binary data in the database it is stored very inefficient and disk space-inefficient.

    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

    <=-=Oct 30 2007 6:41PM=-=>

    Katmai does not support it. Work-arounds for SQL Server 2008 are

    (1) store LOB as filestream on a compressed disk

    (2) compress LOB in the application

    <=-=Jan 15 2012 11:42AM=-=>

    closing it as a duplicate of another connect item with feedback id 649501

    thanks
    Sunil

  4. RPC:Completed event should show both input and output value when used with output params

    Currently, the RPC:Completed trace event shows only the output value when used with output parameters:


    declare @P1 int
    set @P1 = 5
    exec mySP @myParam = @P1 output

    select @P1

    In this case, "5" would be the output value, rather than the input value -- so this script really does not make sense. To be as useful as possible, the event should output BOTH the output and the input values.

    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

    <=-=Oct 23 2006 11:28AM=-=>

    Hi
    Thanks for the suggestion. We will consider this for implementation in future release of SQL Server.

    - Christian Kleinerman

    <=-=Jan 18 2013 4:29PM=-=>

    Hello Adam,
    I am closing out this old request. We will not be looking at this.


    Umachandar, SQL Programmability Team

  5. New Mining Algorithm: Ensemble Model

    Add a new mining algorithm called "Ensemble Model" which can be used to create a mining model based upon other existing mining models. The source mining models would have to have identical (or at least overlapping) predictable fields.

    Multiple models could be used in a number of ways, most of which are enumerated in "Mastering Data Mining" by Berry and Linoff around page 216. For instance, one way multiple models can be combined is by voting. If both models give the same prediction, the probability of that prediction from the ensemble model is higher. Or another way to combine multiple…

    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. Enable drillthrough on calculated measures

    Today you can drillthrough only the "real" measures. It would be better to drillthrough also the calculated measures. To do that, it would be useful to be able to define an MDX expression that defines a subcube (of "real" cells and not calculated ones) to be used for drillthrough in place of the original selection/cell.

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

    <=-=Oct 12 2006 6:54PM=-=>

    Thank you for this feature suggestion. We’re going to consider it for a future product release.

    <=-=Sep 25 2012 12:53PM=-=>

    any update?

    <=-=Jul 10 2013 9:40AM=-=>

    Drillthrough is ludicrously “hassle-y” as it is (e.g. when compared to ssas2000), and considering one is at times forced to create calculated measures passing real ones through unchanged just to be able to present them in an ordering and grouping the customer demands. Main mitigation: As it is almost imossible to control field ordering and impossible to provide user-friendly field names, discouraging clients from wanting drillthroughs is the way to go…

    <=-=Apr 2 2014 5:19AM=-=>

    Any update!??

    <=-=Mar 10 2015 9:01PM=-=>

    Just wanna know when will add this feature

  7. Add filters and default members to perspectives

    It would be useful to select member filters and default members on each single perspective.
    Another important thing could be to be able to rename a dimension/attribute/measure into a perspectve (then you need to add perspective to translation system, so it would be good to translate only the changed descriptions).

    I have a lot of scenarios where perspective is useless without all these features. A way is to create linked measure groups and linked dimensions, but when you already built a single cube it is not so easy (it is better to start with small cubes and then link them…

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

    <=-=Oct 12 2006 6:56PM=-=>

    Thank you for this feature suggestion. We’re going to consider it for a future product release.

    <=-=Oct 22 2006 2:06AM=-=>

    I would also like to have perspectives related to security/roles in SSAS.

    Regards
    Thomas Ivarsson

  8. Database Recovery - Perform Rollback To A point in time

    If a database is in fully logged mode it would be nice when a user does something really stupid to be able to rollback the database to a point in time without having to restore the full backup and then use the transaction log backups to roll forward to that point in time.

    I have in mind something similar to the functionality in db2 or the flashback feature in oracle which quickly allow you to get back the data the user has mucked up without having to perform a full restore of the database and the required transaction logs

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

    <=-=Oct 11 2006 10:09AM=-=>

    Thanks for your feedback. We’ll consider this for future releases of SQL Server. In the mean time you may want to take a look at Database Snapshots. They provide some of this capability, though you will need to create them up front.

    Thanks again,

    - Christian Kleinerman

  9. Improve error messages with missing semi-colons

    The requirement for all service broker statements to be seperated from previous statements by semi-colons leads to numerous "incorrect syntax near <command>" errors during development.

    The error is far from helpful especially in the situation in which a IF statement is used with a begin end block. In this situation the semi colon needs to follow the END statement. This in itself is confusing.

    Can you please enhance the error message such that when a semi-colon is missing preceeding a statement that the error message states that a semi colon may be required

    The error messages in SQL 2005 have…

    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. SSRS - Adding "LIKE" filter criteria to report builder

    The Report Builder application which is bundled with SSRS includes a variety of filter criteria, including "in a list", "contains", etc. There no ability to filter with wildcards and a "LIKE" statement.

    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

    <=-=Sep 15 2006 4:27PM=-=>

    Thank you submitting this request. Report Builder has a “contains” operator for string fields but no capability for wildcards today. We will consider this request for a future release.

    <=-=Nov 4 2007 9:21PM=-=>

    Bring considering for post RS 2008 release.

    <=-=Jun 13 2013 10:28AM=-=>

    Does this: http://technet.microsoft.com/en-us/library/cc627464.aspx mean it is “Fixed”?

  11. SSRS - wildcard support in expressions

    Sql Server reporting services has a variety of built in functions used to create expressions and formulas. http://msdn2.microsoft.com/en-us/library/aa337348.aspx

    The text functions do not support wildcard matches, particularly the FIND function.

    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. TOP-Level XQuery

    Currently, any medium to advance level XML query requires at least knowledge in 3 different languages, and they are all mixed inside the same code churn: T-SQL, XQUERY, XPATH.
    This reminds me a lot the old days when we had ASP pages with HTML, XML islands, VBScript and server-side code together on the same page.

    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 →

    Upvotes: 2

    <=-=Aug 30 2006 5:15PM=-=>

    Dear Adolfo

    Thanks for your valuable feedback. We will look into your request and consider it for one of the upcoming releases based on general customer usability and other prioritizations.

    Best regards
    Michael

    PS: Please do not forget to vote and indicate your priority.

    <=-=May 19 2008 7:49AM=-=>

    As you know, the XQuery expressions currently only operate on a single XML datatype instance and not across a set of XML documents. While you could theoretically stuff everything into a single XML row and column, and simplify the XQuery expression, the resulting system would not scale well (too many locks on inserts) and would not perform well. Also, as Adolfo explains, to do queries over different XML documents, the query is mixed between XQUERY, T-SQL and XPATH.

    There is real feature to develop for SQL 08 and it is a concept of…

  13. Add a Trim function

    There is no Trim function, instead we need to call LTrim(RTrim()) each time we want to perform this operation.

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

    <=-=Jul 26 2007 11:32PM=-=>

    We are currently looking at this to see if it fits for the next SQL Server release. Until it’s supported, please use LTRIM/RTRIM together as a workaround.

    <=-=Apr 30 2009 6:27AM=-=>

    Why do a work-around when people clearly need this. Gosh, FIX IT!

    <=-=Oct 19 2009 3:38AM=-=>

    It’s really annoying the amount of little helper functions we’re expected to manually implement. Why make life painful for developers? I’d definitely like to see a Trim function added, along with some other common basic ones like string padding, etc.

    <=-=Feb 3 2010 9:46AM=-=>

    While a TRIM function would be nice, it would be even better if the TRIM function would include a parameter for the character to be stripped (and to have LTRIM and RTRIM modified to support the same parameter). Often I deal with strings that have been padded with zeros. Converting to…

  14. Comment: -- + space

    In previous versions of query analyzer a comment would be two dashes and a space. This allowed me to quickly isolate a line by placing the cursor at the last position (in the line), typing ctrl + shift + home + right arrow key. This quick and efficient key combo allowed for quick line execution w/o disrupting the flow or the current code set that is being coded/debugged. Now not only does Management Studio not add the space, but if I open a file created from SQL 2000�s query analyzer (which has the space) the key-combo described above does not…

    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

    <=-=Sep 11 2006 3:13PM=-=>

    Thank you for your feedback. We will consider this for a future release of SQL Server.

    <=-=Oct 29 2007 11:34AM=-=>

    We will manage this request combined with Connect Feedback ID 275503.
    We do understand the need and value of this feature. Currently, there are multiple projects that could provide features that help users validate and debug Transact SQL script such as Intellisense (client error flagging) and T-SQL Debugger. Selective execution (statement / batch) via shortcut keys would be a simple approach as a Intellisense feature.

    Thanks,
    -Eric

  15. All Databases are Listed in SSMS

    I am a user of a one database server. when I loged-in from that user to the DB server, all the databases are listed in the left hand side pane.

    In Query Analyser in SQL Server 2000 only the databases which this user can access is shown.

    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 →
  16. Transact-SQL ???? ??????????? IN ????????

    Transact-SQL ???? ??????????? IN ??????????
    ??????????? IN ???Oracle?PostgreSQL ??????????

    ????????????????
    http://oga89.cocolog-nifty.com/blog/2006/07/sqlserver1afc.html

    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

    <=-=Dec 13 2007 3:26PM=-=>

    My apologies for the late reply. Thanks for your feedback. We will consider adding multiple column references in the IN clause for a future release.

    We would appreciate if you could indicate with a vote how important this functionality is for you.

    Best regards
    Michael

    <=-=Jul 22 2008 2:13PM=-=>

    Hi,
    I am resolving this request as a duplicate of another one in our system. We will look at adding row constructor support that will enable the functionality you are seeking.

    Thanks
    Umachandar, SQL Programmability Team

    <=-=Mar 23 2010 1:33PM=-=>

    Hi,
    This feedback item has been resolved as duplicate of one below:

    https://connect.microsoft.com/SQLServer/feedback/details/262284/row-types-and-constructors-sql99-features-t051-f641?wa=wsignin1.0

    Thanks
    Umachandar

  17. XML: need triggers for XML updates

    Need an ability to define a trigger on an XML update. The trigger will modify other data within the same XML document.

    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 →
  18. XML: Computed attributes and ability to index them

    Need to be able to express a value of an attribute on a node as a function of other data in the same XML document.

    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

    <=-=Aug 17 2006 4:50PM=-=>

    Dear Dmitri

    Thanks for your feedback.

    Do I understand your request correctly in that you would like the ability to define active XML views over XML documents (and relational data) using XQuery and FOR XML so that changes to the underlying data will be reflected in the documents? Also the ability to index these views?

    Thanks
    Michael

  19. XML: Ability to index selected attributes

    We do not want to incur the penalty of index update for ALL attribute writes. Need to support both indexes on attribute value, as well as element + attribute value (the latter is needed for doing attribute-based searches within a subtree).

    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. Diagram Copy and Paste

    We should be able to copy and paste tables from Diagram (all of them: Database, Olap, Data Source Views...) into other diagrams and 'dumb' targets like Word.

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

    <=-=Apr 16 2007 1:16PM=-=>

    You can right-click on the database diagram and choose “Copy to Clipboard” and then paste it in Word.

    <=-=Jan 14 2008 11:53AM=-=>

    Thanks for reporting this issue. We will consider this for a future release.

    Regards,
    Robert Zare

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base