For a heap, when you insert data, it adds to to the next page in the last extent (or makes a new page). For deletes, space is marked as deleted,...

Dave,

We'd be happy to work with you to get an article done.

The first step is usually stop and think essay, think about high school/college, and structure things like that. Write...

Grant Fritchey (6/26/2009)

---

Wow! That's big. You're talking about the Scouting one right? I didn't even realize your boy was up to First Class already. That's where they have to be...

One more thing, if you are using this to build your own brand, put it on your resume, you might want your full name.

Ah, not yet. :hehe:

Going to DC, dropping my son off at the National Youth Leadership Conference for a week, spending some time with my brother, speaking in Richmond on Thur...

jwalker25, don't get upset, :-D, we've all been there.

Certainly understand politics, just wanted to be sure this wasn't ignorance or a lack of understanding.

If you were to replace a current...

Sorry, what I meant (and didn't say) was does SQL Server need this stuff on %SystemRoot% for some reason? Or could it be in the /bin for where SQL Server...

You could link the servers together and have one Agent call sp_start_job on the other server.

Alright, I'm leaving for a week. Behave yourselves on the thread.

Good to see some people know what they want. I especially like the pizza one. If I were close, I'd ask for Chichos pizza in Va Beach, but only if...

I agree with Gaby. The day your backup fails is likely the same day your disk array will fail. Don't play around. Make sure these work locally and reliably.

I'm confused,if you have the service account connecting to SQL Server, how do you get the individual accounts to come through? Typically we set up for Windows auth, and IIS...

Now that got a laugh out of me! :hehe:

The questions are almost always built on the native tools unless noted.

your client tool will indeed translate things.

We are slaves to our own drive.

Or we used to be. Noticed my post count is dropping like the average knowledge of people coming to DBA interviews.