Thanks Adi, Gail. I have got information from you that i needed to reply to them.

Hi Gail. I am confused a bit. see these links.

http://stackoverflow.com/questions/418082/sql-server-2005-generated-create-table-script-not-working

http://dbaspot.com/forums/sqlserver-server/375200-create-table-script.html

IN both of the cases users are creating tables with these settings. Am i missing something?

GilaMonster (10/27/2010)

yes i had told them that tempdb will be used heavily because of row versioning. As of now only 40 MB is used out of some...

Gail - as of today i am just going to run some DMVs to get an overview of performance.

Also, I think deadlocks should reduce coz of snapshot isolation....

Thanks Adi. I tried to explain them this but they were somehow of the view that if rowlevel lock *setting* is in place, they will get lesser deadlocks.

Furthermore, they had...

Thanks Gail.

Application team even said that they have applied *this* setting on a different server and a previous DBA helped them to do so!!

If you have truncated the log, you will need to take a full OR diff backup to start a new log chain.

another case, if ur db has never been backed...

Full Backups do not break transaction log chain.

However they do reset differential backups. If you take full backup wth copy_only option, the differential backup will contain pages that were modified...

any idea how do we check the same in sql server 2000? sysforeignkeys doesn't have is_trusted column..

Excellant post. Thanks for writing the article 🙂

I got a confirmation that these databases are going to be removed and wont be required in future. No further investigation required.

heh.

:sick:

We have the maintainence plan in place that throws email alert.

We do not use SQL Agent for job scheduling. we have a system called autosys that does scheduling part.

We...

No. DBCC is scheduled on a daily basis. Since we support several hundred servers, its not feasible to login manually and check on each server.

We have email notification setup for...

Thanks Gail. As of now I am collecting information about the affected objects. I'll need to show the details to concerned team and then we'll take action. As usual, this...

thats correct.

if...