Viewing 15 posts - 11,446 through 11,460 (of 49,562 total)
Have a look at the sys.dm_os_memory* DMVs and the memory-related counters for SQL Server in perfmon.
October 3, 2013 at 4:17 am
Yes, unless the archive filegroup was marked read only before that 7/31 backup and remained that way.
October 3, 2013 at 3:55 am
If you can't change the hardware, tune the queries. Goal being to reduce as much as possible the amount of data the query needs to read.
October 3, 2013 at 3:11 am
I think the question would be more appropriately phrased 'any other similarities?', because other than that they can truncate the log (checkpoint in simple, log backup in other recovery models)...
October 3, 2013 at 2:59 am
I would imagine not, alter database usually requires an exclusive database lock.
October 2, 2013 at 3:41 pm
Don't shrink your log. Please read the article I referenced.
If the same database pages are getting repeatedly modified, log backups can be larger than the diffs.
October 2, 2013 at 3:09 pm
GilaMonster (10/2/2013)
October 2, 2013 at 3:07 pm
I tend to agree with Michael. File/filegroup backups make backup times faster (because you're only backing up part of the DB each time), but they massively complicate restores. If you...
October 2, 2013 at 12:21 pm
Did you read the article I referenced?
If your log is growing, there is something modifying that database. Logs won't grow without log records being added, that is changed to the...
October 2, 2013 at 10:28 am
Take a read through this: http://www.sqlservercentral.com/articles/Corruption/65804/
October 2, 2013 at 9:54 am
If that was one of my ciients' databases, I'd be scripting, exporting and recreating it. Probably someone hacked the system tables back when that was a SQL 2000 database and...
October 2, 2013 at 9:49 am
Sean Lange (10/2/2013)
Jeff Moden (10/2/2013)
Koen Verbeeck (10/2/2013)
On topic:http://www.sqlservercentral.com/Forums/Topic1500646-1292-1.aspx
Oh my. I hope that's not what they're teaching in "university" now. :sick:
If you have read any of the other posts by...
October 2, 2013 at 9:46 am
Yes it's a single point of something, but losing the witness will only remove the ability of the mirroring to automatically fail over. It'll have no other effect.
October 2, 2013 at 9:43 am
FROM CalenderTable LEFT OUTER JOIN TableWithOtherDatesInIt
That's the starting point. Your where clause was filtering out any nulls and essentially turning the join into an inner join.
You don't want to be...
October 2, 2013 at 7:36 am
A log file will only grow if there's activity being logged.
As for log maintenance, see http://www.sqlservercentral.com/articles/Administration/64582/
October 2, 2013 at 7:20 am
Viewing 15 posts - 11,446 through 11,460 (of 49,562 total)