Users don't log into a database. They log into a server (SQL Server instance) and access a database. As Brian mentioned, only tracking every query would tell you when they've...

In ASCII text, Windows systems, we often have carriage return (CR) and a line feed (LF). Unix can be different.

Look up ASCII codes and experiment. CHR(13) should work, but Excel...

Go with Itzak's book.

Grant is a little shy, but I'd recommend his execution plans book as well. Available as a promotion from Red Gate software in our newsletter and on...

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...