Thanks Gail for this one. And thanks once more for writing those 2 articles on analyzing performance on simple talk. I have used it several times in the past. 🙂

SKYBVI (11/12/2010)

---

I take a full backup of database1 and then restore it on database2,

then the database2 will have all the objects same as in database1 ( at time of backup)...

I would say a mix of both. mostly ad-hoc (hard-coded in the application).

the new database (after restoration) will contain everything that your full backup had. nothing more nothing less.

Yes i am supporting 3rd party apps. I was trying to figure out a way to track such queries at database level which don't complete because of timeouts. The application...

That's what i was thinking but it doesn't look so simple to me.

for every statement start i need to find matching statement end. if i dont find one, it means...

default trace wont capture dml operations..

are you sure you want to delete data older than x days? does all tables have same column name for date?

one way to store table names and column names(date) in...

I cant paste the code. Not sure if it's considered a good practise to paste someone else's code elsewhere.

In my previous company we had HP OVO agent that were deployed on each servers and alerted us for wide ranging issues right from blockings, deadlocks, backup failure, disk space,...

i just accessed the site twice.

http://vyaskn.tripod.com

:w00t: Didnt see the time of the post.

something like this?

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

The code in the link searches all tables. You'll need to limit that to one table.

Congrates Grant for the MVP award.

Got your book on execution plan today. Amazing stuff. 🙂

srinadh.ramineni (11/12/2010)

---

1) I am having one table and the customer is exported some data from an excel sheet to the table. After that some changes has been made and uploaded...