F-Keys might be the reason.

BTW how did you find out there were large number of reads?

Hi

In both the cases you want to display 1? If thats the case then whats the problem?

Think this is self explanatory. What are u logging in as while doing this ?

Thanks Grant.

You can try server side tracing. Create traces that write to a file and be as specific as you can (mentioned in previous post).

one article i can point out is...

"Dropping a rebuilding a clustered index on a partition scheme will move disk to other drives." - Very confusing.

Grant

Does the default trace show delete statements?

nice article jacek!

Any particular reason why you are following such a design?

another simple way

Select * from

cow2008 c inner join cow2009 d

on c.cow_id = d.cow_id

WHERE c.cow_name <> d.cow_name.

You could also create a dynamic sql in which the where...

Read articles on various sites , look into different forums and learn from anywhere and everywhere.

Most importantly try out things on your own.

Hi

Just a suggestion...

What about a server side trace that tracks delete statements. You can filter out delete statements from application users.

avi-631555 (9/24/2009)

---

Thanks that works,thanK you so much

thers is somehting else i am struggling with While upsizing from access to SQL all the IsActive fields that are of...

BULK Insert or BCP are specifically for importing lot of data into sql server. If you are using either of them inside a procedure you can create a job that...

Hi

i tried this....

create table t2 (col1 float(8))

insert into t2 values (23423889777777)

select left(col1,8) from t2 - returns "2.34239e"

select left(cast(col1 as numeric(21,2)),8) from t2 - returns 23423889.