Here comes another question

I created a table with GUID column with NEWSEQUENTIALID() as default.

create table table_name (i UNIQUEIDENTIFIER deafult NEWSEQUENTIALID() , j int,k int)

While inserting sometime the value are derived...

i have been here for couple of time but now more concern on fragmentation.

If i use NEWSEQUENTIALID() then there will be less fragmentation ok good, but how about the join behavioural ?

for the test of 1000 record on a table with INT/GUID...

Do the table will get fragmentation often in GUID?

I checked the table with the fragmentation so i ran the dbcc dbreindex (we can ran the alter command also but i...

Then how to rely on it ?

HanShi (5/7/2014)

---

This could be the default limit in SSMS. Look in SSMS...

-ve --> negative.I got the negative value in one of my statement.

If you see the duration which i have provided is in milliseconds and thats too 43 millisecond.

yuvipoy (4/22/2014)

---

After doing the recommendation i now see that the query is using index seek with 84%.

So my question is index seek is better than index scan

previously my query gave...

Thanks for your answer. let me look and come with necessary details.

Actually i just moved my SQL server 2000 to SQL server 2008 and did not run any data. just migrated the SQL server 2000 to 2008, so thats why i...

After doing the recommendation i now see that the query is using index seek with 84%.

So my question is index seek is better than index scan

previously my query gave index...

Sorry i did not replace my table plan, now i replaced my plan with the table which i have give.

Lynn Pettis (3/29/2014)

---

For this particular issue, possibly no real benefit. The problem we are having is that we can't see what you see which means all we can give...

Yes i am accessing the database via Enterprise manager and Query analysier.

GilaMonster (4/16/2014)

No.

The option affects where SQL allocated sort space during and only during an index rebuild. It has no effect at all after the rebuilds has completed, it has no...