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...

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...

Consider moving away from NTEXT if you can:

Books Online

---

ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types...

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. ...

Very wise. Totally useless in the context of...

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...

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...

Not that I really care, but it turns out I was thinking of Orcale's...

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...

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...

Please don't post your questions twice - it just confuses me and make me anxious.

I replied on your other post.

Paul

Files and File Groups Architecture

Backup Overview

Have fun.

Paul

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...

Thanks. I feel better now.

Though the extra byte is still bugging me.

I will test...

Taking you literally:

SET NOCOUNT ON;

GO

CREATE TABLE dbo.A (id INT IDENTITY PRIMARY KEY, silly_key AS 'ABCD' + CONVERT(VARCHAR(15), id))

GO

INSERT dbo.A DEFAULT VALUES;

GO 100

SELECT *

FROM dbo.A;

GO

DROP TABLE...