Ive got files in there from the 26th its happily ignoring.... 🙁

changed it too files older than 2 hours....... still no joy !!

matt stockham (4/22/2009)

---

Was it a small number of peaks? It could be explained by, for example, a backup running. Note that this counter isn't SQL-specific so other apps...

thank you grant much appreciated... I best go investigate your book methinks "!

~simon

thank you much appreciated... I see its for 2005.. does the bulk of the reading etc still remain relevant for sql 2008 ?

regards

~simon

but if theres a reasonable business/security case to hold employees handprint data then presumably the employer could enforce the requirement for it ? as long as their storage of the...

what is the legal aspect of a company holding bio-metric data ? In age when the government is debating compulsory ID cards etc (not to mention losing data with frightening...

thank you Mike.. much appreiciated 🙂

simon

TheSQLGuru (12/9/2008)

---

The optimizer is cost-based. An index seek/bookmark lookup of a given depth takes X cost per row. A table (or clustered-index range) scan takes Y cost per...

I had heard 1000 rows but it would appear by the knowledgable answers...

thank you all very much

food for thought ...

best wishes

~simon

Garadin (11/19/2008)

---

Instead of:

declare @id varchar (10)

declare id_cur cursor for

select id

from redundantdata

open id_cur

fetch next...

Jeff Moden (11/18/2008)

---

Lets say you have 1000 rows of redundant data in each of the 3 tables... which do you think will take longer... 3 deletes of a 1000 rows...

the result of inheriting some maint routines 🙂 Im setting up news ones but heavily based on the old

I believe the rationale was due to the highly volatile...

hiyah

so what purpose would you say yes its acceptable to be a heap ? 🙂

possibly as some of the UK based dbas' are speculating how the holiday...