Viewing 15 posts - 20,311 through 20,325 (of 49,552 total)
Then I do hope this is not a particularly important database.... You're going to lose some data
Put the database into single user mode and run the following (though I suspect...
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
February 15, 2012 at 3:46 am
Errr, I'm talking about a regular, normal database backup. Do you have a backup that was taken before the corruption occurred? A backup that does not contain the corruption.
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
February 15, 2012 at 3:24 am
Nolock is not an optimisation technique.
SELECT * FROM table means get me the entire table. Short of faster hardware, there's no way to speed that up. For that to be...
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
February 15, 2012 at 3:12 am
That CPU and IO is cumulative since the server last started. You didn't say when the server was last started, but if that was quite some time ago, those numbers...
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
February 15, 2012 at 3:10 am
Got a clean backup? (a backup without the corruption)
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
February 15, 2012 at 3:08 am
rheinhardtp (2/15/2012)
At the moment with my querry i am getting duplicate records as i transfer the complete table....
So just copy the rows where the timestamp has changed. Without seeing 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
February 15, 2012 at 3:06 am
Gianluca Sartori (2/15/2012)
According to MSDN, the NULL bitmap size is calculated as:Null_Bitmap = 2 + ((Num_Cols + 7) / 8)
This suggests it could change. I've never seen this happening though.
Dunno...
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
February 15, 2012 at 3:04 am
How do you define a row as not having changed?
If a row has changed, do you want to put a new version of it into VRWATSYSTABLE, or update the existing...
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
February 15, 2012 at 1:42 am
In simple recovery the log is marked reusable when a checkpoint occurs, not a backup. There are all sorts of things that can prevent a log from been reused even...
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
February 15, 2012 at 1:38 am
Suspended means its waiting for something, it's not running.
What you're asking for is a timeout, it's something set in the client application, the length of time that a client app...
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
February 15, 2012 at 1:36 am
That is not data corruption. Database corruption would give you high-severity errors, not wrong results.
Post table definition, post exact query.
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
February 14, 2012 at 3:06 pm
You're trying to insert more data into a column than it will allow. Check the lengths of the various character fields in that table against the data you're trying 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
February 14, 2012 at 2:41 pm
That's the output from 1204, there should also be another deadlock graph before or after, far more detail.
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
February 14, 2012 at 2:39 pm
Yes. Why are you asking?
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
February 14, 2012 at 12:29 pm
Switch traceflag 1222 on. That will result in a detailed deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here....
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
February 14, 2012 at 12:29 pm
Viewing 15 posts - 20,311 through 20,325 (of 49,552 total)