November 30, 2015 at 8:40 am
have 3rd party app with table that has 6 image data type fields. When trying to delete over 1000 rows it hangs forever (no one on system). I realize the image data is not regular stored with rows. This is a monster table that needs to be pruned. My last good attempt, was to truncate table, and then bring back data from copy on log ship data base with only records I needed. Kind of ugly (have to make sure no new records and that log ship db is in synch). Am I probably SOL with any other solution other than this. (and yes there are indexes to match the delete)
November 30, 2015 at 8:44 am
tcronin 95651 (11/30/2015)
have 3rd party app with table that has 6 image data type fields. When trying to delete over 1000 rows it hangs forever (no one on system). I realize the image data is not regular stored with rows. This is a monster table that needs to be pruned. My last good attempt, was to truncate table, and then bring back data from copy on log ship data base with only records I needed. Kind of ugly (have to make sure no new records and that log ship db is in synch). Am I probably SOL with any other solution other than this. (and yes there are indexes to match the delete)
Is there a question here? If you are trying to get help with delete performance we need some information. Here is a great place to start. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 30, 2015 at 8:47 am
? is with these image data types are the deletes going to be problematic. I get the data points to these images fields (and yet it is bad design not mine)
November 30, 2015 at 10:30 am
tcronin 95651 (11/30/2015)
? is with these image data types are the deletes going to be problematic. I get the data points to these images fields (and yet it is bad design not mine)
How can we know? We don't know the data structures, index definitions or what you are actually trying to delete. We don't know your definition of problematic. Without some details nobody can do much but guess.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply