A lot thanks I assumed that was what primary key implied.

I understand the index page id doesn't...

It would help to know what he thought multiple clustered indexes would help with ...

I never would have guessed that the primary key did not effect the row order in...

Why would you want to ?

The primary clustering is designed to limit the number of index pages that need to change each time a row updates onto a...

I would suggest that the EAV is where the types are taken out of the database entirely and only the application context would be able to decipher the significance of...

Aren't you just normalizing the question type out of the client-question-response ?

consider finding a client that has

have no Risk of a fall

have low Risk to client or caregivers...

I can see the flexibility demands that a rapidly changing data model requires. But I will argue strongly against abstracting the data model away from the database layer.

All these...

as an aside set base generation is a tad quicker

set statistics io on

set statistics time on

CREATE TABLE tbl_IN_VS_AND (filterCriterion_sv int PRIMARY KEY CLUSTERED NOT NULL)

Insert tbl_IN_VS_AND

SELECT 100000 *...

OK so only the first column in the index is the only one that statistics are calculated on. Which answers my original question

And Adding an UPDATE STATISTICS B.B_FK_A had...

I am surprised (being introduced to other DBMS before SS) that the location of the predicate relating the summarised aggregate sub query and the table for update had any effect...

Imho identities are fine keys when order of insert is close to order needed on select.

(minimum bits to define uniqueness and order)

If the natural key predicates of the majority selects...

Good Explanation of the implication of the Cartesian product (in some communities called cross join ;))

Predicates can limit the cardinality of the table(vector) inputs to the product but the complexity...

Awfully semantic distinction.

The non-trivial extraction of implicit, previously unknown, and potentially useful information from data can be achieved by the first three languages. Whether in a structured form by...

Consisting all most entirely of truisms, No quantification, expected norms or constructive methodology for cleansing discussed.

Very unsatisfying read.

Unfortunately communication is only half of the picture. The cultural bias to avoiding conflict predisposes that problems are picked up later rather than in a timely manner. If...

Don't you need to give relative waiting to each of the keywords towards the fuzzy match with two words in the search pattern ?

The left joins are ugly in...