Gail

You mean to say even if there are objects with no stats e.g. table variables ni proc, still both estimated and actual plan will be same?

I remember somewhere I saw...

Well , I understand that Estimated execution plan might be giving just "estimates" but actual execution plans should have more accuracy.

In my question, I was referring to atual execution plan...

I understand that app or developers shouldn't be updating the tables directly. But this is a dev server and there are some master tables for which we don't have any...

A bad update can be anything that makes the data which it should not be. e.g. someone running update statement without where clause or someone updating incorrect values e.g. 'b'...

Thanks. it helped a lot. Sorry for not putting sample data.

Then what should be the best way to trace a hostname?

GilaMonster (4/3/2012)

---

mathew.walters (4/3/2012)

---

True, but then you could also delete audit data if you wanted to, I assume that it's not...

Got it....thanks.....had to expand the options.......

GilaMonster (4/3/2012)

---

Deleting audit data requires permission...

Gail, I dont see the screen you pasted in sql server 2008. Is it for sql server 2008R2 only?

Thanks So much Grant! Good to see big guys helping out "lesser knowns" 🙂

Grant Fritchey (4/3/2012)

---

Since you're trying to track data changes, batch_requests and rpc_complete are the two events I...

This one sounds really exciting and elegent...And new to me 🙂

Can you pls tell which events I can use or any reference link you have?

I understand I can google for...

This is exactly what I did 🙂

Only difference is I created a copy table with these 2 extra columns an dpopulated it for update/delete.

sqlnaive (4/3/2012)

---

For Dev environment, it's better to...

There are rare updates/deletes in this table. So performance is not an issue.Moreover it's a dev server.So no issue of performane again...

The development happens on local machines.I am finally thinking of going with trigger. I thought of using CDC, but that won't give hostname which is the main thing for...

Hi

Here are the answers:

1.BIDS is from original SQL Server licensed install. It is no trial version.

2.This is a server.

3.Edition: 2008 R2 (SP1) - Enterprise Edition on Windows NT 5.2...

It was really surprising to know that cast is internally implemeted as Convert!!!!