Simple fact of the matter is, those functions prevent statistics use and lead to index scans. No matter what. If you cannot remove them, you cannot improve performance by query...

You won't, but if you do pass through Tulsa, give me a shout.

As to KC, I plan to get up there sometime soon(ish) to go to the WWI museum. Oh,...

• This reply was modified 4 years, 11 months ago by Grant Fritchey.

Also, if you're capturing lots of queries that declare the same variable for the same column all different sizes based on the data passed

@Name(3) for 'Dog'

@Name(8) for 'Elephant'

Not only are...

Or, another possibility, they're using that in another function and some functions require NVARCHAR .

Cause you have more than one character set? That's the only reason I'd use it.

Well, I'd say the only real way you can suggest, you can't prove it, that they're probably ORM tools is the fact that, assuming they're using the ORM tool even...

A picture of a plan isn't a plan. Also, plans are not a measure of performance. They're a description of behavior. Be cautious about looking at them as a measurement...

You can do a lot of DBCC checks offline through a backup. That's one way to reduce the overhead. All the logical checks will work on a backup. You only...

What @michael-2 says.

The reason you need space in tempdb for the index is because the data must be sorted before it can be written out to the index. So, yeah,...

5GB is less than the VM running on my laptop has for managing SQL Server.

You have to think about how SQL Server works. Let's just talk about reads for a...

AWS RDS doesn't support log shipping, but you can build your own scripts to do it. They have an article on this. Otherwise, what @Ant-Green says.

Without a lot more information, I'm just guessing here. DBCC uses memory. Because of this, data that lives in memory could be flushed out to disk and then it takes...

And one other point, I just noticed, statisticstype you say has three values. You've got it as the first column in your compound key. The statistics probably have one or...

OK, lots to unpack. Honestly, first thing I have to say, it really sounds like this data needs to be properly normalized. I would absolutely focus a lot of effort...

Oh, and...

I can't believe I forgot this...

You can register for the Data Community Summit for free this year. Specifically, look at the Learning Pathways. They'll give you a...