Viewing 15 posts - 2,116 through 2,130 (of 4,745 total)
the weekly newsletter already reports when SPs come out. I don't see a need to keep up with CUs, but Steve does maintain a build list.
October 18, 2010 at 6:20 am
David, thanks but don't go there. the part of the query that performs badly only accesses one table but it is unioned to another query which accesses 19 tables. (then...
October 18, 2010 at 5:41 am
thanks for the feedback. Like any other non-read activity, shrinks are logged.
October 17, 2010 at 2:16 pm
October 17, 2010 at 2:13 pm
Kimberly tripp has a series of articles on log files. This is maybe related to vlf size?
start here: http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx
October 17, 2010 at 5:00 am
Run command select @@version
7.0.nnnn = SQL 7
8.0.nnnn = SQL2000
9.0.nnnn - SQL2005
10.0.nnnn = SQL2008
10.5.nnnn = SQL2008R2
nnnn denotes the SP\Hotfix level.
On this site do a search on 'build list'. Steve jones the...
October 17, 2010 at 4:15 am
Hemantjemmy (8/11/2009)
I think I have missed two word in above comment which created confusion.
What i meant was truncate & shrink transactional log file only after taking full backup.If your database...
October 16, 2010 at 5:11 pm
Looking at this from a different viewpoint there are other advantages to removing that redundant data.
all maintenance tasks will run quicker, checkdb, reindex, stats updates. Backups will also run quicker...
October 16, 2010 at 1:45 pm
striping will reduce your backup times. You can do individual file or filegroup backups (see books online). If you switch to using these ensure your complete backup strategy means...
October 16, 2010 at 1:06 pm
no probs. you now have a model log file with a different name to how it was installed but I don't think that will ever cause any problems. Just be...
October 15, 2010 at 8:26 am
'E:\SQLData\model.ldf' - so is that file there? are you sure its not called modellog.ldf?
October 15, 2010 at 7:53 am
Brandie Tarvin (10/15/2010)
george sibbald (10/15/2010)
As for the can of soda, I'll be more accurate next time. 🙂
That was you? Shame!
And here I thought it was the guy from the other...
October 15, 2010 at 7:48 am
SwayneBell (10/15/2010)
I'm getting the sense that the exposure from data loss in one of these databases is inconvenient, but not fatal? (i.e. some new jobs may fail, new users could...
October 15, 2010 at 7:46 am
use notepad to view the errorlog, any errors in there?
October 15, 2010 at 7:25 am
GilaMonster (10/15/2010)
george sibbald (10/15/2010)
GilaMonster (10/14/2010)
CirquedeSQLeil (10/14/2010)
That's quality entertainment
Yup.
Currently watching them test to see if a cup of soda can kill you through a windscreen if thrown while cars travelling at...
October 15, 2010 at 7:21 am
Viewing 15 posts - 2,116 through 2,130 (of 4,745 total)