Viewing 15 posts - 10,516 through 10,530 (of 22,213 total)
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...
August 28, 2012 at 8:02 am
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...
August 28, 2012 at 7:56 am
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....
August 28, 2012 at 6:13 am
Sachin Butala-182900 (8/27/2012)
you can follow Pinal @ SQLAuthorityhe listed questions for basic to advanced.
Pinal is a great guy. But, I wouldn't rely on those lists of questions and answers. I...
August 27, 2012 at 7:55 am
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...
August 27, 2012 at 4:39 am
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...
August 27, 2012 at 4:31 am
I completely spaced asking, but who from The Thread is going to be here in OKC for #sqlsat125?
August 24, 2012 at 3:07 pm
Jeff Moden (8/23/2012)
ChrisM@Work (8/23/2012)
Brandie Tarvin (8/23/2012)
... Tootsie Rolls...Are we back on Clinton??
It Depends... are you wearing a blue dress? :-):-D:-P:hehe:
I thought we had an agreement. You wear the dress. I...
August 24, 2012 at 5:45 am
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...
August 22, 2012 at 3:27 am
GilaMonster (8/22/2012)
Grrr. Why do some people want to nitpick holes in things I say and do it in a way that sounds very much like a personal attack?
Same reason you...
August 22, 2012 at 3:04 am
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...
August 21, 2012 at 6:50 pm
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...
August 21, 2012 at 5:04 am
It is amazingly faster. It's just not the same at all.
August 20, 2012 at 12:47 pm
Actually, yeah, looks like 2005 might be out. That stinks. Never noticed that before.
August 20, 2012 at 12:31 pm
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.
August 20, 2012 at 12:31 pm
Viewing 15 posts - 10,516 through 10,530 (of 22,213 total)