Many, many congratulations. Well earned and well deserved.

A Jaeger on me Kathi!

No disagreement here. Now, we need to talk about this bitmap field. Shouldn't that simply be another table & foreign key?

"Authentication failed" is a security error. Whatever login you're attempting to use doesn't have the correct access on the server to which you are linking.

Interesting concept. It could prove useful. I've voted for it.

Oopps. My bad.

ps: I'm just Committed (commitable, committing, whatever) not a HallofFamer.

😛

But wait, does "niftier" mean you're a sequeler or one of them thar ess cue ell 'ers?

Well, let's push it along a bit.

SEQUEL Server 2008 is nifty!

Looks like the post has smileys in place of parenthesis, but yeah, the query is working fine once those are replaced.

I don't have supporting documentation and lists of tests at hand, but we generally either call for all parameters to be passed and then update all the columns every time...

Uh-oh. Heads up! Celko incoming!

😉

But seriously, that's getting into the natural vs. artifial key argument. If the he is following the natural key approach and the smallint field (bitmapped, honestly,...

That means a default clustered index has been created on the primary key of the table. From your description, I assume on the column CountyId.

However, if you only have a...

I took that straight from the link provided. My bad for not checking it. Here's a quick & dirty version that works correctly

SELECT (a.cntr_value * 1.0 / b.cntr_value) * 100.0...

Here's one way to use the data:

SELECT (a.cntr_value * 1.0 / b.cntr_value) * 100.0 [BufferCacheHitRatio]

FROM (SELECT *, 1 x FROM sys.dm_os_performance_counters

...

You can get some from queries. For example, the dynamic management view sys.dm_os_performance_counters contains the buffer cache hit ratio.

Sorry, I stated that badly. I'm not aware of any exceptions.

The one thing that might be an exception would be that the SELECT statement can only return the same number...