SQL Server Support Blog

Options
865
Dharshana on Mar 18 2024 08:56 PM
4,418
moematsuo on Feb 15 2024 04:25 PM
1,813
JamesFerebee on Nov 20 2023 09:45 AM
2,639
moematsuo on Sep 04 2023 01:47 AM
2,815
IdaliaL on Aug 16 2023 11:14 AM
19.1K
mizuhokitao on May 08 2023 02:32 AM
19.2K
Dharshana on Apr 23 2023 02:29 PM
2,053
Katsuya_Ito on Apr 07 2023 06:08 AM
17.8K
JuanPabloSalg on Mar 29 2023 08:11 AM
5,741
Katsuya_Ito on Mar 16 2023 11:03 PM
13.7K
Joseph Pilov on Feb 27 2023 03:02 PM
4,098
NathanMSFT on Feb 27 2023 09:13 AM
5,086
Joseph Pilov on Dec 13 2022 12:31 PM
6,527
prakashkc on Dec 07 2022 07:40 PM
6,229
Krishnakumar_Rukmangathan on Nov 14 2022 01:56 AM
5,781
Liwei on Nov 01 2022 11:16 AM
4,726
Krishnakumar_Rukmangathan on Jul 12 2022 04:47 AM

Latest Comments

"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...
0 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
I am here because I got this error and hoped I would find a clue, but no dice. In your case it might be explained by nvarchar(max), however I got it on a postgreSQL boolean column which is bit on SQL server. Makes no sense. Discard this. I found my solution, naturally outside Microsoft Tech Communit...
0 Likes