Viewing 15 posts - 26,986 through 27,000 (of 49,552 total)
Are those tables heaps or clusters?
What's logical fragmentation? forwarding pointers? avg page space used? at the point that you need to do a 'rebuild'?
What version of SQL are you using?...
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
March 29, 2011 at 7:59 am
What other solutions have you tried?
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
March 29, 2011 at 7:22 am
I'll give you a hint, there aren't 2, there's only 1, and verifyonly isn't it.
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
March 29, 2011 at 7:19 am
Sounds like you're storing two things in one table, if you have entities and versions in the same table, maybe worth considering a split.
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
March 29, 2011 at 6:24 am
Starting to look like a bug, especially since it works as expected on SQL 2005. Let me get some additional opinions....
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
March 29, 2011 at 6:15 am
HowardW (3/29/2011)
GilaMonster (3/29/2011)
Try including SystemID and Reference in that index. They should not be necessary, but somehow it appears...
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
March 29, 2011 at 6:04 am
Odd, when the index is forced, it does key lookups.
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
March 29, 2011 at 5:56 am
Odd. What happens if you force the index (index hint)?
What editions of SQL?
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
March 29, 2011 at 5:51 am
ModestyBlaise84 (3/29/2011)
I believe that a good backup/restore and DR strategy is the only way to protect from damage caused by corruption. Full stop.
You would be correct there.
However, I am quite...
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
March 29, 2011 at 5:47 am
Post the plan please?
Index scan or clustered index scan? If the latter, indicative that the predicate is not sufficiently selective and the index is not covering.
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
March 29, 2011 at 5:31 am
There was nothing in my post that's 2005 or above only.
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
March 29, 2011 at 5:07 am
Don't use the select into db option, it's been deprecated since SQL 2000. The replacement is to set the recovery model, in this case to bulk-logged recovery and back to...
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
March 29, 2011 at 4:42 am
Nothing much. In what sense?
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
March 29, 2011 at 4:21 am
Query the tables.
Sorry, this is a rather vague question. Can you clarify what you're asking please.
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
March 29, 2011 at 3:56 am
steveb. (3/29/2011)
you may be better off getting a log-reader from a third-party like red-gate.
Redgate's one is only for SQL 2000. For 2008, Apex SQL Log ($1000)
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
March 29, 2011 at 3:55 am
Viewing 15 posts - 26,986 through 27,000 (of 49,552 total)