Viewing 15 posts - 41,971 through 41,985 (of 49,562 total)
free_mascot (1/6/2009)
In addition to the above, I guess Replication do not require index on all the columns. But it require a Cluster Index to get the article replicated.
Transactional replication requires...
January 6, 2009 at 6:31 am
Why do you have 249 or so indexes on a table?
January 6, 2009 at 6:21 am
You can't use a mirror as a publisher, because the mirror database will be in a recovering state and hence unreadable. You can use the principal database as a publisher...
January 6, 2009 at 5:49 am
Jeffrey Williams (1/5/2009)
GilaMonster (1/5/2009)
Meteor hits the server room.
Maybe meteors are a bigger threat for you, but for me I am more worried about the aircraft taking off and landing next...
January 6, 2009 at 5:45 am
Jeff Moden (1/5/2009)
January 6, 2009 at 5:40 am
SQLBOT (1/5/2009)
Will a restore work for getting the backup into a readable active log?
No. I tried that once.
When SQL restores a log backup it replays the transactions recorded against the...
January 5, 2009 at 1:45 pm
I'd try dropping the MAXDOP to 4 and see how it goes. Since it's a warehouse (big queries) I wouldn't take it to 1
January 5, 2009 at 1:04 pm
sql_er (1/5/2009)
Does what you said mean that I am not breaking any chain when I do that
Conditional yes.
There are some limitations on point-in-time recovery when there are bulk operations...
January 5, 2009 at 1:01 pm
Jonathan Kehayias (1/5/2009)
GilaMonster (1/5/2009)
January 5, 2009 at 12:37 pm
When you perform a bulk operation under bulk-logged recovery, the details of the changes are not logged, just a record of what pages were logged. When the log is then...
January 5, 2009 at 12:29 pm
I had a similar piece of code (for SQL) at my former company. I didn't take the code when I left, of course. I should probably rewrite and retest it...
January 5, 2009 at 12:24 pm
Jonathan Kehayias (1/5/2009)
They were an online blogging/community site for six years, and had no backups of their SQL Database
Now that's just stupid. As is their comment that mirroring (as in...
January 5, 2009 at 12:03 pm
SQLBOT (1/5/2009)
You don't need a third party tool.
use DBNAMESELECT * FROM ::fn_dblog(null, null)
GO
That only reads the active portion of the transaction log. It doesn't read a transaction log backup.
January 5, 2009 at 11:13 am
Eeep. That does not look good.
There's no way that I know of to get a negative page number, as the page number is an incremental count of 8k chunks...
January 5, 2009 at 11:01 am
Ells (1/5/2009)
January 5, 2009 at 10:59 am
Viewing 15 posts - 41,971 through 41,985 (of 49,562 total)