Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 

997 Results Found

ARTICLE

Indexes, Indexes, Indexes

... common volunteer DBA mistake - ineffective indexing. (For a background discussion about indexing I refer the reader to my paper Understanding Indexes and the many other excellent papers available ... process I use to identify and track index utilization statistics. Background We have ... 1,800 tables upon which 392 indexes are defined totaling about 375 GB ...

ARTICLE

Index Management

Index management has always been an integral ... we do have a lot of articles and scripts dedicated to it. Well, here's my take on Index Management. An index management strategy should be comprehensive enough to touch all aspects of indexes. A quick google gave me 1000's of link for index management; however none of them were ... complete enough to cater to all needs of index management. After a bit of brainstorming I ...

ARTICLE

Introduction to Indexes

Good indexes are the key to good performance in SQL Server and the key to creating good indexes is to understand what indexes are and how SQL Server uses them ... going to look at the very basics of what indexes are, what types exist in SQL and how they’re used. What is an index? An index is a structure within SQL that is used to quickly ... within a table. It can be useful to imaging an index at the back of a textbook when thinking about SQL indexes. They both serve the same purpose – to find ...

ARTICLE

Indexing Strategies

... run a query, the choice of whether to use an index or not is decided by the query optimizer. Using appropriate indexes on tables so that the query optimizer chooses ... few scenarios to familiarize ourselves with the way indexes are used to retrieve data and also try to figure out which index clustered or non clustered is good on each ... 9000 Let us say there is a clustered index on the member_number column. SQL Server ...

ARTICLE

Temporary Indexes

... up in my research was the idea of temporary indexes. I had never used them ... intrigued by the idea. I have dropped indexes before a large load and then recreated them, but these are indexes I planned to keep on the table indefinitely ... Friday: Do you use temporary indexes? By temporary, I mean indexes that you create for a process and then discard at the end of a process. These could be indexes that you use to supplement some type of data load, perhaps indexes used in staging tables. Or they could be indexes that are added to some OLTP tables for the processing ...

ARTICLE

Using Index Intersections

Using Index Intersection Introduction First introduced in SQL Server version 7, Index Intersection gives you new options for creating indexes on tables to maximize performance To start with I ... table from the Pubs database and explain the indexes that exist on that table, then look at how we would use indexes on that table for queries prior to Index Intersection, then we will look at the options that Index Intersection gives us. A cautionary note ... so we can see how indexes were chosen without the benefit of Index Intersection. It is also well known and available ...

ARTICLE

Stairway to SQL Server Indexes: Level 7, Filtered Indexes

... every row of the table generates an entry in an index.  Some indexes have fewer entries than the corresponding table has rows.  These indexes are called filtered indexes; a feature that was introduced with SQL Server 2008 ... Resources section at the end of the article. Filtering an Index You filter an index the same way you filter a SELECT ... Sales.SalesOrderDetail')                     AND name = 'FI_SpecialOfferID' ) DROP INDEX Sales.SalesOrderDetail.FI_SpecialOfferID ; GO CREATE INDEX FI_SpecialOfferID ON Sales.SalesOrderDetail (SpecialOfferID) WHERE ...

ARTICLE

Understanding Indexes

... paper provides an introduction to database table indexes using Microsoft SQL Server. The intended ... administration, or optimization of database systems. A Simple Index Webster defines an index as an alphabetical or classified list, as one placed ... English Language, 1981). In other words, the index of a book is a sorted listing of topics contained ...

ARTICLE

Stairway to SQL Server Indexes: Level 8, Unique Indexes

level we examine Unique Indexes.  Unique indexes are special in that they provide more than just ... integrity benefit.  In SQL Server, unique indexes are the only reasonable way to enforce primary ... key and candidate key constraints.  Unique Indexes and Constraints A unique index is no different than any other index, except that multiple entries with the same index key value are prohibited.  Since each entry in an index maps to a row in the table, preventing an entry from being added to the index prevents the corresponding row from being ...

ARTICLE

Indexed Views

... other SELECT statements. One or more indexes can be created on a view as long as they meet ... msdn.microsoft.com/en-us/library/ms191432.aspx. When the index is created on the view, the view actually stores ... view is automatically updated to reflect these changes. Indexed views improve read performance and I ...