Well, 'can' and 'should' is a little different.

Yes, you can have two instances on the same box, where you have two databases with the same name (one in each instance),...

... it depends..? 😛

But probably, though we don't know, since the op hasn't really explained what it's all about.

Though it feels that nowadays a bitmap is overly complex, and 'saving...

..nah, I have longer hair than Joe 😛

But seriously, 'good' or 'poor' aren't traits whether it's a key or not (primary, alternate, candidate etc).

Anything that serves as a unique identifier...

I'm a bit confused as to what you really want or need...

A bitmapped number suggests that there is some meaning involved, and a key with a meaning is a poor...

My bad, I'm sorry..

That row should naturally read:

sum(case f.actif when 0 then 1 end) as NbActifFalse

/Kenneth

Would something like this do?

select p.person_id as Idpersonne,

sum(case f.actif when 1 then 1 end) as NbActitTrue,

...

Though cpu time is really of no concern - at least not in this case.

It's a volatile measure at best (as we've seen, since it fluctuates > 100% between times)

The...

Hmmm.... I'm not so sure that the LEFT JOIN is so bad...

I'd say it's the better one of the four by a longshot.

This is the 'small table' examples from Adventureworks,...

Just update the darn flag to 1 regardless.

If it's a 0 then it becomes 1.

If it's a 1 then it's still a 1.

No need to be fancy with triggers and...

You're using the wrong datatype...

From BOL:

[ @stmt = ] stmt

Is a Unicode string that contains a Transact-SQL statement or batch. stmt must be either a Unicode constant or a variable...

Well, it seems like a straight forward 'acces denied' error...

Whatever account that was trying to do a backup got denied.

'spx_mkexpbkp' seems to be some sort of homegrown proc?

As to the...

If all your files has been wiped, then I'd say that all the traces as to who dunnit is wiped as well.

Regardless of that, since all log on as the...

It's when you cast the varchar column as int in the where clause that causes the conversion error.

select RA.RuleID, AA.ApplicantID,AA.AttrValue,RA.AttrValue,AA.CastValueAsType

from @Rules_AttrValues RA

...

Oh really? Must have missed that.. I read it as a question of what checksum was used for.. 😉

Anyways, what use would anyone have on how MS have implemented these...

A link it is:

ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/tsqlref9/html/e26d3339-845c-49c2-9d89-243376874c13.htm

or if the link fails (it refers to BOL - Books On Line - your trusty manual for SQL Server)

download and install BOL from here

http://www.microsoft.com/downloads/details.aspx?FamilyID=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

and...