The quick answer is yes.

Google-Foo to the rescue.

Index Report:

http://www.sqlservergeeks.com/sql-server-engine-estimated-time-to-complete-online-index-operations/

Long Running Processes:

https://www.mssqltips.com/sqlservertip/3176/identify-completion-time-for-long-running-sql-server-processes-using-dynamic-management-objects/

SQL Cant estimate an actual rebuild completion time so get current running time.

http://dba.stackexchange.com/questions/76375/check-progress-of-alter-index-reorganize-rebuild

Google-foo CHOP!

Replication in 2008r2 is rock solid for me in my environment and we use it just for the purpose you are looking for, a read only copy for read only...

My thought is t3.code4=1 is unique and therefore the count will never be more than the base table (t1) so I agree you can remove that left join for count...

The ultimate solution would involve partitioning based on date, if your purging is date based, then all you would need to do is drop the partition to delete, much faster...

Sometimes SPN content can go missing after doing these type of migrations. Check that your SPNs are set properly on the NEWSERVER for the OLDSERVER

https://technet.microsoft.com/en-us/library/bb735885.aspx

I would advise using simple update scripts on your database objects before propagating them to production. Since your objects are simple text any scripting language/powershell can manipulate your t-sql...

Great article, didnt read any previous articles before (assuming you started at 1). It should be noted that with any production DB system, even one that seems simple, changing...

I would love to see what the partitioned table solution would look like.

The real answer here is that it doesn't really matter if a Tally table contains 10,000 rows or a million rows. It it's used properly and if it has the...

Notice your taking 'Fisc' information and from the tally table determining the Y W D information. But what if your tally table was just Y W D information, since...

That can happen on multi-processor systems that SQL is allowed to use.

I wish I had a true single processor system (no hyper threading or multiple cores) to have tested this on to see how it worked. Would I have thought...

Glad you found a solution, however you did NOT get a 'it cant be done' answer here in this 'forum'.

Greg R

Actually,

You can run the SQL Server Agent as a specified domain user.

http://msdn2.microsoft.com/en-us/library/ms191543.aspx

Greg Russell

What about creating optimized views for her to query against?

Just a thought.

Greg