If your page life expectancy is high, there's not to do but sip some coffee and look for other causes of poor performance. A high page life means that the...

Someone or some process such as a SQL Agent job must be switching it to simple recovery. I'm not aware of anything that does it automatically in the background.

Which model...

Darn. And I'm hungry too. Ah well. Life is full of these little disappointments.

First round of scotch is on me!

I agree with the others but feel the need to express it a different way.

If you're simply learning SQL Server, no. It's conceptually beyond the basics a bit.

If you're using...

I think my issue with doing it the "interesting" way as opposed to using JOINs is that, while this time, the performance and plan is likely to be identical, far...

Jeff Moden (4/11/2009)

---

Well... I did it. Thank goodness they extended the deadline of PASS 2009 Session Abstracts. I'll be there one way or another this year.

I...

radek (4/11/2009)

---

Hi,

really you need all columns (*)

So you can create nonclustered index on macaddress is key of index and this index will have inlcude other colums, try this....

I used to use it for error handling back in SQL Server 6.5 & 7.0. But I came out of the VB coding camp back then, so I did lots...

It sounds like you've set up the maintenance jobs or the sql agent, or both, to run under the 'sa' login and the password is not correct. Try running under...

I'm afraid I don't understand the question. Are you concerned that your system is not using enough memory or too much?

One measure that will tell you if memory is a...

kim.talley (4/10/2009)

---

I have a question from a developer that I'm not able to answer....I was hoping someone here could help out.

Is it more efficient to use multiple joins in a...

It really could be almost anything. Since you don't know, you need to investigate systematically. I like the recommendation to capture a trace. That's something I always do. I'd also...

HVPR (4/9/2009)

---

Thanks for your suggestions..

and sorry for the posting twice...

But I want to know is there any local sql server feature or tool which can help to sync the

code between...

It's really hard to say based on the information provided. Are you sure that the slow response on the system is due to this table in particular? If so, do...

GilaMonster (4/9/2009)

---

Join us next time? Even if it's just to watch and take photos?

For the records, I never beat Steve up. I was training with Kalen most of the class...