Good luck, thanks, and I hope this doesn't drag into your weekend.

That's a good idea, Dean. Probably across time that gives you a good idea of how many people are using the server.

I'll have to try milk on the steak. Haven't tried that one yet, though I do like it on a hot grill.

One other thing I'd recommend is soak some red...

The answer, based on LIKE, is that you are looking for 3 character matches without the %.

So you have possible:

John

Jonathan

Jon

Joe

Jack

Of these, the 3 character ones are:

Jon

Joe

Of those, the...

Please refrain from profanity. It doesn't add to the discussion and it is not professional.

I have changed the question to have 1 answer and added a note about the...

Bob, I think it depends on your app. Here we've done both. Originally dropping them in the file system since we have all this web code and we can easily...

That's the thing. I don't know. If you had a snapshot database, I'd say it would go suspect, but since you don't, I have no idea.

At this point, I would...

You're welcome, Dugi. It's been a long time, but Backup Exec has off my list for those old reasons. The restore process is relatively simple now and I see no...

Good note, Ian and Lynn.

If I remember this, for a named instance, you'll connect with UDP 1434 and get the port that the instance is using, then you connect on...

I made a few changes to the formatting, so the article should read better now.

Good job Timothy. I've heard of most of these, but a nice reminder of what they do and how they work. Easy to forget them if you don't work with...

A PK is a logical structure. It means the field(s) that uniquely identify each row in the table.

This is implemented in SQL Server as a unique index. If you set...

Thanks for the update. Off the top of my head I wasn't sure why it wouldn't work, but then again I always would set the trace off and then save...

A maintenance plan can do this as well.

I'd try it, but have tests ready and be able to roll it back if you experience issues. IT sounds like a good idea to me.