Sean Lange (3/5/2012)

Jonathan AC Roberts (3/5/2012)

drew.allen (3/5/2012)

The original question was about taking multiple values and storing them in...

drew.allen (3/5/2012)

The original question was about taking multiple values and storing them in a single variable, not doing...

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?