I'm guessing a fairly dangerous switch depending upon how the application is written.

http://technet.microsoft.com/en-us/library/bb510680.aspx

The BOL article above is a quite informative on differences between the levels and also best...

I was using the MDW for a while until I realised that the MDW database size had exploded to 200 GB with about 10 Instances.

Ensure you configure the frequency...

Excellent - thanks for you response 😀

Ah, I get it now.

I thought that editing the Data Collection set in the MDW instance would change for each instance that is being monitored (I'm also monitoring my MDW...

R. Brush (7/30/2013)

---

DECLARE @Tol1 AS INT

, @Tol2 AS INT

, @Trig AS INT

...

ChrisM@Work (7/30/2013)

---

Gotcha. I think an efficient TSQL version might use EXISTS, something like this:

SELECT *

FROM MyTable

WHERE EXISTS (

...

That doesn't work as the WHERE just selects that car

John Mitchell-245523 (7/29/2013)

---

OK, so HAVING isn't going to work. But never mind. What you're looking for is something...

Brilliant - that was what I needed - I nearly had it at one point but put the 'as Value1min' and 'as Value1max' at the end of the THEN and...

John Mitchell-245523 (7/29/2013)

---

The parentheses still don't match.

TRUNCATE isn't an aggregate function in T-SQL, as far as I know. What does it do in MySQL? If you could supply...

Apologies I've had to simplify the query for this post and that variable has been left in - I've removed it from the original post.

I'm using HAVING instead of WHERE...

Ah, Yes I've read the original quote again and what you say makes more sense GilaMonster.

I was reading it incorrectly.

Thanks I'll set it and monitor it.

Will 64bit SQL Server max...

Edition: Standard Edition

Product Version: 9.00.4309.00

Product Level: SP3

Physical Memory_MB: 8184

min server memory (GB): 2.00

max server memory (GB) 4.00

VAS_GB: 2.00

awe enabled: 0

Looks like I am at a sufficient version SQL Server 2005...

I thought I would re-trace my steps again and see what is going wrong.

A little more background;

1. We have 2 instances on the server; Production and Test (Not ideal I...

I executed the xp_readerrorlog procedure a few times but changed the 1st parameter to read each log file as they only had about 3 months of data per file. I...