Take a look at the properties on the other operations. I'll bet you they're ordered operations. This is all good. An ordered seek or scan with a merge can be...

I don't see anything wrong with asking about the salary range. The thing is, the employer wants to get you for as little money as possible, so they're going to...

That's a very large topic and I'm not going to be able to tell you everything now.

First, be sure you know what the anticipated load on the system will be....

Pinal is a great guy. But, I wouldn't rely on those lists of questions and answers. I...

You might want to hire a consultant to do the interview for you. I know several people that are regularly doing interviews for employers that don't have the internal resources...

In order to collect a meaningful set of data, you're going to need access to the server. You can look at the information in dynamic management objects (DMO) such as...

I completely spaced asking, but who from The Thread is going to be here in OKC for #sqlsat125?

I thought we had an agreement. You wear the dress. I...

If you update the statistics for a table, it updates all the statistics associated with that table.

No, I wouldn't create or maintain individual statistics except in rare cases for tuning...

Same reason you...

Yes, that does make sense. I'd want to see a good heavy load, especially if I was relying on the old single-threaded model of trace replay.

You'd think this would be...

You can use the old Profiler to playback a trace. That will act as a measurable set of tests and will put some load on the system. You just can't...

It is amazingly faster. It's just not the same at all.

Actually, yeah, looks like 2005 might be out. That stinks. Never noticed that before.

Since it's backing up with NOINIT, it's likely putting one backup on top of another. You may not be seeing the right backup.