I've been googling for an hour and really can't find anything. The concern expressed to me was that "all server" triggers create a virtual paging file that can fill...

Tried a few things including the suggested scripts from Steve. Since our production environment uses mount points and because sp_databases returns null for larger databases, etc etc, I'll probably...

It would be interesting to see something in black on white on the fact that intellisnap will replace snapmanager. Especially since we've been agitating for some training on...

Thanks David. I'd like to hear more about this idea that Netapp may abandon snapmanager. Last Sunday we successfully took a final backup of our databases, shut down...

As we stumble our way into using SnapManager, I read this article by a Netapp technician/blogger who says to avoid running index maintenance during "snaps."

https://communities.netapp.com/blogs/abhishek/2012/06/05/things-to-keep-in-mind-when-running-index-optimization

So my next question,...

I can't change server level settings like that without a lot of meetings etc. I'm experimenting on a test system with doing the first big select statement into...

Thanks again. I think I'll hold off on changing the production database until this last conversion from legacy finishes November 30th. After that there will never be another...

Thanks Jeff. There is a clustered primary key so I'll rebuild that. Since this will take a while I should probably drop all of the columns in question first...

No indexes on that field. I decided to try just dropping the column and recreating it. Only issue was that it had to be recreated with NULLs allowed...

Yes it might be easier to just leave our current native sql backups in place for now on the primary, restore a copy of the database on the standby filer...

Yes, in fact if you reduce the initial size in the GUI ( management studio ), then script that action out to a query window you get something like this....

We know its not recommended in general, and would need to rebuild the indexes after shrinking. But since the file now has 300GB showing as free space inside...

Thanks, do you know if sql 2012 has a more flexible job scheduler? I can use something like this, but it means editing several jobs.

declare @RunDate datetime

set...

If you're referring to the Netapp snap manager for sql stuff, no we haven't instituted it yet. As a production DBA I was all set to take some training...

As far as Systems Admins taking over sql server support duties, I think that can work as far as infrastructure and backups ( where backups are handled by something other...