It should go down. That sounds weird, like SQL Server is trying to hold most stuff in memory constantly, and it's exceeding limits so you're paging.

Strange.

So I got a question in email (it's not just posters, I get them regularly). I have a sig I paste in that replies and says "we don't answer in...

We typically send 9pm MST, so its' 24 hours prior to that.

It's threads which have had a post in the last 24 hours. I think we have some limit, 50,100, something like that for how many get in.

I don't see one around technet, but there is this one.

When you go with mirroring, the logs are moved, which means full recovery mode. If you truncate, you'd break mirroring.

Are you running log backups? You should be doing this to...

no better, in general. I hate to say it, but "it depends"

Do you get better performance on the local v remote? Maybe a SQL IOSIM to test some throughput and...

Or it's removal is coming in SQL 11 :w00t::hehe:

Ah, that button has been there a long time. Part of the editor for the forums.

Where do you see "Local Area Connection"? Isn't that in the control panel/networking?

There is a "Local Server Connection" I see. That typically, I think, uses "(local)" as the connection, which...

I'm torn here. I wouldn't be surprised if he got the job since most candidates can't answer those questions. At least not from the stories I hear.

So do we teach...

closed thread.

Please don't double post.

We are more than happy to help, but we want you to do a little work first. Go research those questions, search in Books Online. If you don't understand something...

New link??!? Ah, yeah...

see, we, ah...

no idea what you're talking about.

but I am glad it's working.

No offense intended, but we are in the "teach a person to write SQL" camp as opposed to the "give them the" SQL camp.

We want you to learn. If you...