How can I check?

As in Windows Authentication?

Hi Guys

By declaring the variables as below - Will that guarantee that every number generated is Unique?

SELECT @NumberOfRows = 10000000,

@StartValue ...

Ken Davis (3/23/2012)

---

I don't know the answer to that. If I remember correctly a rebuild index maint plan step will rebuild all indexes regardless of their fragmentation. Have...

Ken Davis (3/23/2012)

---

In my experience, a 2005 ALTER INDEX REBUILD ONLINE will fail if it finds a LOB column. I have a script that checks alloc_unit_type_desc in sys.dm_db_index_physical_stats to...

GilaMonster (3/23/2012)

---

derekr 43208 (3/23/2012)

---

The performance degradation only comes in where SQL needs to perform a large range scan, something like select some_column from some_table where some_column between two or more...

GilaMonster (3/23/2012)

---

No, the nonclustered indexes always contain the clustered index key.

So your nonclustered index on Col2 will actually be Col2, Col1 or Col2 inlcude Col1, depending whether the nonclustered...

A nonclustered index does not just contain pointers to the data. It contains columns - the index key columns, any include columns and the clustered index key. It's in fact...

GilaMonster (3/20/2012)

---

derekr 43208 (3/20/2012)

---

GilaMonster (3/20/2012)

---

derekr 43208 (3/20/2012)

---

So, no extra disk reads are required when SQL tries to find a value on a page that has moved because of recent plage...

GilaMonster (3/20/2012)

---

derekr 43208 (3/20/2012)

---

With this in mind - Is it safe to say that when a Clustered Index is fragmented, the affects are much worse than when a Non-Clustered index...

GilaMonster (3/20/2012)

---

Pages don't move...

GilaMonster (3/14/2012)

---

derekr 43208 (3/14/2012)

---

I'm obviously missing something here

If the non-leaf pages are aware of the page split at the leaf pages then it knows the new location of the Value...

GilaMonster (3/15/2012)

---

derekr 43208 (3/15/2012)

---

Maybe I should have worded my question like this:

>>SQL is looking for value 'X'

>>According to the non-leaf index pages, 'X' on leaf page #10

>>SQL goes to find...

Thanks

Another thing

To make use of the AlwaysOn availibility groups on SQL 2012, does the server need to be clustered?

Thanks