FYI

Both selftest and Transcender now $59.XX until Christmas (2009)

I did not get any commission from them, I just ask my company to buy 70-448 and 70-452 from Selftest for me....

It is depending on the company.

My past experience was monitoring 40 servers by myself(in Healthcare Industry), now ~ 300 servers all over US (in Financial service) by only 2 DBAs...

IMHO, Good DBA should know the business process and good communication and act hubris.

The most important experience for Good DBA is he/she know how to act hubris.

Sorry if I tell...

No, Central DB is SQL server 2000, New Server in SQL 2005.

The main table in SQL server 2000, Need to insert in table in SQL server 2000 by query data...

Thank for all answer, yes they need to know customer 'XXXXXX' what product that he/she buy separate by each month for 1 -3 years and how much for each month.

As...

I am so lucky work in Big company.

1) No Coffee pot. They have coffee machine, pay by yourself if you need coffee.

2) No water fountain. Some kind of water from...

By the definition of efficient in Merrium Webster dictionary : " effective operation as measured by a comparison of production with cost (as in energy, time, and money) (2): the...

Is IT in company is in Line? or In Support group?

IMHO; IT is in support group, business does not care so much in IT (except company in IT that sales...

IMHO, the article lists all about idealogy even the author still comment he saw just a few.

Some people reply and proud that his/her company IT is one of the great,...

Sorry for not completely answer your question.

I use sql server 2000 sp 4 on windows 2003 standard edition sp 2.

Snapshot folder on the this server, snapshot agent run on this...

Thank Jo,

Yes it is strange too much.

By the way, I choose to reduce the database size by gradually reduce it from 70 GB to 30 GB....

Thank Jo,

I tried as your recommend, it did not work.

I checked deep in details in Event Viewer and I checked sysprocess and sp_who2 just before my...

Still can not find any dead lock.

Put outputverbose 3 in, I am asloso change distribution profile to get timeout 300 (from 15) and query timeout from 300 to 3000.

get the...

- No other detail like I/O

I change some parameter in Snapshot profile as follow.

-BcpBatchSize 200000 (from 100000 default)

-HistoryVerboseLevel 2 ( not change)

-LoginTimeOut 50000 (from 15 default)

-MaxBcpThreads 30...

We find nearly the same situation, we use merge replication and create snapshot for replication in ftp folder.

We just change to SAN, database size is 70 GB.

Snapshot fail and error...