Viewing 15 posts - 31,186 through 31,200 (of 49,552 total)
I stand by the index suggestions I made above.
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
August 18, 2010 at 2:35 am
This is a forum not a chatroom. Everyone here is a volunteer, answering questions in their free time. Have some patience.
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
August 17, 2010 at 11:26 pm
Jeff Moden (8/17/2010)
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
August 17, 2010 at 11:20 pm
What recovery model?
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
August 17, 2010 at 11:17 pm
Robert Davis (8/17/2010)
This is just my opinion, but I believe it would have been possible for them to do database mirroring with a database in simple recovery mode.
Think 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
August 17, 2010 at 11:17 pm
It's not the backup drive that you need to look at. The error's not saying it can't write to the backup file. It's saying that it cannot write to 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
August 17, 2010 at 10:58 pm
Please read through this - Managing Transaction Logs[/url]
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
August 17, 2010 at 3:14 pm
gregory.perry2 (8/17/2010)
Where you speeking of a single index or a combined index with the two columns?
Single index on the two columns in the where clause.
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
August 17, 2010 at 3:13 pm
I would start with a clustered index on ID, then create a nonclustered index on (UserID, ID) and see how SQL uses them.
How many rows will a match on UserID...
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
August 17, 2010 at 3:13 pm
Mike John (8/17/2010)
You have run in to what may seem odd, but is correct (and I believe documented) behaviour.
Yup. That it is.
Columns in the outer query are visible inside subqueries....
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
August 17, 2010 at 3:10 pm
No, you absolutely do not want to consider a cursor. You want to do this in reasonable size batches, not one row at a time (which will take forever). ...
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
August 17, 2010 at 2:48 pm
456789psw (8/17/2010)
I reread Bob Article and there I see IO latches and NON IO latches.... which is what a EX_Latch is (NON)
No, it's not.
There are three categories of latches. (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
August 17, 2010 at 7:48 am
As with restoring any backup, the DB will be transactionally consistent once restored. If a transaction did not commit by the time the backup finished, that transaction will not reflect...
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
August 17, 2010 at 7:39 am
sqlusers (8/17/2010)
In this case, if some thing is in a transaction that transaction data will be rolled back rt? I don't know exactly.
In what case? If the DB...
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
August 17, 2010 at 7:21 am
Ninja's_RGR'us (8/17/2010)
exec sp_who2
Look at the blocked by column. That will list the spid that is most likely...
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
August 17, 2010 at 6:45 am
Viewing 15 posts - 31,186 through 31,200 (of 49,552 total)