Thanks Chad. Jeff, I tend to agree with you as I've never removed a clustered index unless it was a poorly performing one and even then I've generally replaced it...

It turns out the web server is calling two stored procedures and as this was a migration from a single server (SQL and SSIS) to two seperate servers. The stored...

Thanks John, I thought as much but just couldn't find anything to confirm it.

Yes

Ok. That makes sense. Is there something I need to add to not take into account if it's less than 1000. In fact just if it's fragmented at all regardless...

I saw that, but was does "Full Safety only" mean and how is that implemented

Hi Anthony,

I totally agree with you I just wanted make I wasn't missing something. I've just started a new job and this how it's set up. When I...

It's not what the benefits of Stored procs are but why you would create a completely separate them from the database that they are actually calling. ie DB1 has all...

As you can see no Advanced Analytics Extensions as opposed to the previous screen shot from Microsoft

I have googled it.  Hence my problem every thing has  Advanced Analytics Extensions as an option to install and I don't have this option. I need to know...

Why do not have the option to install Advanced Analytics Extensions?

It is right. And I have checked with MS