On Thu, Jul 12, 2012 at 9:14 AM, MB Software Solutions, LLC
<[email protected]> wrote:
> I'm creating my indexes/keys in SQL Server Mgmt Studio (2008 R2) and
> it's such a small dialogue box, fixed in size, not resizable. C'mon,
> M$...it's 2012...why the hell must I work within such a small box?
> Steve Russell or anyone working with a newer version -- please tell me
> this is only in the 2008 R2 version?!?!?!???
-------------------
It has been that way for ever. ver 4.5 didn't have it but 6.0 did.
My guess is that you are overloading the index and in reality wasting
a ton of space for no real use.
Read up on "Include columns" as a better index methodology.
CREATE NONCLUSTERED INDEX IX_Address_PostalCode
ON Person.Address (PostalCode)
INCLUDE (AddressLine1, AddressLine2, City, StateProvinceID);
GO
SELECT AddressLine1, AddressLine2, City, StateProvinceID, PostalCode
FROM Person.Address
WHERE PostalCode BETWEEN N'98000' and N'99999'
AND City Like 'AM%';
GO
<http://msdn.microsoft.com/en-us/library/ms188783.aspx> there is a
ton of content on this page and for so many different aspects of your
actual need you need to follow some parts and not others.
What is clustered and non clustered is the first mistake that people make.
Fill factor is the #4 or 5 thing that people learn to adjust depending
on the data contained. Give more to textual data and non to
incremental.
Truly indexes are far from simple for stellar performance in a
complicated where clause.
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CAJidMY+GE=J-R7komLcKN-874FTQJz0qQWv68zjeuCi=pez...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
