massoud-1045248 (3/14/2011)

---

Thanks for the article but it seems that the link is not working.

CreateAssemblyAndAggregate.sql

Also when I try to create the procedure below I get an error. I named the...

Ajit, this is an interesting approach to the problem, but most likely it is just adding complication via over-engineering when a much simpler solution appears to be available.

1) The most...

ian.gregson (2/14/2011)

---

Hi Solomon, thanks for the reply but I didn't really want to execute the sproc in its entirety.

These output column names are what I want to build my test...

ian.gregson (2/10/2011)

---

I would like to be able to create a test around the metadata returned from a stored procedure.

My scenario :- I will receive Column A, Column B & Column...

I definitely agree that there are very valid occasions to use a NoSQL option as a solution and to rule them out entirely is just as silly as wanting to...

CirquedeSQLeil (1/4/2011)

---

True it is a bit unfair to illustrate it that way (I alluded to that unfairness as well). An important part of that comparison is to show how...

Hey Jason. Nice article and one question. In your two main examples the difference is the WHERE condition that constrains the results to 10 rows as opposed to...

D'oh! ;-)...

gabriele.acconcia (1/4/2011)

---

I would only sign out that I got an error when I tried to execute the following sample from the article:

DECLARE @a int = 1

DECLARE

Mark-101232 (1/4/2011)

---

I don't think the CELKO method works correctly in all circumstances, the problem occurs when there are duplicates and the ASC and DESC ROW_NUMBERs don't match up. The data...

timothyawiseman (1/3/2011)

---

When I am thinking about the trade offs for creating an index, I will consider carefully how often the table is written to and the trade offs in write...

Of course. That is what the article was about: making sensible/reasonable choices.

Nadrek (1/3/2011)

---

Essentially; know your system, know your data, know your bottlenecks, know the plateaus, know your growth patterns, and keep an eye on future technology.

You have limited CPU, limited disk...

rlobbe (1/1/2011)

---

What no one has mentioned is that you also have to consider the mechanics of the I/O.

SQL Server is going to fetch a block (or several) at a time,...

Thomas-282729 (1/1/2011)

---

I could make the same argument against any data type. "Think of the savings you are wasting by using a 4-byte integer instead of a 2 byte integer for...