Reply To: The Dangers of Not Upgrading
SQLServerCentral Forum
by Steve Jones - SSC Editor
25m ago
David.Poole wrote: Back in 2014 one of the talks at QCon was a talk from someone at NASA.  They said they had two problems that kept them up at night. ... I think the problem with portability of past work is one where we know where we want to get to, we just wouldn't start from here!  It feels to me as if we need an intermediary format to which software has to be capable of exporting its information.  A software vendor could write a utility to move from the intermediary format to their latest and greatest software but the utility should be separate from their main software ..read more
Visit website
Reply To: The Dangers of Not Upgrading
SQLServerCentral Forum
by skeleton567
3h ago
This reminds me of the error message I always thought would be fun to put in GPS software upgrades which would say "You can't get there from here". Rick Disaster Recovery = Backup ( Backup ( Your Backup ..read more
Visit website
Reply To: Estimated rollback completion: 0%. Estimated time remaining: 0 seconds
SQLServerCentral Forum
by xiaoluma
4h ago
Thanks, Jeffrey. I was hoping I don't need to talk to the other team ? I was hoping they would have some process to automatically kill some hung process, but obviously they don't. A side question, since this is one step in a multi-step process in an agent job. And after I stopped the job, the job has been running fine. what would be the consequences (except the DBAs from the other team might yell at us) if I just left the hung process along? Thanks ..read more
Visit website
Reply To: Improve Delete Performance in Table With Many Related Tables
SQLServerCentral Forum
by tgitchel
4h ago
No, I can't drop the index on the view in production, since it supports a count query that runs thousands of times per minute. Will look into the FK indexes ..read more
Visit website
Reply To: Updatable Views II
SQLServerCentral Forum
by Rune Bivrin
4h ago
You can remove the TOP  or the WITH CHECK option. Either will do the trick, as well as removing both. Just because you're right doesn't mean everybody else is wrong ..read more
Visit website
Reply To: Improve Delete Performance in Table With Many Related Tables
SQLServerCentral Forum
by Jonathan AC Roberts
5h ago
Could you change the method of deleting rows so that you drop the clustered index on the view, then delete the thousands of rows, then reinstate the clustered index? Also check that the the child tables have indexes on the FK columns relevant to the delete ..read more
Visit website
Reply To: iterate through servers with drive names
SQLServerCentral Forum
by mtz676
5h ago
Trying to list down the 10 largest files across all drives from all servers ..read more
Visit website
Reply To: Improve Delete Performance in Table With Many Related Tables
SQLServerCentral Forum
by tgitchel
5h ago
I was hoping that deleting multiple rows in a single statement would improve the overall performance, but deleting 5 rows yielded slightly over 5x the runtime ..read more
Visit website
Reply To: Improve Delete Performance in Table With Many Related Tables
SQLServerCentral Forum
by tgitchel
5h ago
Here are the statistics after restoring the indexed view and adding the recommended non-clustered index from the execution plan ..read more
Visit website
Reply To: Improve Delete Performance in Table With Many Related Tables
SQLServerCentral Forum
by tgitchel
5h ago
Here are the query stats before and after removing the index on the view:   ..read more
Visit website

Follow SQLServerCentral Forum on FeedSpot

Continue with Google
Continue with Apple
OR