Hey Root,

What Toby said above looks right at a glance, but I believe the problem is more basic for you. You've misunderstood, or haven't been informed, of some basic...

Hey guys. Blogging/articles and the like are relatively new to me, so I'd like your educated opinions on how I should look at this:

http://balapalani.blogspot.com/2010_12_01_archive.html

It's roughly a copy/paste of the...

To add to this, why did C 3/4 only apply to 3 and D/E...

Happy holidays all. Just got back from my Christmas vacation. I didn't bother throwing backup into that thread because... well... I didn't have anything to say but Ditto....

I know this is an article about built in features, but there's a corollary to it.

The online community for SQL Server has saved more Professional's buttocks than any...

Paul White NZ (12/17/2010)

---

Read Committed (the default) isn't much better. You won't lose scan position, but skipping records and double-reads are perfectly possible. Using a row-versioning isolation level...

<--------------------------- This look on my face is getting to be a habit these past two weeks...

Paul White NZ (12/16/2010)

---

Craig Farrell (12/16/2010)

---

I'm trying to force an IAM defrag that will...

Unmentioned so far, but useful, and easily hidden... cough drops. Halls in particular are my preferences, the Vitamin C ones with no menthol. They also don't excite the...

Something like this perhaps?

BETWEEN DATEADD( mm, DATEDIFF( mm, 0, @StartDate) - 6, 0) AND DATEADD( dd, DATEDIFF( dd, 0, @StartDate), 0)

Note I removed your dbo.DateOnly function and swapped it out...

Gianluca Sartori (12/17/2010)

---

GilaMonster (12/17/2010)

---

The x64 processor architecture is sometimes known as AMD64...

Paul White NZ (12/16/2010)

---

CREATE TABLE dbo.Example

(

row_id INTEGER IDENTITY NOT NULL PRIMARY KEY CLUSTERED,

data AS...

Hehehe, and as usual, I'm...

The short form, if I had to make a guess without the code/samples, is that you're using a where clause to limit the results to your actual ints.

This will fail...

Malcolm Daughtree (12/16/2010)

---

I don't mind trying to teach the masses but there come a time where there has to be some work done on their part to research and read...

As expected, 5001-5005, 7001-7005, 9001-9005, and the final select starts at 1 and carries through (for about 30 spot...