OK, this all said. The quizz question was regarding EM. So for most of us points not won. btw that's not equal to points lost

It depends on the role the dba is supposed to perform. I my case I'd describe it as firefighting. Every day is a supprise.

I manage +- 60...

don't position yourself (with EM) at the model-db when you want to create a new db.

I guess because groups don't have a loginname. Add it to the ms-sql-wishlist.

are you running in mixed / nt / sql security mode ? (check in Enterprise manager / server / properties / security) If nt-security is enabled or mixed-mode , you...

dbo = dust between objects 😉

It is annoying that members of the db_owner group don't create dbo-objects by default. They are not adapted to always mention the object-schema, but if...

I guess problems with schema started when ms introduced a "everyone" schema : DBO.

Making a "transparant" option is a terrific way to mistify objects.

Backside of this implementation is (of course)...

my first impression :

"SELECT @sSQL = 'EXEC ' + @srvName + '.master.dbo.DatabaseSummaryInfo'" would mean you have defined all @srvName-servers as linked server on the server where you run the script.

I...

Use clustering indexes so a dbcc dbreindex also affects your datapages. check your fillfactor settings. run sp_statistics and updateusage to get correct numbers. check BOL.

nulls are indexed. create a unique index on a nullable column and then try to insert 2 rows with null for that column. In that case null = null.

I...

check Denormalisation on the web. There a whole set of info needed to take that decision

create a parameter-table with a column "lastkeyvalue". Read that value for update and than its all up to you. Others cannot reach it until you release it.

That is if you...

This is how I resync users.

-- login sync

-- print db_name()

use userdb -- User-db

go

print 'print @@servername + '' / '' + db_name()'

print 'go'

go

declare @username varchar(128)

declare @Musername varchar(128)

declare @IsNtName bit

declare @sql_stmt...

erata : "decoment" should be "document"

/ "relaton" should be "relation" 😉

assuming a unit has only one "parent"-unit, you could have an entity "company" an other entity "Units" with a relation to "company" and a third entity "UnitRelations" where you decoment...