Groups > comp.databases.ms-sqlserver > #849

Re: question on clustered indexes in sql-server

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!news.swapon.de!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	Lennart Jonsson <erik.lennart.jonsson@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: question on clustered indexes in sql-server
Date	Tue, 29 Nov 2011 18:39:19 +0100
Organization	A noiseless patient Spider
Lines	18
Message-ID	<jb35c8$eb7$1@dont-email.me> (permalink)
References	<jb2ucg$tq7$1@dont-email.me> <jb3388$vjm$1@dont-email.me>
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	7bit
Injection-Date	Tue, 29 Nov 2011 17:39:20 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="s5bGbN1rkKdRsNtF9wQKGw"; logging-data="14695"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+Kz3b0jC7Zgf4f2f5A+s6m"
User-Agent	Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.24) Gecko/20111108 Fedora/3.1.16-1.fc14 Lightning/1.0b2 Thunderbird/3.1.16
In-Reply-To	<jb3388$vjm$1@dont-email.me>
Cancel-Lock	sha1:4e7QDo4jE9m2JQp5yaXmN4jZybQ=
X-TagToolbar-Keys	D20111129183919731
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:849

Show key headers only | View raw

On 2011-11-29 18:03, Bob Barrows wrote:
[...]
> Kimberly Tripp sums up the debate (and there is, indeed, some controversy 
> about this) quite nicely here:
> http://sqlskills.com/BLOGS/KIMBERLY/post/The-Clustered-Index-Debate-again!.aspx
> 
> Make sure you follow the links near the beginning of the article.
> 

Thanks Bob. I've skimmed through the article and the links and I think I
got most of it. Clustering index is a different creature in sql-server
compared to db2. The clustering indexes used makes more sense given this
information. Thanks

/Lennart

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

question on clustered indexes in sql-server Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2011-11-29 16:39 +0100
  Re: question on clustered indexes in sql-server "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-11-29 12:03 -0500
    Re: question on clustered indexes in sql-server Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2011-11-29 18:39 +0100
  Re: question on clustered indexes in sql-server Erland Sommarskog <esquel@sommarskog.se> - 2011-11-29 23:45 +0100
    Re: question on clustered indexes in sql-server Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2011-11-30 15:30 +0100
      Re: question on clustered indexes in sql-server Erland Sommarskog <esquel@sommarskog.se> - 2011-11-30 23:33 +0100
        Re: question on clustered indexes in sql-server Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2011-12-01 10:25 +0100
          Re: question on clustered indexes in sql-server Erland Sommarskog <esquel@sommarskog.se> - 2011-12-01 23:55 +0100
            Re: question on clustered indexes in sql-server Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2011-12-02 08:32 +0100

csiph-web