good Article,

I do not think the WMI Event handler is very reliable. I had it working for a remote UNC Fileshare but it often stopped listening without a reason. There...

Yes sorry you're absolutely right

To make more file groups you add ndf files to the database in the options. Relocation of tables can be done with alter table move statements. You might have to...

I would advise you to do an analysis of the objects in your db first. Make a list of table and index sizes. Then determine if it is possible to...

Select Case WHEN @b-2 IS null THEN @a ELSE @b-2 END

Will do nicely