DECLARE @PathFile nvarchar(256)

CREATE TABLE #FileDetails (

[Alrernate Name] sysname NULL,

[Size] bigint,

[Creation Date] char(8),

[Creation Time] char(6),

[Last Written Date] char(8),

[Last Written Time] char(6),

[Last Accessed Date] char(8),

[Last Accessed Time] char(6),

[Attributes] int NULL

)

INSERT INTO...

You suck!

Single thread next to this one got almost 4 times more!!!

😀

Good DBA keeps his relations well normalised.

opc.three (8/6/2012)

c3 and c4 become fragmented, not because of the clustering key, but because you're applying modulo 10 to your calculation meaning in the subset inserts you'll be inserting some...

SQL Kiwi (5/23/2012)

---

Sergiy (5/22/2012)

---

If we choose to believe so. IndId = 256 indicates that it's a data page, but I cannot see any indicator that it is a leaf...

DBA-640728 (5/22/2012)

---

last night I had to kill a processes/job that normally takes 1 min to run but for some reason it was hung for about 8+ hours. Nothing was blocking...

Yep. Can read it now.

If we choose to believe so.

IndId =...

The "original challenge" is not accessible. May be temporarily.

But anyway, both articles focus on splitting the load on the SINGLE index (heap in "Boosting INSERT" case).

In "Resolving PAGELATCH Contention" it's...

Instead of CASE you may use also ISNULL(NULLIF) construction:

LEFT(CUST.Address, ISNULL( NULLIF(CHARINDEX(CHAR(13), CUST.Address, 1), 0) - 1), LEN(CUST.Address) ) )

Error is in the sequence of operations:

PROBLEM:

Insert into ERROR_LOG (ERROR_DATE, ERROR_USER, [ERROR_MESSAGE], ERROR_SOURCE, [ERROR_NUMBER], ERROR_HOST)

Select getdate(), SYSTEM_USER, '',@source, @intErrorCode, HOST_NAME()

ROLLBACK TRAN

ROLLBACK TRAN...

You may use LF for BULK INSERT and immediately after it's completed strip the last character from the last column there it is CHAR(13).

I see you've got the petrol station analogy.

Time to wrap it up.

🙂

Well, as long as we communicate here in some language, it...

Part of it. Exactly. But not the whole operation.

Of...

Fun part:

Question:

Which query plan operator executes first?

Correct answer:

The Stream Aggregate

My question:

Sorry, the Stream Aggregate executes what?