Anamika (10/17/2010)

---

Before going for a live data base what are the things we need to consider and steps should be taken as a vibrant intuitive DBA?

On memory utilization, space, Performance...

Jeff Moden (10/17/2010)

---

I apologize for puting you on the spot but what do you consider an appropriate use for them is especially since...

SQL Server and Windows offers a whole bunch of monitoring and management stuff for free. Perfmon and server-side traces can be used to keep an eye on your systems. If...

Except for certain operations the flush the cache, it's pretty much being constantly flushed, depending on the pressure on memory. But, to my knowledge, there's no way to know for...

gianmh (10/15/2010)

---

Hi I would like to get the average number of transactions perday from our sql server installations, is there some built in functionality for this or does it require...

Oooh, I get to be the first one to say it...

"THERE CAN BE ONLY ONE!"

Welcome to the party.

GilaMonster (10/15/2010)

---

And just when I thought the situation at That Client couldn't get any worse....

<headdesk><headdesk><headdesk><headdesk>

(No, I'm not going into details, it's a little too sensitive a topic for that. Just.......

Rob Schripsema (10/15/2010)

---

nick.mcdermaid (10/14/2010)

---

If you search on a covered non-clustered index on a table with a clustered index, you get a bookmark lookup where the index goes and looks up...

Steve Jones - SSC Editor (10/15/2010)

---

Who throws a can of soda out of a car? That's insane. Almost makes you want to hook up a camera and 10 min...

But, what if a given query really benefits from parallelism? Now you've just taken it away.

However, I do notice that more...

Try using sp_help_revlogin[/url].

Ninja's_RGR'us (10/15/2010)

---

Grant Fritchey (10/15/2010)

---

Views aren't compiled. If you want to know which views are dependent on a table that you've modified, you can use sys.dm_sql_referencing_entities. If, on the other hand,...

Maybe I don't understand the question.

DROP INDEX myschema.mytable.myindex

This usually does the job. Then you can create the index.

If you mean, what's the best mechanism for determining which indexes need to...

Views aren't compiled. If you want to know which views are dependent on a table that you've modified, you can use sys.dm_sql_referencing_entities. If, on the other hand, you're curious about...

Amu (10/14/2010)

---

Any one has comparision sheet between Idera's Performance diagnostic tool and Quest Foglight performance advisory tool? If so, Can you share with me your finding?

I am looking into thest...