Viewing 15 posts - 21,601 through 21,615 (of 49,552 total)
Restart SQL. I've seen this a couple times at a client, never dug out the root cause (I suspect there's some non-SQL resource being held somewhere).
Irritating, I know.
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 21, 2011 at 7:39 am
Koen Verbeeck (12/21/2011)
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 21, 2011 at 7:36 am
raotor (12/21/2011)
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 21, 2011 at 7:26 am
Keep both. They have a different leading column, so they are completely different indexes. The primary key can't be seeked for accountID filters or joins, those would have to scan...
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 21, 2011 at 2:19 am
Koen Verbeeck (12/21/2011)
Can anyone confirm that the link to the PDF provided in the thread is actually that very bad white paper?
Not a DBA, but...
That's the previous version of the...
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 21, 2011 at 2:15 am
A full backup does write to the transaction log, but it's just a couple of small entries. What's far more important is that for the duration of the full backup,...
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 21, 2011 at 1:01 am
Steve Jones - SSC Editor (12/20/2011)
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 21, 2011 at 12:49 am
Don't focus on whether the plan looks the same, SQL can generate very different plans for queries and, unless you're examining the properties of all the operators, two queries that...
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 21, 2011 at 12:47 am
SQLRNNR (12/20/2011)
can we wrap the artichoke in bacon and serve with a side of pork chop and applesauce?
I'm absolutely certain you're physically capable of doing that, yes.
Whether you want 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
December 20, 2011 at 12:04 pm
Ok, so in Paul's terms this is physical corruption.
Logical corruption would be orphaned rows, data violating assumed constraint, duplicate rows in a table that's supposed to be unique (but doesn't...
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 20, 2011 at 12:00 pm
SQLRNNR (12/20/2011)
Anybody else notice that the Headline article today has the "Editorial" pic? Is it an editorial or an article?:-D:-D
It's an artitorial (similar to an artichoke, but not as...
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 20, 2011 at 11:47 am
ronmoses (12/20/2011)
GilaMonster (12/20/2011)
What recovery model and what is your backup strategy and frequency?
Recovery model is full, the backup strategy is something I'll need to talk to the customer about. ...
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 20, 2011 at 11:33 am
p.s. For various severities of corruption and fixes, see http://www.sqlservercentral.com/articles/65804/
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 20, 2011 at 11:31 am
Dunno, what are you defining as 'logical corruption'? It's not a standard term.
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 20, 2011 at 11:30 am
ronmoses (12/20/2011)
GilaMonster (12/20/2011)
As for how to fix, you posted an incomplete checkDB output, there's at least one, hopefully two more lines to the output. Please post them.
Sorry, I was hoping...
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 20, 2011 at 11:15 am
Viewing 15 posts - 21,601 through 21,615 (of 49,552 total)