Forum Replies Created
Viewing 15 posts - 21,466 through 21,480 (of 49,552 total)
-
RE: Database in 'Recovery Pending' State -Error 945
Bear in mind there may still be transactional inconsistencies (where part of a transaction completed only), you could have orphaned rows (foreign key constraints that are now violated)
You need 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
I read some Shadowrun fic a while back, never tried to play it, never even read the rules. I do like the concept of the world.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Database in 'Recovery Pending' State -Error 945
Wait. CheckDB has to complete. Since the DB is in single user mode, you won't be able to connect to it from any other session.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Stefan Krzywicki (12/30/2011)
SQLRNNR (12/30/2011)
Stefan Krzywicki (12/30/2011)
Cool. I used to play RPGs, but just can't get interested in them any more.This is what you guys are talking about, right?
Sometimes! Depends...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: 8hr hour query ?!?!?!?!?!?!?!
Ah well, was a try.
Probably best to stick with the forced non-parallel version.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Stefan Krzywicki (12/30/2011)
GilaMonster (12/30/2011)
Ninja's_RGR'us (12/30/2011)
Good game Steve???Err, yeah. Sorry. Too much online gaming lately.
On the plus side, an online play-by-post roleplaying game is better than nothing and can be a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: I'm stuck on this problem - Msg 4104, Level 16, State 1, Line 25 The multi-part identifier "pp.PhoneNumber" could not be bound
Doesn't sound like the most efficient option. I'm sure this is a simple problem to resolve, if you can post the table definitions
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: choose a random record
Dev (12/30/2011)
Now would you please explain me the requirement in details? I would like to know the business case where random values (for example employee names) are required....Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Jonathan Kehayias's book 'Troubleshooting SQL Server', chapter 6 - Blocking. There's about a 7 page 'summary' on locking, isolation levels, locking modes, etc. It's a free download from SimpleTalk (or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: I'm stuck on this problem - Msg 4104, Level 16, State 1, Line 25 The multi-part identifier "pp.PhoneNumber" could not be bound
Can you post the CREATE TABLE statements for the following please?
dbo_HomePhone hp,
dbo_Address_G1 ad,
dbo_PhoneDelivery pd
dbo_PersonPhone pp
dbo_Subscription
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Creating a suspect database.....
jr.sqldba (12/30/2011)
I have created database and enter the values in to that table.and also perform the explicit transaction after that in another window i wrote the below steps
SHUTDOWN WITH NOWAIT;
GO
but...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Transaction Log Is Full
george sibbald (12/30/2011)
chetanr.jain (12/30/2011)
Adding to Gila's Comment :In simple recovery model, Log will be cleared once the checkpoint is fired or Free space falls below 10-30% of the total space...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Transaction Log Is Full
chetanr.jain (12/30/2011)
In simple recovery model, Log will be cleared once the checkpoint is firedWell, not quite. Checkpoint is what truncates the log (marks space as reusable), but there's no guarantee...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Ninja's_RGR'us (12/30/2011)
Good game Steve???Err, yeah. Sorry. Too much online gaming lately.
On the plus side, an online play-by-post roleplaying game is better than nothing and can be a lot of fun...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Automated Update Question
Honestly, unless the relationships between the tables are hectic complex, or there's really convoluted logic, or you're updating customer names several times a second, I'd go for a trigger. Well...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 21,466 through 21,480 (of 49,552 total)