Viewing 15 posts - 10,651 through 10,665 (of 49,552 total)
Very likely.
Why?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2013 at 4:49 am
Can you post the delete's execution plan? Also what are the waits you see for the delete?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2013 at 3:15 am
Stale statistics perhaps? What happens if you update stats before running the delete?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2013 at 2:21 am
I didn't look at it in detail.
Run it against a representative data volume, check the performance. If acceptable great. If not, identify which parts are slowest and ask for help...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2013 at 11:59 pm
More nolock abuse. Are the users aware and happy with the fact that their reports could return incorrect data?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2013 at 11:47 pm
Make sure you're restoring the same backup you took, not another within the same backup file if you're appending.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2013 at 10:18 pm
The only way you can do that is by using dynamic SQL or a string splitter function.
WHERE SomeCol IN (@Var) means WHERE SomeCol = @var
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2013 at 1:05 pm
If a backup wasn't taken WITH CHECKSUM, then you can't use that option on the restore because there's no checksum to check. This is regardless of the database's page_verify setting.
No...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2013 at 1:02 pm
Jeff Brooks (12/11/2013)
Now I'm not sure why the picture didn't show up in the preview.
Never does. I suspect the attachment doesn't become permanent and hence accessible until post is clicked...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2013 at 10:16 am
Jeff Brooks (12/11/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2013 at 8:10 am
IgorMi (12/11/2013)
I think here Gail was thinking of enabling another isolation level (probably READ UNCOMMITED) in a programmable object, not on database level.
No, I was not. I was asking whether...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2013 at 7:53 am
That's a formatting issue that should be dealt with in whatever application is reading this data.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2013 at 4:34 am
bugg (12/11/2013)
GilaMonster (12/11/2013)
Have you considered one of the rowversion-based isolation levels?
I have considered this, but it will mean downtime to Enable READ_COMMITTED_SNAPSHOT ON, which unfortunately I cannot do anytime soon.
Also...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2013 at 4:21 am
Have you considered one of the rowversion-based isolation levels?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2013 at 4:01 am
Query, table definitions, execution plan please. Also, what are the wait types that you're seeing while the insert is running.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2013 at 12:03 am
Viewing 15 posts - 10,651 through 10,665 (of 49,552 total)