Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-23 : 10:40:55
|
| Nigel Rivett submitted "Usual cause of a continually growing large transaction log file and how to deal with it." Article Link. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-23 : 14:40:12
|
| Cool Nigel. Now I can just link to your article instead of repeating myself each time this question is asked in the forums.Tara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-23 : 15:39:23
|
| Can you at least answer the question on how to get the middle 500 rows?Brett8-) |
|
|
|
pshisbey
Starting Member
1 Post |
Posted - 2004-12-09 : 18:08:52
|
| Great article. Made the t-log issue much clearer for me. Thanks Nigel. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-09 : 21:44:02
|
quote:
Originally posted by X002548
Can you at least answer the question on how to get the middle 500 rows?Brett8-)
select top 500 * from tbljust define half of what's left to be ordered in front of this 500 and the rest behind so this will always be the middle 500 rows.or this might help.http://www.nigelrivett.net/Cursors.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Article: Dealing with a large transaction log file