Why?

Lynn Pettis (3/9/2010)

---

CirquedeSQLeil (3/9/2010)

---

Care to...

Fantastic - now that we advertise for hair curlers, what will be next?

Thanks for posting back. I presume this query solves your unwanted data issue.

Care to enlighten us?

vaibhav.tiwari (3/9/2010)

---

9 9 9 9 5 5 5 5 3 3 3 3 1 1 1 1

Out of the above numbers which 6 numbers will make the total 21.

only addition...

As Gethyn and Luke have said, I also restart the service with Password change. I normally schedule this kind of change during a maintenance window. This is based...

Very interesting. I don't get that kind of result on any of the SQL 2005 or 2008 servers that I tested it against.

Did you change 'YOURDBNAME' to be the...

What do you get when you rewrite the select query as follows:

select MachineName, ObjectName, CounterName, Countervalue, TimeRead

from repl_latency_cte

where ObjectValue = 'Memory'

And CounterName = 'Pages Input/sec'

And countervalue > 20

I would setup some monitoring to watch the tempdb growth. You need to find what is causing the database to grow like that.

ALZDBA (3/9/2010)

---

Yes, Yes, Yes ....

- master is a must !

- resource db files .... maybe ... so YES too ! but only once after every install/hotfix/cu/sp

- model ? I...

And three for the record. I agree with Lynn and Gail. Backup your system dbs (master, model, msdb). This will save you time and effort should a...

pshaship (3/9/2010)

---

The above script is NOT working as expected. It's displaying only 1 row that to system table info as below:

DBName TableName IndexName ...

Nice explanation and test setup Oleg.

I guess that psychic helmet I bought is working correctly then. 😀

Beedeebeedeebeedee

I guess I spelled it wrong - is it Twiggy or...