5 votes

Logical reads and LOB logical reads

Here's my theory, These are logical reads, not physical reads. Imagine two rows, where the LOB data for these rows is on the same page (yes, pages can be shared across rows for LOB data). Perhaps each ...
user avatar
3 votes

Random Error 824 - All Environments

82x errors are rarely, if ever, a SQL Server issue as these are all error codes on something that doesn't make sense or has errored when returning to SQL Server code. For example, with 824 this can be ...
user avatar
2 votes
Accepted

Cannot connect to linked server using name in hosts file

Normally I would think this is something to do with lacking SPNs Yep. Kerberos SPNs depend on the hostname you use to connect. If you connect to a host called SomeServer.foo.bar the the service ...
user avatar
1 vote

What is the difference between CU-GDR and GDR?

Assuming I have RTM, then, does installing GDR (KB5014354) only apply that 1 fix? GDRs are cumulative as well, so applying the latest GDR also applies all previous GDR included fixes. All CUs and all ...
user avatar
1 vote

Random Error 824 - All Environments

Have you seen https://www.sqlservercentral.com/blogs/vmware-sql-server-823-824-alerts ? Not sure if you’re running on VMWare and which version, but there is a known issue with VMware vSphere 7.0 ...
user avatar
  • 11
1 vote

SQL Agent Job fails after upgrade to SQL 2017

I ended up creating the proxy under a new name, then reassigning all the jobs over to the new proxy. Here are the steps I used: Right click on the existing proxy, and do script as>create. Modify ...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible