We have about 25 million customers. The number of distinct visits to our sites each day varies between 25,000 and 30,000.

We are only using about 600 Gig of database disk...

I'd love to see a better search and better ordering of the results.

I'd like to be able to search on SQL Server specific terms like 'log shipping' and not get...

It looks to me as if your first solution should have a UNION ALL in it instead of a UNION. This should speed the query up.

Unless you have a...

Here's a sample of it as a CTE - note the ; before it. You will need that if this is part of a procedure that does other things.

;

WITH...

I'm not sure why you have two separate subqueries to calculate the two standard deviations. It looks to me like it could be one.

I would also change the whole...

I went from Oracle to SQL Server and I found this book helpful.

"SQL in a Nutshell" by Kevin E. Kline

(O'Reilly press)

http://oreilly.com/catalog/9780596518844/

It compares usage of SQL between the various databases.

For...

If you have SQL Server 2005 then use a common table expression (CTE).

It should be faster for large amounts of data.

WITH get_products AS

( SELECT ...

One thing I've learned as an employee over the many years I've been working (that I didn't really believe when I was told it as a child) is that lying...