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.

I've changed the ORDER BY on one of the statements and it seems to have fixed it:

IF NOT EXISTS(SELECT 1 FROM INFORMATION_SCHEMA.SCHEMATA

WHERE SCHEMA_NAME = 'utils'

AND SCHEMA_OWNER = 'dbo')

BEGIN

...

Shamshad Ali (8/23/2010)

---

Hello,

The script you make with efforts are highly appreciated, but the latest script I checked for my case is not perfect and have bugs. All, always verify...