Questions in topic: indexing - SQL Server Q&A from the SQL Server Central community

x

login about faq Site discussion (meta-askssc)

Questions in topic: indexing

8

votes

2

answers

117

views

Should I index a foreign key?

Feb 06 at 05:05 PM tomgough79 1.1k

indexing foreign-key

7

votes

1

answers

928

views

Is this normal for indexes from SQL 2000 to SQL 2005?

Sep 10 '10 at 12:49 AM Fatherjack ♦♦ 38.8k

sql-server-2005 sql-server-2000 indexing upgrade

7

votes

3

answers

1.3k

views

Suggested index already exists

Sep 26 '11 at 09:09 AM Fatherjack ♦♦ 38.8k

sql-server-2008 indexing dmv

6

votes

3

answers

1.5k

views

Execution Plan Recompile

Jan 07 '11 at 05:42 AM shannonlowder 61

indexing rebuild reorganize

5

votes

7

answers

18.3k

views

Should my primary key be clustered?

Oct 15 '09 at 11:02 AM thatismatt ♦♦ 210

sql-server ssms indexing database-design primary-key

5

votes

2

answers

651

views

Composite Index usage

Dec 23 '09 at 05:23 PM Dave 3 53

indexing

5

votes

3

answers

127

views

CREATE NONCLUSTER INDEX IN DATAFILEGROUP OR ON INDEPENDENT FILEGROUP

Feb 27 at 03:04 AM KenJ 12.4k

indexing

5

votes

1

answers

84

views

Help with the proper index

Mar 05 at 05:47 PM Grant Fritchey ♦♦ 62.6k

sql-server-2005 sql-server-2008 indexing

4

votes

3

answers

2.4k

views

SQL 2008 - missing indexes

Oct 15 '09 at 05:55 AM Ben Adderson ♦♦ 361

sql-server-2008 indexing

4

votes

2

answers

4.4k

views

What is the difference between a seek and a scan?

Oct 22 '09 at 08:08 PM Steve Jones - Editor ♦♦ 5.1k

t-sql indexing execution-plan

4

votes

3

answers

1k

views

How do you run a trace to grab the TSQL query that is using a specific index

Nov 15 '09 at 10:13 PM Tim 31.5k

indexing profiler sql-trace

4

votes

5

answers

2.4k

views

Clustered Unique Index vs PK

Dec 16 '09 at 10:47 AM Fatherjack ♦♦ 38.8k

sql-server-2005 indexing

4

votes

3

answers

488

views

Clustered Index

Mar 15 '10 at 04:29 AM Matt Whitfield ♦♦ 29.2k

indexing

4

votes

2

answers

6.8k

views

"Use Page Locks When accessing the Index", "Use Row Locks When accessing the Index"

Mar 24 '10 at 04:04 AM Sedat 41

indexing

4

votes

4

answers

7k

views

Using isnull() in the WHERE clause

Aug 10 '10 at 05:34 AM GPO 1.7k

tsql performance indexing null

112 questions

257answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags

sql-server-2005 × 1835
sql-server-2008 × 1601
t-sql × 914
sql-server-2000 × 454
sql-server × 272
tsql × 224
performance × 220
ssms × 118
indexing × 111
database-design × 107
upgrade × 61
execution-plan × 34
profiler × 30
foreign-key × 27
primary-key × 27
null × 25
dmv × 17
rebuild × 14
sql-trace × 5
reorganize × 3

posts per page 15 30 50

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.