Hey Grant,

Thanks for the reply. I'm not upset (was just a bit surprised) and glad you aren't either. No harm done on either side then.

Looking back at the DBA...

<sigh>

So I post a comment over at DBA Stack Exchange, because I know what I'm posting isn't an answer. I get dinged for it because it almost...

It's going to take the amount of time it takes. To rewrite almost a terrabyte of data is just down to having enough disk space and disk speed. You're not...

I've been involved in that kind of work before, changing things from within without institutional support. I'd say, on a guess, I failed 75% of the time and succeeded 25%....

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 3 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.