Hello David and thanks for a great article on yet another good use of SQL CLR.

The only issue I have is with your statement that "median" is not a good...

Being able to take action remotely, on top of monitoring the system, would make us all very productive. I am not sure if it already exists, but a port...

I have also run into the same problem with ISNUMERIC() that many people here have mentioned in terms of wanting something more like "IsReallyNumeric". So, I created a SQLCLR...

Jeff Moden (10/17/2010)

---

I'm not a GUI/App programmer so I'll have to find another way to test what you propose, Solomon. Shouldn't be too difficult, though.

If I were an App...

Jeff Moden (10/17/2010)

---

My second take on it is that a SQLCLR splitter would probably be the best way to split up large "matrices" of data passed to the database. ...

For anyone using SQL Server 2008, there is another option that is extremely efficient and does not require a splitter function:

http://www.sqlservercentral.com/articles/SQL+Server+2008/66554/

Philippe Cand (5/1/2010)

---

We have a debate about partitioned tables vs the old partitioned view in SQL2008. I have a troublesome table with over 30M rows. I thought that horizontal partitioning...

fat wallet (6/29/2010)

---

this author has no idea about execution plan. He just checked statistical IO and did not analyse the execution plan.

Select min(field1) from partitionedtable1

The above statement on...

Since someone mentioned using CLR to get this information I will say that my SQLCLR project, SQL# (SQLsharp), includes this function. It is usable in SQL Server 2005 and...

Paul White NZ (5/5/2010)

---

My issue with the WHILE loop is that it executes once per partition, whereas the set-based code does it all in one step. As I said,...

Paul White NZ (5/5/2010)

---

Are you sure Solomon? I would expect the APPLY + $PARTITION approach...

Hello...

Hello Matlani. Unfortunately, using an IN list has the same performance problem....

UMG Developer (5/4/2010)

---

What happens if you use a sub query to get the minimum value for each partition, and then get the min of that?

SELECT MIN(MinIntDate)

FROM (SELECT PartitionID, MIN(IntDate) MinIntDate

FROM...

alen teplitsky (5/4/2010)

---

nice article

we have a 2TB database we're going to be moving to new hardware soon ... but there is no way to test it since we don't have...