Viewing 15 posts - 7,096 through 7,110 (of 8,416 total)
Clint (9/8/2009)
...However, the stored procedure that moves them from the staging to the main tables is always the point of deadlock.
Awesome, so can we concentrate on just that to start...
September 8, 2009 at 7:40 pm
Perhaps someone who knows Oracle well could advise the best way to 'bulk export' the results of a query to a file?
(Last time I checked, this wasn't easy without third...
September 8, 2009 at 7:31 pm
Yes and no.
No - SQL Agent is designed to 'lock up' until all user databases are recovered. This would not work very well in a log-shipping scenario for instance...
September 8, 2009 at 7:22 pm
Consider moving away from NTEXT if you can:
Books Online
September 8, 2009 at 7:14 pm
The code inside a trigger runs inside an implicit transaction. You can look at this transaction as being the thing that protects the atomicity of the original statement. ...
September 8, 2009 at 7:08 pm
PaulB (9/7/2009)
liuc (9/2/2009)
Which is the "best practice" in these cases?Put "Design" as step #1 of project life cycle, not as last step.
Very wise. Totally useless in the context of...
September 8, 2009 at 7:00 pm
Yes we can fix that, without resorting to NOLOCK and ROWLOCK. (Don't get me started on that please.)
Personally, I'd like to see a simplified example in SQL code with...
September 8, 2009 at 6:55 pm
PaulB (9/8/2009)
wow!... you are pretty close of discovering what we call "packages" in the Oracle world.
Please let's not get all my-RDBMS-is-better-than-your-RDBMS 🙂
It's kinda boring eh.
Just to add:
The ability to number...
September 8, 2009 at 6:50 pm
PaulB (9/8/2009)
Paul White (9/8/2009)
If ROWNUM in Oracle returns rows ordered by the internal row identifier...actually, it doesn't.
Not that I really care, but it turns out I was thinking of Orcale's...
September 8, 2009 at 6:44 pm
You're welcome - but make sure you fire-proof your shoes eh?
BTW you may notice that %%LockRes%% output bears a resemblance to entries in the resource_description column of sys.dm_tran_locks for RID...
September 8, 2009 at 5:57 pm
RBarryYoung (8/31/2009)
...whereas Partitioning is primarily a performance tool.
Just as a quick aside...partitioning really isn't a performance thing. In the great majority of real-world cases, a partitioned table is less...
September 8, 2009 at 5:46 pm
Please don't post your questions twice - it just confuses me and make me anxious.
I replied on your other post.
Paul
September 8, 2009 at 5:36 pm
September 8, 2009 at 5:34 pm
Hey Lowell,
Thanks for that! Yes it is 2008-specific, but the following will work in both (though not quite the same thing - it's close)
CREATE TABLE dbo.A (id INT NOT...
September 8, 2009 at 5:29 pm
ALZDBA (9/8/2009)
Breathe 😀
Out with the bad air ... In with the good ....go
Thanks. I feel better now.
Though the extra byte is still bugging me.
I will test...
September 8, 2009 at 4:50 pm
Viewing 15 posts - 7,096 through 7,110 (of 8,416 total)