Dugi (3/13/2009)

---

CASE ClientID

WHEN CHARINDEX('-',ClientID) <> 0 THEN

(CASE WHEN ISNUMERIC(SUBSTRING(ClientID,CHARINDEX('-',ClientID) + 1, 5)) = 1

THEN...

kwilthew (3/13/2009)

---

"Backing up the files of a SQL database while it's active is not a good way to back the database up."

If you're referring to the tape backups, those are...

On the SQL 2000 database, please run the following and post the full output

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

DBCC CHECKCATALOG (< Database Name > ) WITH...

CASE has two syntaxes

CASE < column or variable > WHEN < value > THEN ...

or

CASE WHEN < Boolean expression > THEN ....

They are not mixable. Change it to

CASE WHEN CHARINDEX('-',ClientID)...

kwilthew (3/13/2009)

---

My question is, if there is so much free space available within the database, is this not a good candidate for shrinking the database file to make it more...

Stamey (3/13/2009)

---

I understand, but it just seems like it would be so simple, with small indexes, to just rewrite the index in the correct order so that there would be...

I assume a junior DBA position.

1)if log file fills 100% then how...

Not sure I understand you.

Indexes should...

I haven't. The only versions that I've...

Indeed...

No I did not. I said (and I quote)

It (a full database backup) allows you...

http://sqlinthewild.co.za/index.php/2009/01/22/bad-advice/#comment-2997

Jack Corbett (3/12/2009)

---

Yeah, congrats. I'm looking forward to (hope I haven't missed) the Simple-Talk article on Profiler...

frankivey (3/12/2009)

---

The dumbass immediately told me this interview was over!!!! I was like you have to be kidding me?

I have worked as a DBA for the past 6 years...

Or a filegroup backup of the filegroup that contains that ndf or a file backup...

frankivey (3/12/2009)

---

Yes it is, I explained in detail that both backups include the system tables and objects, sorry I did not go into detail here but yes, I did explain...