Fixed that for ya! 😀

SDM (11/17/2009)

---

The OP stated it...

Matt,

Where did I say that a running total MUST be deterministic? (Your capitalization)

It seems good practice to me that the 'order by' part of a ranking function should produce...

For full details click here

The sorting order is defined by the collation used.

See Working With Collations

ANSI_PADDING link

Could you post what you're using at the moment? It would help to explain what you need.

Feel free to simplify it down.

You could use the OUTPUT clause of the DELETE statement, but the target table would not be allowed to have any enabled triggers, check constraints, rules, or take part in...

You get two rows - one per type of allocation unit. One for IN_ROW_DATA and one for ROW_OVERFLOW_DATA. See http://msdn.microsoft.com/en-us/library/ms189051.aspx for descriptions.

Roust_m (11/12/2009)

---

as for the fourth, the size of the row is under 1000 bytes, so this...

In an imaginary system with zero I/O latency (to disk or memory!) the ultimate capacity would probably be limited by CPU. Maybe this system has reached that state :laugh:

Seriously,...

It seems pretty obvious that a .NET solution will usually be faster. What I liked about this article was the...

sqlservercentralitgeekry (11/16/2009)

---

Granted, the non-unique rows may have incorrect running total values, but ROW_NUMBER preserves the integrity of the series as a whole.

---

For that application, an arbitrary tie-break is acceptable, as...

I'm going to run out of 'stars' at this rate 😉

Not exactly sure what is being referred to by 'properties tab' - but I always rebuild or reorganize indexes from T-SQL script, never the SSMS UI. Right-clicking on an...

I think he does - it's just not massively clear that the 'path' box requires just a directory path - not...