Jeff Moden (3/14/2010)

---

If we precalculate all possible combinations of numbers that have a value of at least "3" and save only the ones that add up to precisely "25" in...

Jeff Moden (3/14/2010)

---

Holy Moly! The distribution of "R" and "T" suck with my method! I don't quite understand it because the distribution of "C" is nearly flat as...

And a...

No...

Jeff,

You're quite right. In many ways, I wish I had resisted the temptation to post the Heap insert thing. The correct thing to do here would be to...

EAV :sick:

You can use sparse columns when you get to SQL Server 2008. Or XML now. Probably other things too.

Where have all the questions gone? Seems very quiet...perhaps too quiet...

Why do you say that? My experience of 64-bit SQL Server...

jwa082276 (3/13/2010)

---

...a query went from taking 6 secs to 1 min and 45 seconds. I set the max server memory back to 26 gig and now the query runs...

ROW_NUMBER() OVER (PARTITION BY employee_id ORDER BY employee_id)

They may well have improved since 2007-8. All...

Not to my knowledge, no.

That's a bit ironic because the person that was pushing for he blades was responsible for the blades...

Demo setup:

-- For demonstration purposes

USE tempdb;

GO

-- Drop test table and procedure if it exists

IF OBJECT_ID(N'dbo.DuplicateItem', N'P')

IS NOT...

Some people find this way of writing the query more intuitive:

Setup:

CREATE TABLE #Data

(

col1...

CirquedeSQLeil (3/13/2010)

---

I just forced the same sort of error. I processed a couple of GIGs and disabled the autogrowth on the log file. I also kept the log...