Can I play too?

DECLARE@Sample TABLE

(

id int primary key clustered,

col1 numeric(6, 2),

col2 numeric(6, 2),

col3 numeric(6, 2),

col4 numeric(6, 2),

col5 numeric(6,2),

col6 numeric(6,2),

col7 numeric(6,2),

col8 numeric(6,2)

)

INSERT@Sample

SELECT1, 2.35, 3.01, 3.49, 4.25, 4.79, 5.36, 5.82, 6.31 UNION...

Some systems used first byte to hold number of characters of string with a maximum of 255 bytes.

Not necessarily. With SQL 2008 comes the ability of Filtered Indexes.

You can create an index on Bit1 = 1 only.

Bruce and GSuared, neither of your suggestion work with this test case

DECLARE @String VARCHAR(MAX),

@Size TINYINT

SELECT@String = 'Hello my name is Jeff. I need some help on a project because right...

Execution plans

A good look at the reads required will reveal something

-- Peso

Table '#73E9A71D'. Scan count 7, logical reads 7, physical reads 0.

SQL Server Execution Times:

CPU time...

DECLARE@InputDate DATETIME

SET@InputDate = '02/mar/2009 13:15'

SELECT@InputDate AS theDay,

DATEADD(DAY, DATEDIFF(DAY, '17530102', @InputDate) / 7 * 7, '17530101') AS StartDate,

DATEADD(DAY, DATEDIFF(DAY, '17530102', @InputDate) / 7 * 7, '17530108') AS EndDate

Also asked and answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121584

Asked and answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121602

Your primary key must exist of

1) The unique column

2) The check constraint

As seen among the comment for the link I posted earlier.

My best attempt this far is to have a trigger on tallynumbers table and report the number of records in a CountingTable.

That gave me a total of only 14 reads...

I created a TallyNumber table with only one column (ascending clustered primary key) and 2,000,001 records, ranging from 0 to 2,000,000.

First I tried your suggestion in the article, which gave...

How is your security set up?

DECLARE@Now DATETIME

SET@Now = GETDATE()

SELECT@Now AS [Now],

DATEADD(DAY, DATEDIFF(DAY, 0, @Now), 0) AS dateOnly,

DATEADD(DAY, DATEDIFF(DAY, @Now, 0), @Now) AS timeOnly

Thank you.