If the column is never in a join or a filter then it is purely a cost on the system.

Stats only autoupdate if there is a query on it so...

If char and ascii are not supported, then there is no solution I can think of, and my CLR will have to carry on a bit longer.

Will have to think...

VastSQL (4/21/2016)

---

Hi Experts,

We have more than 100 Foreign Keys with no supporting index. Do we need to add index on all these Foreign Keys ?

Can someone help on fixing this...

Thanks Hugo for giving this a review.

The test you ran with the 250ms, was it on one row or the entire table?

And was it on super powerful hardware?

I reran...

Just for clarity, a heap is a table that is not clustered.

So...

tripleAxe (4/21/2016)

---

I was still using DBCC DBREINDEX to carry out the index maintenance where we had issues with statistics being updated. IIRC it was SQL 2000. So the index...

Will do but only on monday.

You could find it in the adventureworks2016ctp3 db if you cant wait till then.

Jacob Wilkins (4/22/2016)

---

RAND() is a function. You need those parentheses.

Also note that if you create such a column and insert multiple rows in the same statement, they will all have...

guessing that it should be (rand())

Will check ina bit.

The index is not sorted by itemNo.

It is sorted by date.

So you dont have an index on data sorted by itemno.

Imagine a phonebook sorted by Lastname, Then by firstname, then...

Check to see if the indexes are being used, or if they are duplicated, or if you can create better indexes, i.e. consolidate.

It would be horrible to rebuild 800GB of...

If 700K transactions are causing performance issues, then look for missing indexes or queries that are generating a lot of IO.

check the query duration stats for this proc.

This will allow you to zero in to the batch that takes the longest time.

Also, try updating values on change only.

I once fixed...

There won't be any relationships.

You have to code it in with FKeys and Pkeys.

If you have Pkeys on Identities, then use this.

http://www.sqlservercentral.com/scripts/integrity/136833/

It will give you a rough guess how...

Sergiy (4/20/2016)

---

last name...