Viewing 15 posts - 25,741 through 25,755 (of 49,552 total)
george sibbald (6/4/2011)
its perfectly reasonable to start with the full restore in norecovery and have the log restores in standby mode.
I'm just wondering if the wizard does something stupid...
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
June 4, 2011 at 3:29 pm
A covering index won't make that seekable. There's no predicate (other than join predicates) for the Cov table, it's probably faster to scan than to seek for each value in...
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
June 4, 2011 at 11:33 am
You said you restored the full backup NORECOVERY. Try restoring it in STANDBY instead.
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
June 4, 2011 at 10:04 am
Books Online?
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
June 4, 2011 at 10:01 am
Ninja's_RGR'us (6/4/2011)
GilaMonster (6/4/2011)
With normal row versions the version can't be removed until all queries that could possibly need it have finished. May be similar with triggers, I'm not sure.
I don'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
June 4, 2011 at 5:49 am
Please post new questions in a new thread. Thanks
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
June 4, 2011 at 5:44 am
15 minutes in what context?
Table definitions please. Hard to tell what's going on 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
June 4, 2011 at 5:42 am
With normal row versions the version can't be removed until all queries that could possibly need it have finished. May be similar with triggers, I'm not sure.
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
June 4, 2011 at 5:39 am
The data cache just caches pages from tables, it doesn't care what query ran to get those pages into cache, it just cares that the page is there. Anything 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
June 4, 2011 at 5:33 am
Er, no. A schema stability lock is compatible with every other lock, other than schema modification. All queries must take a schema stability lock to ensure the table isn't changing...
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
June 4, 2011 at 5:22 am
Is there anything else running in that transaction (don't care about other processes)
Trace everything coming from the SSIS is you don't 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
June 3, 2011 at 3:27 pm
What's the blocking session ID? Are there any other operations in the transaction?
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
June 3, 2011 at 3:05 pm
The one that's seeking is not seeking for the join. It's just seeking for the where clause predicates
timestamp BETWEEN @FromDate AND @ToDate
AND (Table1.ClientID = @ClientID)
The join is done later 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
June 3, 2011 at 2:48 pm
Execution plan?
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
June 3, 2011 at 2:17 pm
I think you might want to do some reading on locks and transactional consistency. What you're describing there is desired behaviour. You don't want users to see transactionally consistent (dirty)...
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
June 3, 2011 at 2:11 pm
Viewing 15 posts - 25,741 through 25,755 (of 49,552 total)