Doug Bishop (1/21/2011)

---

Very good article. I do have a question. I am aware of SQL Server creating intersecting indexes when you have a query on multiple columns and each column...

GilaMonster (1/21/2011)

---

the sqlist (1/21/2011)

---

"Include columns are useful in that they are columns available in the index but not contributing to the size of the index key"

...

Included columns do affect the...

"Include columns are useful in that they are columns available in the index but not contributing to the size of the index key"

I don't think this is true. I worked...

yordan.georgiev (11/25/2010)

---

Hi ,

*** Don't just give the hungry man a fish, teach him how to catch it as well.

In my opinion this is exactly what I did ; )...

@yordan.georgiev

I checked your batch file on your blog but can you describe a little bit what and how is it doing?.

Thanks.

Yes, I am perfectly aware of that. My question was why...

Paul White (10/1/2009)

go

set statistics time on

declare @bb int;

select @bb = N from [dbo].[ufn_Tally2] (1, 10000000, 1)

set statistics time off

go

set statistics time on

declare @bb int;

select top (10000000)

...

Jeff Moden (9/22/2009)

Heh.... now I'm not sure how you are testing. Like I said before... Lynn's runs in under 6 seconds for a 10M gen... yours (after adding 1...

Jeff Moden (9/22/2009)

I'm using SQL SERVER Profiler with the data produced by the queries routed to a temp table. Routing the output to the screen gives false readings because...

Jeff Moden (9/22/2009)

Heh... the logic is simpler but it's still an eyefull, isn't it? 🙂

The other problem with that method is performance. It takes more than a minute to...

laughingskeptic (9/22/2009)

---

One usualy does not need a tally table larger than the largest table. In which case the following works as a generator:

declare @i bigint

set @i = 0

select @i=@i+1...

Nice article but it has a problem: the function CAN'T be created (or it's code used) on SQL server 2000 because of the CTE approach and and row_number() function; beside...

What hapens to the index files (NDF) if they exist?

vikas_kalra (8/27/2009)

---

Hello Jacob,

Your article is very interesting, but this raised some questions in my mind.

One can adopt this approach as long as the two procedures/ functions are in the...

tpa (8/4/2009)

---

Thanks for sharing the .bat code.

For daily scripts deployment on multiple databases, I usually build a SQLCMD script in 2 steps:

1. Copy the .sql file paths into a new...