Use charindex/patindex to find the place where the occurs and then SUBSTRING to extract around it.

Ah, interesting. Which culture?

Promotional here means advertising or announcing.

I can't think of one, but I'm sure that there would be something funny to use in the US. Maybe Pseudo-DBA

This is a cross tab. Search for that and you'll see lots of solutions.

I haven't seen this. Is there anything strange about the account? I'd run profiler and see what's using this account, what it's doing. that might help clue things in.

So, time%60 should work, correct?

8 disks is a lot, and I'd lean towards the 4 R1 volumes, but how busy is the database? If it's not stressed that much you might never see a...

Express is a production database, but on a personal level. It's designed to be used on a desktop, so if you have a production app that stores data on a...

That's what I suggest. Remove the constraints (or disable), delete, turn back on.

What's a "promotional DBA"

Do you have more information on what you're trying to achieve? Honestly this sounds like a test question, and I'd like to see you have produced some DDL or sample...

The space statistics sometimes don't update correctly or on the time you want. I haven't ever worried as this is a trend, longer term number and not a spot number.

The...

We're trying to nail this down.

Donations don't work since we have set gifts (book, shirt) that we give away to everyone, not to mentioned prizes that we purchase. We need...

Great points and this is an interesting debate. But it's not black and white.

Functionality has to be 100%. Or what the client needs the software to accomplish. Performance/speed/whatever we measure,...

It sounds like we're all saying something similar. You want to have the best code you can write, but it also has to get done.

The thing you can't do is...

From what I've heard, RC0 is tuned and ready. Only critical bugs left to be fixed. I don't think there's anything critical like it doesn't work, but more last minute...