What is it sorted on? The minimum rule number it satisfies?

Create a function to split a string into a table:

GO

CREATE FUNCTION [dbo].[SplitString] (@list nvarchar(MAX), @separator nvarchar(MAX) = ';')

RETURNS @table TABLE (VALUE nvarchar(MAX))

AS

BEGIN

DECLARE @position int

...

you have to use SCHEMABINDING

http://technet.microsoft.com/en-us/library/cc917715.aspx

Tidied up version below:

IF NOT EXISTS(SELECT NULL

FROM INFORMATION_SCHEMA.SCHEMATA

...

Were you using the latest version above? linky

this does the "include" columns without ASC or DESC and I believe the order is correct.

I've heard a few things about SSD's, limited number of writes for memory's lifetime, fast reads and slow writes, but this probably depends on how the memory is wired up...

SELECT GroupName,

DATENAME(mm,'2000-' + RIGHT('0' + CAST([month] as varchar(13)), 4) + '-01') [month],

[Count]

FROM (SELECT 'A'...

The Disk Usage section is not relevant to SAN disks. We have systems that run at over 100% disk time all day. I think this is because a SAN has...

In the Fragmentation section when it instructs to:

DECLARE @DatabaseName sysname

SET @DatabaseName = 'mydatabase' --use your own database name

The uses it:

FROM sys.dm_db_index_physical_stats(DB_ID(@DatabaseName), NULL, NULL, NULL, 'Sampled') ips

The query only actually...

I use these as I figure it's better to use SQL servers internal function than assume Datetime will always be a float:

DECLARE @DateOnly DATETIME

SET @DateOnly = CAST(CONVERT(varchar,GetDate(),112) AS DATETIME)

SELECT @DateOnly...

Might not be quicker but it's a differnt way of writing it:

SELECT A.Field1,

A.ImportantDate,

A.FirstTime

...

There is a balance between "Security through obscurity" and supportability. I support the argument that security through obscurity is bad as it is a total nightmare to support systems where...

Would have been nice to have a definition of what physically ordered and logically ordered meant?

So the whole article is basically saying adding an index can assist in the performance of queries containing ORDER BY.

There is a rating on each article, this one has 2 stars, something that should be an indication to you.