Confio Ignite could also be of use. It is geared towards the different wait types and graphs the longest wait-types that have occurred on the server.

Alvin Ramard (11/25/2009)

---

I can't say Jason. I only have ten fingers so these bigs numbers can be...

what methods have you tried so far?

Knowing what you have done will help to focus suggestions and comments.

1 possible solution would be to try a case statement.

Is that a 73-way tie for first place on a daily basis?

I typically use a Char(1) as well. It works nicely for the Y/N or 0/1 or allows for the field to have additional codes added. I have seen...

Grant Fritchey (11/25/2009)

---

To a degree you're going to get what you pay for. You can bounce around the internet and you're going to find fantastic articles and blog posts, but...

Bru hinted at a very important thing here at SSC. We can offer suggestions for your query, but it is very difficult to provide accurate solutions without having the...

GilaMonster (11/25/2009)

---

Ok, I vote this as one of the more ... 'questionable' recommendations I've read here recently.

As your log file is very huge, and it is required to Truncate the...

Family

Woot - just cracked the top 100 here at SSC. It only took 1918 points.

Turkey for me

Turkey for you

Let's eat the turkey

In my big brown shoe

Love to eat the turkey

At the table

I once saw a movie

With Betty Grable

Eat that turkey

All night long

Fifty million Elvis...

Bob Hovious 24601 (11/24/2009)

---

Welcome to The Thread, Les!! 😀

In order to avoid redundancy and repetition and redundancy, we have established an informal rule that newcomers first review...

this article may be of help

http://hmorgenstern.spaces.live.com/blog/cns!28A6BE83102A0EB3!270.entry

We had this crop up for us a few months back. We removed the machines and then readded the machine to AD and the issue was resolved.

Seeing the forums...

SSIS 2008 packages cannot be run from an SSIS2005 store.

However, You can create SSIS2008 packages and run them from an SSIS2008 store to process data from SQL2005 and SQL2000 databases.