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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Choosing columns for display in Table Designer

    Currently in table designer the available columns for creating tables are Column Name, Data Type, and Allow Nulls. It would be much easier to have certain columns such as Allow Nulls, Identity Column, Seed, and Increment also on those columns, as it would make my table development time faster.

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

    <=-=Mar 31 2006 8:20AM=-=>

    Quick update. We are placing this bug report under consideration for SP2.

    <=-=Apr 19 2006 11:32AM=-=>

    Thank you for your feedback – we will consider this for a futre release of SQL Server.

    <=-=May 12 2011 4:07AM=-=>

    Hi Derreck,

    We took a look at this bug along with several others recently. Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future. However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.

    Thanks for writing in to Microsoft.

    Regards,
    Kamal

  2. Add CREATE DOMAIN command

    Can't define domains in SQL Server 2005 for data types.

    3 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

    <=-=Feb 17 2006 2:04PM=-=>

    Thanks for the feedback. We’ll consider your input for planning of future release of SQL Server.

    <=-=Jul 19 2007 1:38AM=-=>

    Hello

    please consider ALTER DOMAIN, too.
    This should allow minor changes to the domain (like changing the size of a char column) WITHOUT data loss.

    Thx
    EH

    <=-=Nov 15 2008 7:21AM=-=>

    This feature is a standard feature in ISO SQL and is well used in case tool like Power AMC while modeling the datas. Its a feature that can optimize the data model by fixing globally the types of informations across the tables that will result of no implicit cast while using two columns in a join wich can have been differently created in two different tables. Example : column name in table customer as varchar(25) and column name in table employee as nchar(32). This would be avoided by using a NAME SQL

  3. Option to defer foreign key constraint checking until transaction commit

    There are various "chicken and egg" scenarios where it would be desirable to defer the checking of referential integrity constraints until commit time on a transaction.

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

    <=-=Apr 20 2006 7:33PM=-=>

    As a further example, consider flushing the contents of an ADO.NET dataset to the database server. Currently, the order of the updates is critical. It would simplify code design if you could just a) start a transaction b) send all the updates c) commit them.

    <=-=Oct 13 2006 1:35PM=-=>

    Hello Greg,

    Thanks for the feedback. We are aware of this and looking into it for a future release.

    Sameer Verkhedkar
    SQL Engine
    [MSFT]

    <=-=Apr 9 2008 5:07AM=-=>

    This is a duplicate of feedback id 124624.

    The SQL ANSI-92 standard is to defer constraint checking until the commit phase – only 16 years ago now.

    It is not a question of performance or faster dev, it is a fundamental to any database to be able to change a record from one consistent state to another consistent state within a transaction,…

  4. Placing Database under Source Control

    I have been trying to evaluate how SQL Server Management Studio integrates with source control. The only thing I can find is the ability to place a database 'solution' under source control and that basically puts create scripts and change scripts under source control. It doesn't keep 2 or more people from making changes to the same object.

    3 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 20 2008 2:27PM=-=> harolds,

    Thank you for the suggestion. I will send a notification to the feature team to keep tracking of this suggestion.

    Regards,
    Eric Kang
    Program Manager, Microsoft SQL Server

    <=-=Aug 22 2008 11:49AM=-=>

    Harold is a colleague of mine. It just seems strange to us that all SQL related source control is done at a SQL script level instead of an actual object level within SQL Server itself. You should be required “check-out” a stored procedure, for example, before you can ALTER it. If you “Undo check-out” then the object should be restored to it’s previous state.

  5. Support ISO 9075 standard string concatenation - double pipe

    The ISO SQL standard 9075, feature ID E021-07 covers string concatenation. The standard specifies this is a double pipe character sequence ('||'). SQL Server doesn't currently uphold this standard.

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

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

    Thanks for the feedback and the many votes. Note that while we do not use the standard syntax for it, we are providing equivalent functionality with the ‘+’ operator.

    Nevertheless, we will look into it for a future release.

    Best regards
    Michael

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

    Thank you, Michael.

    While I am familiar with the “+” operator for string concatenation, it is both non-standard, making writing SQL for SQL Server more burdensome, and overloaded, causing hard-to-find type-casting errors.

    The double-pipe would be a great improvement in a number of scenarios. I appreciate your consideration of it for a future version.

    <=-=May 1 2008 6:50AM=-=>

    This is needed so that one version of a SQL statements can be ported to different database platforms without change.

  6. Allow enabling and disabling of a column's IDENTITY property

    Sometimes IDENTITY columns need to be cleaned up a bit -- their values updated or re-ordered, for instance. This can occur when data replication strategies fail, or when unexpected data was inserted. This is a somewhat rare occurrence, but when it does happen it can be extremely painful due to the fact that IDENTITY columns cannot be updated, and the property cannot be enabled or disabled. As a result, in most cases doing what should be a simple update requires creation of a new table.

    Likewise, we sometimes want to be able to turn an existing column into an IDENTITY…

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

    <=-=Jan 18 2007 10:51AM=-=>

    Thank you for the feedback, we’ll look into ways to improve on the scenario you describe.

    Thanks,

    - Christian Kleinerman

    <=-=Jul 5 2007 12:27AM=-=>

    IDENTITY columns CAN be updated! See workaround…

    <=-=Feb 21 2008 8:08AM=-=>

    Workaround doesn’t work in 2000 or 2005.

    I would rate updates more important than turn on/off, but both would be very handy.

    <=-=Oct 16 2009 4:00AM=-=>

    @way0utwest – the workaround definitely does work in 2005 – I used it just the other day!

    <=-=Feb 4 2010 5:16PM=-=>

    I have added a partial workaround using ALTER TABLESWITCH.
    I do agree that this would be a useful extension to ALTER TABLE ALTER COLUMN though…

    <=-=May 2 2013 8:10PM=-=>

    I just realised how painful having identity columns !! we recently wanted to merge two client databases (their businesses merging) and it became a nightmare!! Because we used identities as…

  7. Attach with NoRecovery

    For VLDB and Highly Available users with SAN copy infrastructure, the ability to attach a database with NORECOVERY to use as a log shipping target would be a big benefit. This would leverage the SAN copy with the SQL attach capability to quickly initialize log shipping partners.

    3 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

    <=-=Apr 18 2007 9:54AM=-=>

    Thank you for your suggestion.
    This is functionality which we are actively investigating, but cannot commit to at this point.
    I will keep you informed as the situation develops.

    <=-=May 14 2007 10:18AM=-=>

    This suggestion is being closed as a duplicate of another suggestion for the same functionality. Rest assured that the idea is not rejected, we’re just consolidating the work items in our database to make tracking more manageable.

    <=-=May 14 2007 10:19AM=-=>

    Closing as duplicate as previously discussed

    <=-=May 14 2007 10:20AM=-=>

    Item being closed as previously discussed.

    <=-=Jun 14 2007 10:06AM=-=>

    What is the duplicate suggestion this was consolidated into? I want to add that to my watch list.

    <=-=Feb 4 2009 8:16AM=-=>

    Typically the SAN vendors utilize the VDI API layer to coordinate these external backups with SQL Server (BACKUP DB WITH SNAPSHOT…). This creates a header (.bak)…

  8. triggers before insert and row level.

    Need to have real Before triggers and row level triggers. SQL doesn't have these triggers or sequences. They have "instead of" but not a real Before Trigger like enterprise level databases have. It's a real pain to program in SQL or to convert from Oracle or MySQL.

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

    <=-=Jul 3 2007 12:12AM=-=>

    BEFORE triggers are part of ANS SQL 99 (and 2003), and as such have been implemented by many manufacturers (Oracle, IBM).

    It’s time MS implemented ANS SQL.

    <=-=Jul 8 2007 5:49AM=-=>

    That request is for 3 features instead of one!
    1) I agree about Before Triggers
    2) Row triggers are easily done with SQL although with non ANSI syntax. But they are a bad practice, so low priority for me.
    3) Sequence would be nice eventually, but it is not a show stopper.

    <=-=Aug 13 2007 2:53PM=-=>

    Thank you for posting your request. We realize that BEFORE triggers are extremely useful, specifically in migration scenarios. Unfortunately, we are not able to provide this functionality in SQL Server 2008. We are considering it for a future release. Meanwhile, we suggest using INSTEAD OF triggers to achieve similar functionality.

    <=-=Aug 17 2007 1:01PM=-=>

    INSTEAD

  9. Defered Constraint Checking

    We often need to reload application tables, such as configuration, enumeration values etc which we do via a bulk insert from application generated export. When foriegn key constraints are added against these tables deleting and reloading data results in constraint violation. Since an alter statement cannot be placed in the same batch the process constraint disable/reenable cannot be performed within the context of the transaction to ensure constraint is reenabled if the data reload fails.

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

    <=-=Jul 9 2007 12:51PM=-=>

    Dupe of:

    https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124624

    <=-=Jan 22 2008 2:09PM=-=>

    Kurt,
    Thanks for your valuable feedback and sorry for the late answer. As you might have seen in the community discussion comment of your submission, there is a related suggestion about the same issue. We are planning to implement this feature in our next major release. This other suggestion also includes a possible workaround, see https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124624
    With best regards,
    Roman

    <=-=Apr 5 2010 3:12PM=-=>

    Hi,
    I have resolved your request as duplciate of feedback item below:

    https://connect.microsoft.com/SQLServer/feedback/details/124728


    Umachandar, SQL Programmability Team

  10. Make SSDT Available for Linux as well

    As of now, if we need to build the SQL Server project, we need the SSDT toolkit on a Windows machine to build the project. Is it possible to make it available for Linux as well so that we can build the SQL server project not only on Windows but on Linux as well?

    2 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 →
  11. Change the title of a report to be different from .rdl file name

    If my RDL file is named Reportforseeingthings.rdl

    Displayed the web portal report title as "Report for seeing things"

    This would allow users to adhere to URL design best practices and give designers the ability to accomodate their clients naming pattern requests.

    2 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 →
  12. Adding Multi-column IN clause support by SQL Server

    Currrently, SQL Server does not support multi-column IN clause. For example, the following query :
    Select * from tableA where (columnA, columnB) in select (columnX,columnY) from tableB
    will not run, failing by displaying the error :
    non-boolean type specified in a context where a condition is expected”

    2 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 →
  13. The Context Menu in the object explorer is incorrect.

    When using a dark color theme, the context menu can not be read.
    Background and foreground colors are black.

    2 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 →
  14. List of Databases on SQL Server Manager

    SQL Server Manager list all databases registered on the server, not taking into account the access restrictions that certain login might have, causing a user to get lost on that list and looking for a specific database he/she is interested in.

    2 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 31 2010 3:54AM=-=>

    Hi Juan,

    We have another connect issue opened for same issue. As that issue currently has more vote count, we will consider your issue as duplicate of that issue and will keep tracking the other one.

    You can visit the other issue using this link http://connect.microsoft.com/SQLServer/feedback/details/345379/display-only-sql-server-objects-that-you-have-access-to

    We are planning to address this issue in SQL Server’s next major release.

    Regards,
    Sumesh

  15. Allow Multiple Column Subqueries

    There is no implementation in TSQL to allow for Multiple Column Subqueries.

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

    <=-=Sep 27 2010 11:47AM=-=>

    Hi,
    Thanks for your feedback. We are already tracking the request for row value constructor at:

    https://connect.microsoft.com/SQLServer/feedback/details/299231

    So I will resolve yours as duplicate of the above connect item.


    Umachandar, SQL Programmability Team

    <=-=Sep 27 2010 12:26PM=-=>

    While it does seem to be a duplicate of the other request, I see the other request has been open for 3 years. Will this feature ever be implemented?

  16. SSRS RDL needs method to compute export filename and document properties with expressions

    Disregarding subscriptions delivered via file shares, when a report is exported, it always gets the same name. Exporting the Invoice report with input parameter Invoice Number set to 12345 generates "Invoice.PDF" rather than "Invoice 12345.PDF". We need a feature supported in Report Manager and Report Viewer, that allows filename and other document properties (title, subject, author, keywords, etc) to be calculated (not hard-coded) inside the report so that when a user decides to export all of this is contained in the output.

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

    <=-=Feb 16 2010 6:55AM=-=>

    Couldnt agree more. This is basic functionality. We need ability to generate dynamic PDF document properties, especially document title.

    <=-=Feb 26 2010 12:54PM=-=>

    Hi, Thanks for filing this enhancement request on connect. We will consider this in a future release of reporting services.

    <=-=Feb 25 2011 3:03AM=-=>

    Hi..

    Please ensure that this feature will be included in SQL SERVER 2011 (Denali) . This is very much required in our project where SSRS reports are exported to word and the filename needs to be based on the parameter values selected.

    Thanks
    Kiran B

    <=-=Mar 14 2011 5:09PM=-=>

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/8b9325b9-d0f6-476c-b9c9-236301df5536

    I feel that this should have been a given as well. I would also like to request that dynamic file names be an added option on the file name save.

    Thank you,
    Rocco Couts

  17. Change table schema after enabling CDC

    Table1 has cdc table as cdc.db.table1_CT
    I added a new column to table1 , but the changes are not reflected to cdc.db.table1_CT.

    Also i modified a column name , i got an error message says

    Error where encounted during saving process.Some database object were not saved
    'table1' table
    - Unable to rename column from 'x' to 'xy'.
    Cannot alter column 'x' because it is 'REPLICATED'.
    A severe error occurred on the current command. The results, if any, should be discarded.

    I tried Disable / Enabe CDC.

    That works good but it deleted all the previous data.

    Is there any way…

    2 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: 26

    <=-=Jan 19 2010 1:43PM=-=>

    Hi Eva,
    You should be able to capture a new instance of CDC when you make a schema change. After that point all changes to the table should be captured in the new instance. The old capture instance can be dropped if the changes have been processed. Please read “cdc._CT transact-SQL” topic to get more information on DDL.

    Thanks

    <=-=Jan 19 2010 2:08PM=-=>

    I don’t want to drop all my old capture instance(old history). Is there any way.

    <=-=Sep 28 2012 7:45AM=-=>

    Don’t you love when Microsoft has a great idea but just can’t or won’t bring it to completion. Duplicate of.

    https://connect.microsoft.com/SQLServer/feedback/details/552372/change-data-capture-preserve-history-when-adding-new-columns

    <=-=Feb 20 2013 3:33PM=-=>

    We appreciate the proposal but current engineering focus doesn’t allow us to invest on this change… If there are continued increase of interest, we can revisit.

  18. Autofit in SSRS Excel Export

    Currently when exporting an SSRS report to Excel, the widths of the fields are all fixed size, rather than set up based on the largest field in the column. I know there is the CanGrow property, but that increases the height of the cell rather than the width. Is there a way an AutoFit property can be applied?

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

    <=-=Dec 1 2010 12:50PM=-=>

    Any word on this?

    <=-=Dec 10 2010 7:51AM=-=>

    Also when exporting in Excel, I noticed now that if i have a column that is set as either .75" or 54pts, when it exports to excel and you view the page layout, the column shows in excel as .79"

    The cell has no padding and the cangrow/shrink is set to false for both, so something is going on in the rendering extention that we cannot figure out..

    <=-=Apr 15 2016 6:04AM=-=>

    Microsoft Team – Can you please update on this ? if any work around.

  19. Non Aggregating fields in Tabular Models

    On attributes in the UDM there's a property called IsAggregatable.
    Tabular models need the equivalent property?

    i.e we have a field that is the equivalent of a costing model.
    Models can be compared but they should never be added together.

    Users get incorrect results if 2 models are added. (This is the default in Excel. i.e. if the user doesn't explicitly select a model before doing any analysis the results are overstated)

    The issue is worse because there isn't any exposed default memmber property.

    2 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. SQL Server Audit - Need actual values stored with Audit record

    When SQL Server stores the Audit record, the values in the update clause and where clause are replaced with parameters. To meet the requirements to audit who viewed and changed information (specifically what information), we need to store the actual values with the audit record.

    This is a great new feature, but without the values, it isn't sufficient to meet requirements.

    2 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

    <=-=Sep 30 2010 10:18AM=-=>

    Hi Tracy,

    First of all, thank you for your feedback!

    In order to investigate further, I wanted to get an understanding of how this query is invoked. Are you noticing this behavior when invoking the query using a stored procedure?

    Thank you and regards,
    Don Pinto
    SQL Server Engine

    <=-=Jul 7 2011 4:28PM=-=>

    Hi,

    We have detected another connect item requesting for the same functionality.

    We have linked this connect item with another connect item that is kept open (http://connect.microsoft.com/SQLServer/feedback/details/624935/sql-server-2008-database-audit-on-insert-update-and-delete-actual-sql-and-not-parameter-values) and closed this item.

    Thank you and regards,
    Don Pinto
    SQL Server Engine

  • Don't see your idea?

Feedback and Knowledge Base