I don't suppose the book's website has a list of error corrections or anything so I can go through and mark the inaccuracies?

Thanks for the replies, it is good to hear that everyone is having the same issues we are running into.

I just wanted to make sure there wasn't some silver bullet...

So you just asked SQL server for the datetime instead of ever asking the user's local machine, and just recorded that on the record (and used UTC on the record)?

How...

Grant Fritchey (10/21/2009)

---

I absolutely recommend going to a file and then importing to the database. It's just cleaner and easier.

However, depending on the counters you're interested in, you can get...

I did not know that existed, I will have to spend some time on that part of the site... though at the same time I also fear it 😉

(I...

Makes sense, thanks!

The issue with using the query attachment option is that if I do that it executes the query in a new session so I wouldn't have access to...

It is a char(24) field.

What I am trying to do is get the MAX datetime and then do a datediff to see if the MAX counterDateTime is > than GetDate()...

I noticed when I display the data to a text box in SSRS 2008, it follows the date with a small filled in rectangular character.

However, this data being displayed is...

-----------

1096896

(1 row(s) affected)

-----------

1096910

(1 row(s) affected)

-----------

1096935

(1 row(s) affected)

-----------

1096935

(1 row(s) affected)

Would outputting to a text file and then opening it in something like TextPad allow me to see such a character?

Ask the perfmon people at Microsoft.... bunch of jerks if you ask me! 🙂

Not my work, perfmon created the tables.

So I ran:

SELECT ISDATE(CounterDateTime)

FROM [CounterData]

WHERE ISDATE(CounterDateTime) = 1

Nothing, every record...

I will go and check the table for any values that don't seem to match.

Would I just do an isdate type deal to look for that?

All the values that I...

You are completely correct, we are using the server as "the copy" of the code.

We use VSS and are migrating to TFS. I am thinking that once we get...

Yeah, but for the shoe string budget they had, and the really underpowered computers (even for that time from what I understand) they did an amazing job!

I was really sad...

The execution plan for the slower query is broken over 3 or 5 individual queries, so that makes it harder for me to compare.

HOWEVER, I also need to read up...