Try full text indexing

A primary key defaults to a clustered index, but you can choose explicitly not to cluster it.

I'm pretty sure that a a primary key is needed for certain types of replication.

I'm...

How many Mb does 9 Million records represent?

If you run the following query

SELECT SUM(Length)

FROM SysColumns

WHERE ID=Object_Id('dbo.<<your table name>>')

You will get a very crude idea of your record length.

Multiply this by...

How big is the phsical TEMPDB log file?

Is it set to autogrow?

Good article!

One thing I'm not sure of is where you would use CREATE STATISTICS.

I know indices maintain their own statistics but if you do a query using an ORDER BY,...

I seem to remember on of the Brians posting something to the affect that physical file defrag was of limited use if you database was on a RAID 5 array...

CREATE RULE rl_BeforeNow AS @dtDate < GETDATE()

The date thing is an absolute pain

I have standardised on using yyyy-mm-dd as my date format in my applications and therefore my SQL always...

I take your point on upscaling webservers.  I wish I knew more on the infrastructure side.  Come to think of it, I wish I knew ANYTHING on the infrastructure side

Strictly speaking yes, it would be at risk from an injection attack, but not in the case of this particular CMS.

The execsp portion tells the CMS that this is a...

We develop a lot of UK government web-sites and accessibility is a major issue.  That is, could this site be used by someone who is blind, can't use a mouse...

I don't agree because the topic id is not private information.  In fact in the live application the topics are SIC codes so the SIC code is actually displayed on...

Steve,

It's your site but the only post that could have generated more flame would be a "do you think you a DBA should take a gun to work to deal...

Has there been a sudden reduction in disk-space on your server?

What size are your log files?  Are they expanding at some point during the backup?

We had a situation where a...

I have had this joyous thing happen on a couple of occassions.

I couldn't see anything wrong so I got the web page to write out the SQL statement that it...