This was a good one.

I am with Lowell. I hate restoring master. Asking for issues, especially in DR for me. Easy to recreate logins in the worst case, but I tend to save them...

I'd agree as well. It can be hard to find a good manager, and it can be a great perk.

I've had a few LinkedIn pings recently as well.

Good to know it's working. I don't think networking is reliable, or guaranteed, but it works.

I'm with Alen. Probably a debate for another thread (or editorial 😉 ), but the amount spent on DR has to be in line with the risks.

It's possible they were working on something. The site is hosted by OSQA, so maybe they fixed something.

Or broke it and fixed it :w00t:

LOL, I guess lots of people think that developer does sound better than programmer. There's definitely something to the marketing, and if it keeps your job onshore, why not call...

I've tried to unsunscribe from this thread, but I want notification on other threads, and always manage to end up back on this thread.

At times it's a little overwhelming, but...

Brandie Tarvin (9/1/2010)

---

Hey, for any lurkers in the neighborhood of Jacksonville, FL, we're doing a "So, you've never spoken before" topic for September's monthly JSSUG meeting. Everyone who wants to...

What problems are you having? Seems to be OK for me right now?

I'd follow Wayne's advice. Try a distinct, but it the records aren't completely unique, you might need another filter.

I like Grant's suggestion. Don't shrink unless you have to, and then only shrink to the size it should be based on transactions. Make sure you have log backups going.

If...

Don't use substring.

Use charindex and look for a charindex() > 0

http://msdn.microsoft.com/en-us/library/ms186323%28v=SQL.100%29.aspx

This might help:

http://www.sqlservercentral.com/articles/Crosstab/65048/

Or this: http://www.sqlservercentral.com/articles/Advanced+Querying/aggregatequeries/2177/

GilaMonster (8/31/2010)

---

Alvin Ramard (8/31/2010)

---

For...