krowley (7/27/2011)

---

Forgive a relative newbie to SQL internals but why can't the page size be variable per database or even per table? This would give the best of all worlds...

SwePeso (7/15/2011)

---

There is an additional clause for the order by part, which defaults to "first row" to "current row" in the partition window.

These three options are avaiable with the RANGE...

SQLkiwi (7/14/2011)

---

Wayne, you can avoid the join:

UPDATE target

SET AccountRunningTotal = art,

AccountRunningCount = arc

FROM

(

SELECT

td.AccountRunningTotal,

td.AccountRunningCount,

art = SUM(td.Amount) OVER (PARTITION BY td.AccountID ORDER BY td.Date, td.TransactionDetailID),

arc = COUNT_BIG(*) OVER (PARTITION BY...

Maybe I am missing something or lack some releveant experience in this area, but i see the following code:

FROM SYS.DM_DB_INDEX_USAGE_STATS AS S

INNER JOIN SYS.INDEXES AS I

ON I.[OBJECT_ID] =...

Demonstrating something you have done is getting harder by the day, because all work is hidden on inaccessible servers when at an interview location. So it is just your word...

I like to add my idea that it is a mistake to even strive for a fully declarative/functional language in the first place. SQL can be difficult to handle at...

I wouldn't dare to claim T-SQL is broken as for the most part it does a good job and to my satisfaction. The more recent added features (recursive CTE, output...

Tom.Thomson (5/14/2011)

---

I was thinking of trying with a quick approximation for sqrt which doesn't need any real numbers, but as...

You make me curious 😉

Thank you Paul, you saved me some time right there!

I am only going to check one more idea (as stubborn as I am) for the specialized and most frequent occurring...

JTSash (5/13/2011)

---

Jeff, I believe the running total you are thinking of...

Jeff Moden (5/12/2011)

---

Just to keep everyone posted, I've submitted an update to the article including the tests on Nadrek's and Peter's functions. Since Peter's was the faster of the...

And wow, that Split method (green line) does some...

Jeff Moden (5/8/2011)

---

Ok... Peter and Nadrek... I need to know your real names for inclusion in the final documentation in the updated sprocs that I'm going to attach to the...

Nadrek (5/7/2011)

---

Jeff Moden (5/7/2011)

---

You're quite welcome!

For the temporary tally table variant, I would also suggest something other than a power of 10 multi-CTE; 20^3 is 8000, and 21^3 is just...