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 Microsoft Q&A or Stack Overflow

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Cannot chose 23:59:59 for a Daily frequency | Occurs once at...schedule

    In SSMS, you cannot set up a schedule that runs once a day at 23:59:59, as SSMS is validating this against the Occurs every...option. Updating the schedule using the SP works fine and has the desired result EXEC msdb.dbo.spupdateschedule @scheduleid=@vScheduleId,

        @active_start_time=235959
    

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. Sql Management Studio

    When Connecting to a remote database i am unable to see the database and its tables . after refreshing several times it does appear correctly. studio version is V18.6. Login user is set to view only his default database. all other databases in this server is invisible to this user.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. Acces violation when altering database trigger

    SQL Server Version: Microsoft SQL Server 2019 (RTM-CU9) (KB5000642) - 15.0.4102.2 (X64) Jan 25 2021 20:16:12 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19042: )

    The script, when run, crashes session with following error:
    /
    DROP TRIGGER [T1] ON DATABASE
    DROP TRIGGER [T2] ON DATABASE
    /
    CREATE TRIGGER T1 ON DATABASE
    FOR DDLDATABASELEVEL_EVENTS
    AS
    DECLARE @Data XML;
    GO

    CREATE TRIGGER T2 ON DATABASE
    FOR DDLDATABASELEVEL_EVENTS
    AS
    DECLARE @Data XML;
    GO

    DISABLE TRIGGER T2 ON DATABASE
    GO

    ALTER TRIGGER T2 ON DATABASE
    FOR DDLDATABASELEVEL_EVENTS
    AS
    DECLARE @Data…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. SSRS report tool creates a report with a box that cannot be expanded

    We use SSRS report tool to generate reports. We have a report that is hard to read because a box cannot be expanded to be able to see the contents of each line/row in the box. A user has to scroll left and right to be able to see the contents of the line. It would be helpful if this box could be expanded. I have attached a doc that shows the problem

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  5. OFFSET - FETCH is unnecessarily inefficient

    This idea is detailed at: https://dba.stackexchange.com/questions/286492/why-does-sql-server-do-lots-of-unnecessary-clustered-key-lookups-in-this-select

    Basically, if you have a non-clustered index that covers a query's WHERE and ORDER BY clauses, the rows in an OFFSET should not need to do a clustered query lookup.

    So if I have an index containing:


    ([target_user_id] ASC, [date_created] ASC)

    ... and I run the query:


    SELECT [target_user_id], [patient_id]
    FROM MyTable
    WHERE [target_user_id] = 100017
    ORDER BY [date_created] ASC
    OFFSET 9200 ROWS
    FETCH NEXT 10 ROWS ONLY

    ... SQL server should only need to do 10 clustered key lookups. Right now, it does 9210. However, the lookup is only needed to get the …

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. SQL 2016 SP2 CU16 | CXCONSUMER waits related to TempDB spooling and parallelism

    One of our clients noticed that after upgrading to SQL 2016 SP2 CU16, there were a number of queries "hanging", waiting on the CXCONSUMER wait type indefinitely.

    The common denominator between each affected query was the use of parallelism and TempDB spooling. Setting the queries to use MAXDOP 1 allowed them to run, but otherwise they would be stuck waiting on CXCONSUMER.

    In the end, we had to rollback to SQL 2016 SP2 CU15 to resolve our issue, however we wanted to post our experience in case anyone else has similar issues (and to make MSFT aware).

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  7. Regional settings are not available because files uses Live Connection

    When we are using import query and direct query we are able to change the regional settings, but unable to change using live connection. If this feature implemented in the upcoming releases would be greatful!

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Partition SWITCH should allow you to migrate tables with compatible datatypes of different lengths in target table

    Scenario: We have a huge table where we want to change a data type for one column from varchar(max) to varchar(255), and an INT to a BIGINT.

    Rather than incurring downtime by altering the column, or having to plan a long data migration from the OLD to the NEW table, it would be great if we could do a partition SWITCH to migrate the table when there are compatible datatypes. In the current engine, the datatypes for the columns have to match exactly in the NEW table you're switching to....

    ALTER TABLE [OLDTABLE] SWITCH TO [NEWTABLE]

    Error:

    Msg…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  9. ssas redshift oledb provider

    we need to connect SSAS cubes to Redshift

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  10. option to suppress partition switch messages in SQL Server error log

    Systems that rely heavily on partition switching for ETL or other purposes can have their error log cluttered with hundreds or thousands of these messages.

    Successful transaction log backup messages can be suppressed with trace flag 3226, a similar method to suppress partition switch messages would reduce noise in the error log.

    An ALTER TABLE SWITCH statement was executed on database '%', table '%' by hostname '%', host process ID % with target table '%' using the WAITATLOWPRIORITY options with MAXDURATION = 5 and ABORTAFTERWAIT = BLOCKERS. Blocking user sessions will be killed after…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  11. fix unattended execution account registry permissions

    When the Unattended Execution Account (UEA) is configured in SQL Server Reporting Services (SSRS) with an account different to the SSRS service account the ability to export to XLSX from reports is broken. Specifically, before configuring UEA an interactive user can run a report and use export to XLSX functionality. This uses the SSRS service account to read registry key "HKEYUSERS\ServiceAccountSID\Software\Microsoft\Avalon.Graphics" . After the UEA account is configured UEA tries to read this registry key underneath the SSRS service account HKEYUSER registry tree but it does not have permissions.

    Expected behaviour:
    1. change SSRS configuration tool to grant…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. Multi char/string delimiter in Data factory datasets

    Any updates on allowing multi char or String delimiter for dataset while using them in conpy stage activities. Few complex files like xmls and jsons in text can be read easily if this flexiblity is given.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Multi char/string delimiter in Data factory datasets

    Any updates on allowing multi char or String delimiter for dataset while using them in conpy stage activities. Few complex files like xmls and jsons in text can be read easily if this flexiblity is given.

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  14. Sort Thread Numbers Correctly in Operator Properties

    Thread numbers do not sort correctly after you hit 10 threads.

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  15. SQL Server 2016/2017/2019 reproducible memory leak scenario with spatial index search - is there a patch?

    I found out that searching geography points with spatial index may lead to irrecoverable memory leak scenario, that is after some long running time only SQL Server restart helps and performance of SQL Server is severly degraded. Is there a patch for it or workaround? How it could go unnoticed?

    I've attached a reproduction script, it may be overwhelming but I'm just not sure which part is causing the leak actually. After several hours the script may lead to performance issues so please don't run it on production servers!

    REPOSTED FROM: https://docs.microsoft.com/en-us/answers/questions/288755/sql-server-201620172019-reproducible-memory-leak-s.html

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  16. SQL Server 2016/2017/2019 reproducible memory leak scenario with spatial index search - is there a patch?

    I found out that searching geography points with spatial index may lead to irrecoverable memory leak scenario, that is after some long running time only SQL Server restart helps and performance of SQL Server is severly degraded. Is there a patch for it or workaround? How it could go unnoticed?

    I've attached a reproduction script, it may be overwhelming but I'm just not sure which part is causing the leak actually. After several hours the script may lead to performance issues so please don't run it on production servers!

    REPOSTED FROM: https://docs.microsoft.com/en-us/answers/questions/288755/sql-server-201620172019-reproducible-memory-leak-s.html?childToView=291694#answer-291694

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  17. SSMS v18.8 - Database Diagram's "New Database Diagram" Table Select Wizard doesnt reread table names after ef update-d

    SQL Server Management Studio v18.8 - Database Diagram's New Database Diagram Table Select Wizard doesnt reread table names after ef update-database. (renamed table names)

    Refresh Database or disconnect/reconnect isnt solving problem (until restart app).

    Thanks,

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  18. Sql Server management studio is blurry when using high dpi monitor with scaling

    Sql Server management studio is blurry when using high dpi monitor with scaling.

    It works great in the main monitor that is scaled, but as soon as you move it to another monitor, it's all blurry.

    Visual Studio adapts to the destination monitor as you move it, Management Studio doesn't.
    This is very frustrating as we can't use it in a second monitor while using Visual Studio or other tools in the main monitor.

    It would be great that it scaled properly when moving it from one monitor to another.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  19. (Anti) semi join syntax instead of cubersome in/exists

    The idea is to implement a syntax that is more close to both the relational database concept and the plan operators of semi join. Example:

    I have a [person] master table with a PK column [id].
    Also a [car] table with a FK column [person].

    Query A: Find cars that belong to some person:

    select *
    from person p
    left join car c on p.id=c.person

    Query B: Find persons that own cars:

    select *
    from person p
    where p.id in (select person from car)

    OR:
    select *
    from person p
    where exists (select 1 from from car where person=p.id)

    In…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  20. Support Distributed Availability Groups with Distributed Network Names

    Instead of needing an ILB for AGs and FCIs, IaaS-based SQL Server deployments in Azure now support the use of a Distributed Network Name (DNN) for FCIs or an AG's listener. This makes deployment a little easier.

    However, if you have Enterprise Edition, are using FCIs or AG listeners with DNNs instead of traditional network name resources, you cannot currently deploy a distributed AG. That requires an ILB.

    Microsoft should build the right plumbing into DNNs to support distributed AGs as it is an important disaster recovery and migration feature.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 534 535
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base