Grant,

I think that is what I am doing.  The primary path AFTER sign in is by UserId - the identify column. However, at sign in it looks for the...

Jeff's not wrong (I say that...

This.

Just that. Everything else is nice to have. But that, that's a flipping miracle. And yes, I mean the word other than flipping.

You have to monitor the system in order to understand how it is behaving. Capturing wait statistics and queues can tell you where slow downs are occurring. Capturing performance metrics...

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 5 years 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...