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. SSMS v18.4 scripting table without partition

    When I script table on non PRIMARY partition, the partition is missing

    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 →
  2. In the Result Grid add like excel the AVG, Count and SUM of Selected lines

    In the Result Grid add like excel the AVG, Count and SUM of Selected lines

    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 →
  3. precision with decimal product

    It doesn't seem necessary to me a precision p1 + p2 + 1,
    but it seems to me sufficient p1 + p2.
    am I wrong?

    e1 * e2 p1 + p2 + 1

    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 →
  4. SSMS Show Query Timestamp in Status Bar

    I want to see when the query in SSMS was executed displayed in the status bar in local time so that I know how stale the result is.

    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 →
  5. Need to restrict user from Email subscription but not windows file share subscription

    Need a configuration in SSRS to restrict user from creating email subscription but not from windows file share or vise versa or both.

    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 →
  6. SSMS 18x will not install

    SSMS 18x will not install - it launches, giving the UAC message, but no install, no error, no nothing after that. Fresh install of SQL 2019. Next try to install SSMS 18.4, then previous 18.x. Get the above behavior for every version

    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 →
  7. sp_send_dbmail inserts random spaces or randomly encodes HTML tags

    When using sp send dbmail in SQL Server 2016, it is randomly inserting spaces in the returned text, or randomly encoding HTML tag entities (see attached file). The sproc is being called from a job with the following parameters:

    @profile _ name = 'SQL Alerts',
    @recipients = '{email address removed}',
    @subject = 'CleanClaimRate Results',
    @query = N'EXEC [DQ].[usp _ DQ _ CompareCHRCleanClaimRateToEDWCleanClaimRate] ',
    @query _ no _ truncate = 1,
    @attach _ query _ result _ as _ file = 0,
    @execute _ query _ database = 'DataPrep',
    @body _ format = 'HTML'

    The meat of the sproc called in…

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  8. Additional Connection Parameters bug in SSMS

    When you have to use Additional Connection Parameters, to specify the server connection information, to connect to a SQL Server that does not use the default port (ex. SERVER=ServerName,12345) when you are not able to adjust the Server Name in the Connect To Server form. that connection information remains and when you try to connect to a different SQL Server, it connects and lists the SQL Server you are trying to connect to in Object Explorer. You think you are connected to that SQL Server, but if you drill down, you are actually connected to the server you stated in…

    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 →
  9. Allow to connect to secondary easily when not using default port in SSMS

    When you are adding databases to existing Availability Groups, you are required to connect to the secondaries. It brings up the Connect To Server form, but you are not allowed to adjust the Server Name. Then you need to use the Additional Connection Parameters tab in Options to specify the server name with the port to connect correctly. Once you do that though, that information remains and that is the server you always connect to when trying to connect to other SQL Servers. It states the name of the other SQL Server you were trying to connect to in Object…

    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 →
  10. SSMS to Zoom in/out like vscode.

    SQL Server Management Studio to Zoom in/out with Ctrl = / - like Visual Studio Code.

    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 →
  11. Enable partial selection of registered instances in a CMS group

    Hi. Some of my CMS groups have many registered instances. I can use the group to open a multi-instance query. There is no option to use only a subset. Perhaps SSMS can make a temp copy of the group and open it disconnected. Then allow the "change connection" or a popup menu on the group in the status bar to edit the local copy of the group to exclude (via a checkbox list) some instances or add new instances. If the local copy could merge in some local settings like connection timeout, that would be even better. Allow a local…

    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 →
  12. xp_msver

    Hi. EXEC xp_msver 'WindowsVersion' returns the wrong version number "6.3" for Windows Server 2016 and later. It should be "10". The buildnumber is correct. It acts like any build number greater than 9200 has to be version 6.3.

    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 →
  13. Support sp_rename on a computed column

    When trying to rename a computed column, sp_rename gives Message 4928. "Cannot alter column 'b' because it is computed.

    If a computed column A is defined as an expression that includes column B, then it makes sense to restrict renaming column B. But I would like the ability to rename A (instead of dropping recreating).

    I came across this issue when trying to avoid rebuilding an index.
    This feature would enable schema changes that for environments that have very strict online requirements. (See attached for example)

    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 →
  14. Add Column Headers to BCP

    Would be nice to include the ability to output Column Headers when using BCP.

    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. Add Text Qualifier to STRING_SPLIT Function

    It would be nice to have an option to include a text qualifier in this function. This would be very helpful for conversion/etl/data cleansing processes handled via t-sql.

    For Example:

    declare @list varchar(100)

    set @list = '"Simpson, Homer","Simpson, Bart","Simpson, Lisa"'

    select ss.value from STRING_SPLIT (@list, ',', '"') ss

    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. SSRS report export to PowerPoint

    When I export report containing tablix in PDF, the exported report converted tablix into image. Can it be made editable instead?

    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 →
  17. Adaptive Join Hint for SQL Server 2019

    Would like to request the addition of an adaptive join hint similar to loop, hash & merge hints. Also have the ability to allow the coder to explicitly define the indexes used for hash match or nested loop or let the optimizer select the indexes.

    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 →
  18. SQL Server Management Studio 2017 - Error Messages

    Time after time, not reproducible for me, while typing code, SSMS shows error messages like "The value you entered is outside the valid range" (translated from German). If this happens, I can close the error message by clicking "Ok", but it appears again and again whatever I enter on the keyboard. This is absolutely annoying. I guess that the developers of SSMS should not at all allow popping error messages about problems they have with parsing what I type while I just type.
    The only "solution" I have found is copying my code and restarting SSMS.

    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 →
  19. Transactional Replication to Kafka or Event Hub subscribers

    One of the most common "new" use cases for replication is to copy data from on-prem SQL to Azure. This could be Azure SQLDB, a data lake, or whatever.

    Certainly we could use ADF and a data gateway, but that adds on-prem infrastructure which is just yukky. A push solution is better.

    Imagine this: I setup transactional replication publications and then I create a kafka or eventhubs subscriber. Once the data is in kafka the world is my oyster. If I want the data in my data lake I can do that with a simple Azure Function or databricks streaming…

    5 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. Fix REST APIs for SSRS Adding Datasource

    The REST APIs appear to be half baked at this point and the exceptions returned appear to be based on the generic underlying structures (i.e. everythings a CatalogItem instead of a DataSet, DataSource, Report).

    https://social.msdn.microsoft.com/Forums/en-US/52d10776-e192-4ca4-
    8bfa-a24966def0e9/ssrs-api-v20-datasources-add-new?forum=sqlreportingservices

    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 →
← Previous 1 3 4 5 519 520
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base