What is 32-bit, is it the OS or the installation media?

SQL Server 2008 (and above) is a combined installation media and will default to the OS that you are installing...

To validate your IO - you should be looking at the Avg Disk Reads/sec and Avg Disk Writes/sec counters. Open perfmon on the server and start capturing those numbers.

For...

Good call - would be my next question also. But, just to verify I...

ofirk (5/23/2011)

---

How about a trace? I believe if you trace 'Statement Complete' you eventually may be able to see all trigger activity (by Object name/type).

Tracing to that level however, may...

I am not sure what you are asking here - if you are...

What I would do is create a server side trace - or login trigger to capture logins. Review the logins and disable any logins that have not accessed the...

Well, there is no way to determine the activity on a trigger solely. You have to look at the activity on the table which will tell you what activity...

I am not sure I follow what you are trying to identify. Triggers are fired when the table they are associated with are either updated, inserted or deleted.

If you...

Welsh Corgi (5/22/2011)

---

I noticed that you have not defined a Primary Key or a Clustered Index.

Why do you need the Surrogate Key ID when you have a Natural Key ClientID?

How...

prashantcomp90 (5/22/2011)

---

One god news,

my problem is solved. how I tell u.

after so long discussion between us. I thought that if we can combine multiple tables in sql and create...

Lucky9 (5/22/2011)

---

I am sorry again, for the wrong dates

Create Table Status

( ID int Identity(1,1),

ClientID int,

StatusStartDate Datetime,

Status Int)

Insert into Table Status(ClientID,StatusStartdate,Status)

Values(100,'2010-01-28',1)

Insert into Table Status(ClientID,StatusStartdate,Status)

Values(100,'2010-03-20',1)

Insert into Table Status(ClientID,StatusStartdate,Status)

Values(100,'2010-05-30',2)

Insert...

One of the things you should look at is using sp_updatestats instead. This procedure will identify those statistics that need to be updated and only run against those.

With that...

What is the Edition of SQL Server 2005 and what is the Edition of SQL Server 2008 R2?

And finally, what is the OS version that you are installing on?

If you...

My mistake - I switched the ON/OFF for IDENTITY INSERT.

My statement about varchars does not have anything to do with LOB data. When you update a row - if...

Lee Crain (5/20/2011)

---

(Referring to the specific circumstances of the original poster) If so, and "IDENTITY INSERT" were set to "OFF", and FILL FACTOR were set to 100%, wouldn't record insertions...