And more index-friendly 😉

Oh. No - not intending a joke - but I see what...

Yours has been fine over the last 24 hours - not like 'Dixie' or Alvin, which were both broken for me, but happily back now.

Just so...

It's the no-RBEAR 😀

You'd need to downgrade to Oracle for that.

Jeff Moden (12/14/2009)

---

In fact, Paul, you should write an article on this. Should be about as good a fight as the Running Total article. You'll drive the other...

Jeff Moden (12/14/2009)

---

I suppose you can trim down the WHERE clause in Paul's good code with the minor risk of finding things you didn't intend to...

WHERE

definition...

:laugh: :laugh: :laugh: :laugh: :laugh:

Not that I can think of. Sixteen statements? Isn't it twelve? You could do it with RegEx in a CLR routine, but that seems a bit overkill.

Actually,...

sam.walker (12/14/2009)

---

but Fillrows Clr is very slow. Unless it is ten times faster than when I first looked at it.

Can we conduct a trial?

to be honest I'd be ecstatic if...

True, but you can still ONLINE rebuild the whole index (I just tried this).

nmoore (12/14/2009)

---

A limit to the number of partitions a table...

TheSQLGuru (12/14/2009)

---

Assuming good cardinality then there could be 5000 or so PAGES locked if the engine decided that page locks were appropriate (which is likely for any reasonable rows estimated...

Jeff Moden (12/14/2009)

---

Flo has a kid on his team that wrote a splitter CLR that blows everything away and, if memory serves, the code for that CLR is included someone...

tacy.highland (12/14/2009)

---

####Hold on a sec,...does the database itself have to be in 2005? I think the db I'm querying from is 2000, ...even though I'm using Microsoft SQL Server Management...

One of the longest threads ever on SSC was devoted to this: http://www.sqlservercentral.com/Forums/Topic695508-338-17.aspx

There is a handy summary of the results on...