Yes its!!! coming through a jboss layer

Yep thanks 🙂

Eugene Elutin (8/23/2011)

---

Change the database 🙂

Most likely, when you logon as "same user"? you are connected to your database by default.

When you logon as SA, by default you are connected...

steveb. (7/28/2011)

---

There are a few ways of doing this,

one way is to write an update or delete statement in the ole destination and use this in the...

thanks I thought it must be cumulative, just seemed a lot, thanks for putting my mind at rest

Thanks was just trying to get some mental representation of what difference Disk sec/reads makes apart from the usual 0.02 is poor

Hi , This is a virtual server not sure what difference that will make?

But in answer to your questions there are no linked servers, so how else would I...

Answer to my own question

after much hunting around NUMA(hardware only) was suspected. Saw a poor and very high distribution between the nodes on perf counters buffer nodes\Foreign pages.

Added -T8015...

thanks looks like a good book I might get it , but I meant...

GilaMonster (5/11/2011)

---

Thanks, I'll take a look later.

There's something wrong with the cardinality estimation, on SP4 the estimated rows are in the hundreds of thousands, while actual rows is 1. This...

wow thanks so much very interesting, I will look into that more deeply, I was just lucky to pick that query up my fear is that other queries are being...

sorry here you go

--Hope it's all there thanks for looking 🙂

--SP4 BAD

--Index

CIX_TableA_offerclustered located on PRIMARYoffer

IX_TableA_val3nonclustered located on PRIMARYval3

IX_TableA_val4nonclustered located on PRIMARYval4

IX_TableA_idnonclustered located on PRIMARYid

PK_TableAnonclustered, unique, primary key located on PRIMARYprimaryKey

--Table def

SET ANSI_NULLS ON

GO

SET...

post the table? Afraid not there is sensitive information in it, what are you hoping to see from having the table would that help finding out why there is a...

Yes same indexes and i have run update stats...