samsql (5/4/2010)

---

Hi Grant Fritchey,

I have read little from ur book.

with respect

I think if u give more information about the profiler how to use it in your book will be more...

Random Ward Park, Missouri[/url]

Gianluca Sartori (5/5/2010)

---

Today I ran across the strangest threads I've ever seen here on SSC:

Want to buy a Ford car?

A sad story from Colorado

They don't seem to be automatic spam,...

Thamizh (5/4/2010)

---

Thank u all .I will try my best.In my work place we have Microsoft operations manager(SCOM) to monitor.But its irritating us because of popping lots of alerts and...

Schadenfreude-Mei (5/5/2010)

---

Thamizh (5/4/2010)

---

Thank u all .I will try my best.In my work place we have Microsoft operations manager(SCOM) to monitor.But its irritating us because of popping lots of alerts...

huston.dunlap (5/4/2010)

---

I am running an update statement on a single column within a large table (over a million records large number of columns). Locks are a concern with this update.

I...

Actually no, that sounds like a pretty good solution. Test, test, test though.

Good advice. Take a look at the SQL Server Dynamic Management Views. They're an amazing window into what's going on inside SQL Server. Most of the monitoring tools leverage them...

You're entering into a pretty crowded field. There are tons & tons of monitoring tools out there. The only advice I can give you is that you need a hook,...

Jurassic Park? Ah you young geeks. It predates Jurassic...

A CTE is just a part of the query that needs it. As a matter of fact, a CTE must be consumed by the very next statement and can't be...

Don't say stuff like...

Sorry, but that's every day's random word.

Just insert as needed.

No

No

That is great, but since it's basically right in there with the documentation, we...