Anyone interested in the strength of a universal hash function should read this:

http://home.comcast.net/~bretm/hash/

FNV does'nt come out that well, but that said, its a very simple algorithmn that...

SQL Kiwi (1/31/2012)

---

peter-757102 (1/31/2012)

---

Can you explain (or have a link that does a good job at it), why one would want to go that route over clustered storage in that...

b5535084 (1/31/2012)

---

Thanks for the insights! I have a question about your comment about the rn doing nothing though. My hope was that it would force the windowing so...

SQL Kiwi (1/31/2012)

---

The...

I took a look at the plans and what confused me is the apparent lack of clustered indexes (i noticed table scans instead of clustered index scans)!

Could it be that...

Just read the article (I am free on Mondays \o/)...

I find the conclusion of the article strange to me as it could just be said that it is the 'having...

Grumpy DBA (9/14/2011)

---

How come intelligent DBAs cannot spell "definitely"? "defiantly" and "definatly" have been used in this thread...

Back to the subject at hand, congratulations Jeff, good to see a...

Jeff, this has been a long time coming!

Congratulations with the award, you definitely earned it for all the work you shared with the SQL community!

Every time, you make us all...

krowley (8/29/2011)

---

Where do your page counts come from? Are there a set of books you have that you pulled these from, or are these from some online documentation?

I am working...

The article states this following opinion:

This experience led me to the notion that organizations are being foolish by looking for developers who can do everything. The knowledge required to...

I like filtered indexes but have ran into a very annoying issue with them once.

The where clause of a filtered index cannot have OR operators in it (it does support...

Gatekeeper (8/12/2011)

---

@Peter

Thanks for the feedback. I've run the test several different ways (current way posted, putting values into a table variable, and single execution statements) and found they produced the...

mark hutchinson (8/12/2011)

---

@Peter

Jeff's new article uses describes this method and states that the compiler knows that when the number of rows is less than what would be produced at/above one...

Gatekeeper,

Be careful testing sample data this way, where you have the constants in the same batch as the code that you are benchmarking. The replicate function does not "hide" the...

David Walker-278941 (7/28/2011)

---

SQL data is allocated on disk in 8 kilobyte chunks. The 512 byte sector size of the underlying physical disk does not affect this *for writing SQL...