I totally agree with Sean Pearce

The question is not quite right. Fragmentation can be removed by running this because the table is rebuilt.

Your claim that Paul says you can't remove...

Disregard I've miss-look something.

I do dislike spamming post etc.

It's a waste of time. (still it improve our logic to read past thing that isn't worth it (maybe this post for some people), can...

It's nice to show a feature that can help in some circumstances but IMO the "it depends" still apply.

I might not get it 100% right on this but I feel legislation are failing to this, at least from what I've seen.

Often I see that disclosing vulnerability could end...

Here, the schema is used as a namespace, a name container just like in .Net for instance, no security are used against them (anyway everything use SysAdmin role privilege, and...

At one place 1:40

Another place 1:15

However for the latter, the SQL work required is much more intense and it could used another DBA

Oh nice question !!!

I'll add that in my tool box!

90% of all running software needs / run into maintenance / support (and this...

Only a few tenth of gigs but the foreign keys limit was reached which gave us some headache.

Also the object naming of 128 characters is way too low (sysname). Having...

Having another business person, a bean counter, or salesman, would be a poor disappointing choice for me

As it is for any company that evolve with technologies but has no idea...

This is nice, helpful and I hope to see more from you but the script take for granted that the searched object is unique amongst all other objects name even...

I'll do something else instead, don't try looking.

Oh my mistake, some variables have the same name but different scope so that might be my issue now.

One of them is having the right value while the other's empty.

I'll...

Sure,

The next component, in the control flow, I've added a breakpoint on the "PreExecute" event and check the locals variables in the debugger.

I've also do the samething a few component...