Agree with Michael: using BCP from a trigger is a bad idea, and re-querying data from another process synched with your trigger code (and that is what you are doing...

OK, here is my entry. This should be pretty close to what you want. Note that if you do not have case-sensitive collation on your database, then you...

average Hard page faults below 10/sec should not be a problem.

Suggest you do the following:

1) Get the CPU% and the (correct) Disk Idle% for all of your disks

2) use profiler...

Oops, good point.

Not disputing anything else posted here, but Named Pipes are nowhere near as old as TCP/IP sockets...

CommVault has a good solution also.

If mydate is not the Clustered Index and the total numbers of rows it estimates to return exceeds some value (10% maybe?), then it will scan instead of seek.

Right you are, my...

COUNT(column_name) can do this also, no need for all of the CASE functions. Just subtract it from COUNT(*) for the count of NULLs in the column.

Try this:

Update dbo.service_orders

Set repeat_call = 1

From dbo.service_orders O

Where Repeat_call = 0

And Exists(Select * From dbo.service_orders o2

Where o2.ID_Code = o.ID_Code

And DateDiff(dd, o2.service_date, o.service_date) <=...

Are you creating tables directly in TempDB?

SPID's do get re-used, you know.

SysProcesses should be fine.

vittorio caminiti (4/22/2008)

---

Thanks for you answer, but can i ask you why you are sure of that? So what it the purpose of view then? just security and make the...

Reasons for "DB not accessible":

1. The DB does not exist

2. The DB/server is not "up" right now.

3. You misspelled the Server/DB name.

4. The DB/Server is not on the network.

5. You...

Methods of finding pre-defined ranges from Excel macros:

1) Fixed column/row offsets

2) "marker" or "flag" values

3) Named ranges

4) Dedicated sheet

(anything on the sheet is part of the range)

5)...