SQL Server Support Blog

Options
1,085
Joseph Pilov on May 09 2024 01:17 PM
1,091
Dharshana on Mar 18 2024 08:56 PM
5,201
moematsuo on Feb 15 2024 04:25 PM
1,989
JamesFerebee on Nov 20 2023 09:45 AM
2,768
moematsuo on Sep 04 2023 01:47 AM
3,007
IdaliaL on Aug 16 2023 11:14 AM
20.5K
mizuhokitao on May 08 2023 02:32 AM
19.6K
Dharshana on Apr 23 2023 02:29 PM
2,160
Katsuya_Ito on Apr 07 2023 06:08 AM
18.3K
JuanPabloSalg on Mar 29 2023 08:11 AM
6,038
Katsuya_Ito on Mar 16 2023 11:03 PM
14K
Joseph Pilov on Feb 27 2023 03:02 PM
4,273
NathanMSFT on Feb 27 2023 09:13 AM
5,303
Joseph Pilov on Dec 13 2022 12:31 PM
6,748
prakashkc on Dec 07 2022 07:40 PM
6,470
Krishnakumar_Rukmangathan on Nov 14 2022 01:56 AM
5,988
Liwei on Nov 01 2022 11:16 AM

Latest Comments

@florin_gheliuc Update to at least CU6.Or disable the query store. This tells you that it is caused by Query Store.| * Exception Address = [...] pdb="qds.pdb" [...] module="qds" [...] We had a ticket with MS because of this stack dump, and a fix was pushed in CU5.Cumulative update 5 for SQL Server 2...
0 Likes
Hello!After upgrading our server to MSSQL 2022, there are lots of error messages that we receive on our email, at the IT.We have an automated mail from SSMS that sends these, if you want, i'll give you the code for that too.I just want to know if we should be worried, because every forum I've checke...
0 Likes
"Even without any memory optimized tables,number of checkpoint files keep going up every time we issue a checkpoint"Is there any reason that this keeps on happening even after the table is dropped? What is stored in those checkpoint files and why are they there even in a situation where there is no ...
0 Likes
First SQL Query as text for the next poor fellow who finds this post :D SELECT spm.class_desc, spm.permission_name, spm.state_desc, spr.name, spr.type_desc, spr.is_disabled, ep.name AS EndpointName, ep.protocol_desc AS EndPointDescription, ep.state_desc AS EndPointState, ep.type_desc AS EndpointType...
1 Likes
This is a Windows defect.If memory allocation calls are going to fail due to a lack of resident available memory then Windows should be setting the memory pressure state so that applications can voluntarily release memory rather than just crashing.
0 Likes