@Carlo P - I think my handling tends to be more consistent where if you have translations, you're a) putting one language ahead of others and b) means I need...

Something seems odd. Are you sure you have the same version of the proc code?

Maybe try this:
- Script the proc out
- change to a new name...

This might help: http://www.sqlservercentral.com/blogs/sqlrnnr/2018/11/26/ghosts-in-your-database/

I don't think this is parameters. Looking there likely is a distraction. I suspect there's a data error somewhere in a table, and I'm guessing that's where the issue is....

I don't see EAV as evil. They don't scale well and they can be problematic for busy workloads, but for an ad hoc item that you don't want to put...

How do you kick this off? Is a user doing this or does it need to trigger on some change in your existing database?

The designation of a file as .mdf or .ldf or .ndf is arbitrary and by convention. There isn't any reason you must have the files names with these extensions. I...

All transactions are replayed on the mirror, so log space is used. You have an alert on the DR server looking for the log being above 80%. Not sure what...

You should stop using SSMS for 208R2. Download SSMS 17.9, which is free and will work fine for SQL Server 2008 R2.
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

Second, I'm guessing you...

I don't think you're passing in a varchar, but somewhere in your data there is an implicit conversion taking place, which gets a varchar ("No") and can't cast this to...

That was interesting, so I ran some numbers. The first answer is correct 22% of the time.

SQL Server can handle this, but there isn't queueing per se. Instead, you potentially get blocking at the page level. In order to perform an insert, a process acquires a...

It could be both. Fragmenting things across pages could mean more pages are needed, but most of the time this is more CPU as you must search the disk and...

I've seen this type of thing before. Often this is some cached credential being used, either from the service or the DC, and depending on when updates invalidate the cache,...