Hi Jason,

AKAIK it should respect the RG setting - where are you seeing the additional usage (e.g.perfmon/DMV's/Task Manager/ShowPlans)?

Thanks

Gaz

You can't add an Identity property to an existing field.

So the way the GUI will do that is:

Create a new table that does have the column with Identity property

Copying...

I'd imagine these are covered by the documentation you're reading, but a few things:

Make sure your classifier function is as lightweight as possible - every connection to SQL server has...

No one?

Oh well, amazing competition it was this year!

Can you post your query? It's probably using some structures not allowed in compat level 100.

Thanks

No problem, hope one of them works!

Ah, I see. Don't know for definite the behaviour of the default parameters under auto-refresh, but I'd hope they get re-evaluated at each refresh.

Guess you'll have to try it &...

You can also check the performance counters too:

SELECT d.name, logsize.cntr_value AS LogSize, logused.cntr_value AS PercentLogUsed

FROM sys.databases d

LEFT JOIN sys.dm_os_performance_counters logsize ON logsize.counter_name = 'Log File(s) Size (KB)' and logsize.instance_name =...

Does the Oracle query check both values in a row? Which would be this:

SELECT

ID,

Name

FROM

EMP_TBL

WHERE

(ID = 1 AND Name = 'foo1')

OR

(ID = 2 AND Name =...

Decimal(9,3) can store -999,999.999 to 999,999.999

Decimal(9,4) is -99,999.9999 to 99,999.9999

Not sure, but I think they're stored differently internally - decimal as an integer* with a factor of 10 multiplier, money...

I would hope not.

At the very least it would introduce...

Use an expression on the default that will set the value of the parameter to the previous day from midnight until (e.g.) 8am?

Something like:

=iif(DatePart("h", now()) < 8, today()-1, today())

or the...

Thanks guys. In this case, the 'whodunnit' is the updateserver, so no need for another field.

The updatetime is the date/time the sourcefile was last processed by the updateserver, and so...

Thanks Paul, that's a much better...

Ha, almost certainly!

Thanks for your input Sean, just had a nagging thought at the back of my head that I can put...