cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Server Support Blog
Options
8,692

GMSA is used for SQL service and it fails to start

SaniyaSamreen on Aug 31 2021 04:06 AM
GMSA is used for SQL service and its failing to start with error “the request failed, or the service did not respond in ...
2,472

Update Stats Sample Rate does not work

Liwei on Jun 23 2021 07:24 AM
3,772

DISABLE_PARAMETER_SNIFFING

Liwei on May 31 2021 09:00 AM
2,152

Selectivity and Estimated Row: Variable

Liwei on May 26 2021 07:29 PM
7,630

How To Connect to SQL Server On-Premise/Virtual Machine from Linux using Kerberos Authentication

dineu on Mar 26 2021 07:47 AM
It is known that SQL Server can be accessed with many different authentication methods. We often recommend the use of In...
38.1K

Memory Grants: The mysterious SQL Server memory consumer with Many Names

Joseph Pilov on Jan 27 2021 12:58 PM
First published on MSDN on Jan 01, 2013 The Memory Consumer with Many NamesHave you ever wondered what Memory grants are...
4,389

SQL Server Unconstrained Delegation failing after 10 hours

FranciscoBertao on Jan 27 2021 03:52 AM
After the Windows updates from November 2020, you might be facing some issues running Bulk Inserts or working with linke...
14.6K

SQL SERVER installation failed. “Access is denied” when validating SQL Service account password

Bob_Cai on Jan 24 2021 01:45 AM
  Cancel " width="1054" height="693" border="0">
1,841

SSDT DacFx Pre/Post Deployment scripts containing DML for Always Encrypted columns

HeminMSFT on Nov 11 2020 03:04 PM
SSDT DacFx Pre/Post Deployment scripts containing DML for Always Encrypted columns
5,953

Change Locale/language of SQL Server on Azure VM

UjjwalPatel on Sep 24 2020 03:54 AM
In this blog we will discuss about how you can change the locale/language of SQL Server on Azure VM.

Latest Comments

ebialobrzeski
in Why am I getting so many checkpoint files when I have In-Memory OLTP enabled? on Apr 23 2024 04:41 AM
"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
PVerd
in Why do I get the infrastructure error for login failures? on Feb 29 2024 02:10 PM
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
dvenardos
in OS Hang or Out of Memory due to SQL Ser... No Wait, it's SQL Analysis Services (SSAS) on Feb 22 2024 03:20 PM
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
CetinBasoz
in The OLE DB provider "MSDASQL" for linked server " " supplied inconsistent metadata for a column.The column " " (compile-time ordinal 2) of object " " was reported to have a "DBCOLUMNFLAGS_ISLONG" of 0... on Feb 15 2024 03:50 AM
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
jayantdass
in Changes to hashing algorithm for self-signed certificate in SQL Server 2017 on Feb 02 2024 04:35 AM
Great one
0 Likes