I would definitely suggest some kind of database modeling tool, which would allow you to reverse-engineer databases, and provide you with a graphical model of what's going on (tables, relationships,...

I also found Microsoft's "SQL Server 2005 Administrator's Companion" a great resource. Plenty of great information in there that spans the most important aspects of being a dba.

You mean besides the utter confusion it would create...:D

What a great way to spend a part of the morning on the last Friday before the holidays - thanks!!

Great, thanks for your input, Noel - it's good to know someone is doing what I'm doing!

I'm assuming that you are using scripts to change your recovery model - are...

An excellent article. I liked the points about trust and respect, as being the cornerstones to a good relationship between manager and employee. I also think that humility is a...

Obviously a very stimulating article, Steve - kudos. 🙂

I too used it as a starting point for how to track the total time that a proc was taking to run,...

Thanks for the reply, Erik, your setup definitely sounds interesting.

Maybe I didn't make myself very clear regarding my situation. I understand that Replication uses IUD statements on subscriber tables, but...

Thanks so much for your reply, Erik.

When you say that the recovery model for the replicated db is irrelevant, I'm assuming you mean because the entire db is being replicated....

Terrific - thank you, Mark and jghali for you input.

Thanks for the feedback, guys - I appreciate the insight.

Have a good weekend,

Simon Doubt

DBA, Fulcrum Publications, Inc.

Jeff Moden (11/29/2007)

---

Dang, Joe... between this and the NULLs problem, I'm thinking that you've landed in a doozy of a place. Who are these geniuses that you keep having...

Just figured it out:

I used:

SELECT ASCII(RIGHT(MyString,1))

FROM dbo.tblWeirdChar

and the ASCII code was 160, which is a non-breaking space.

So, I used:

UPDATE dbo.tblWeirdChar

SET MyString = REPLACE(MyString,CHAR(160),'')

And it worked!

Sorry for the self-posting.

-Simon Doubt

DBA, Fulcrum...

Here's my story - hopefully it helps:

I had several years of experience working as a technical consultant for a company selling a CRM/SFA database program. That was my introduction to...

In that case, you should create a new table with a new column something like this:

CREATE TABLE dbo.NewTable

(

ColRowID INT NOT NULL IDENTITY (1,1)

....

)

Where ... is the other columns, which shoud...