data will need space its his nature plus our requirement too , you need to see the growth percentage and based on that you need space additionally soon you will...

why you are only thinking about tables here ? there could be enormous cause for this degradation like hardware...

MOC Ewez (11/29/2012)

---

As for the PK, one of the indexes I was trying was a unique index with the PK column (CompNr Char(14)!!) plus another column (CustNr Int) which is...

yes but always (not there, where col3 is...

WHat if we use SSIS to do this stuff more robust more tracable .. more comfortable to handle heavy volume data. i will welcome suggest on this suggest 🙂

i am surprised why not anybody refer here machine's event viewer(log ) or ot doesnt help in cases of vm machines :unsure:

@rob-2 And Query ???

sql optimizer defintely choose only that index which is...

bleroy (11/27/2012)

---

HI,

just to make sure I understand:

You could essentially retrieve that unique record by using just 1 or 2 columns in your WHERE clause.

E.g. SELECT EMP_ID, NAME FROM STAFF_LIST WHERE...

Soon any expert will be here (i would expect gail ) to give you clear and better picture

obviously both are totally different as they contain different no and type of column's filer so i am 100 %...

thanks gail

Can you please explain this

see this http://msdn.microsoft.com/en-us/library/ms345414(v=sql.105).aspx

and also http://www.sqlservercentral.com/articles/Administration/64582/

hisakimatama (11/8/2012)

---

If my understanding of the dirty reads process is correct, even if all transactions at a given time have been committed, page splits may still occur for a short...