Viewing 15 posts - 6,931 through 6,945 (of 8,416 total)
Hey Bob & Lynn,
Please direct pork chops to me rather than Matt. We had a very interesting discussion on the site earlier, and it came up that he was...
September 13, 2009 at 9:32 pm
Alex (9/13/2009)
I am curious then: how would you define a relational database if it is not one that tries to adhere to the relational model?
I don't really offer a definition...
September 13, 2009 at 9:25 pm
Alex (9/13/2009)
Codd and Date (http://en.wikipedia.org/wiki/Relational_model). I am not aware of any others...
I don't define a modern relational database that way, no. But then I'm not an expert on the...
September 13, 2009 at 7:39 pm
Matt Whitfield (9/13/2009)
A good discussion I feel, even if I misunderstood your tone - for which I apologise.
There's really no need - I enjoy an energetic debate more than most.
Good...
September 13, 2009 at 7:21 pm
We should definitely play poker sometime!
September 13, 2009 at 7:15 pm
Matt Whitfield (9/13/2009)
September 13, 2009 at 7:11 pm
Alex (9/13/2009)
Well, at least you admit it is an issue: SCHEMABINDING is a hack to make SQL Server conform a bit more to the relational model.
I said that in my...
September 13, 2009 at 6:58 pm
Alex (9/13/2009)
OK, so it is a documented bug. Documenting a bug and providing a workaround doesn't mean it isn't a bug.
I think is where we shall have to agree to...
September 13, 2009 at 6:54 pm
Matt Whitfield (9/13/2009)
Would you like it more if it was about exploding kettles? 🙂 Just because you don't like my analogy, doesn't make it false.
You likened it to zeroing an...
September 13, 2009 at 6:47 pm
Remind me never to play poker with you.
September 13, 2009 at 6:24 pm
One thing you will probably want to do after the upgrade is to run DBCC CHECKDB WITH DATA_PURITY.
September 13, 2009 at 6:21 pm
Was the database restored from a server where it was replicated?
If you are *absolutely certain* about the replication, you can mark all transactions as having been processed by running the...
September 13, 2009 at 6:10 pm
Matt Whitfield (9/13/2009)
September 13, 2009 at 6:06 pm
There are many valid approaches. Here's one:
CREATE TABLE #Session
(
session_id ...
September 13, 2009 at 5:50 pm
REPLICATION is indeed the cause.
The log records have to be kept 'live' until any *transactional* replication that uses them has completed. If replication is 'stuck' (most likely...
September 13, 2009 at 5:36 pm
Viewing 15 posts - 6,931 through 6,945 (of 8,416 total)