Slightly of the mark but never the less.

http://manuals.sybase.com/onlinebooks/group-as/asg1200e/aserefmn/@Generic__BookTextView/172152

Search for 99.

quote:

---

5005

extents used

Specifies the number of extents allocated to the object in the partition...

May help a bit

http://www.sqlmag.com/Forums/messageview.cfm?catid=22&threadid=2089

From the thread

quote:

---

We replaced:

"D:\DB\BackupFolder"

with

\\Servername\d$\DB\BackupFolder

---

Suresh_yaram just a side attraction.

Why do the dates seem to to the nearest second or is just coincidence. DateTime is to the nearest 3/1000 of a second which may help...

Not a 100% sure but on 2000 one cannot restore a specific table only, can restore a specific filegroup.

quote:

---

BOL 2000: If a...

Some general info:

http://www.sql-server-performance.com/oltp_performance.asp

http://www.sql-server-performance.com/sql_oltp_article.asp

Feels a bit slow, maybe you should try it in a stored procedure

Create Table NewOld(New Char(1),Old Char(1))

Go

Insert NewOld values('B','A')

Insert NewOld values('C','B')

Insert NewOld values('F','B')

Insert...

Agrees, costs of sum versus check and real sum. Sounded like he wanted his solution.

Havent tried it, but what about If @@Error= 0 Return 1 Else Return 0 after the BULK INSERT statement

Maybe of some relevance.

See BOL 2000: Using Partitioned Views

quote:

---

The SQL Server query optimizer recognizes that the search condition in this SELECT statement...

Good to know you are over the ditch.

Thanks, its helps to be in good company

Frank, maybe its time to drop the numbers game and get a more sociably tag

Agree with previous comments.

Maybe you can try IN versus the ORs

SET ANSI_WARNINGS On

SELECT Case When Sum(Case When Val Is NULL

Then 1 

Else 0 End)>0 

Then NULL

Else SUM(VAL) End 

FROM (

SELECT 1 AS Val UNION

SELECT 2 UNION

SELECT...

Can multi records be involved? If multi then some records may exist and some may not exist in the second table

May help a bit

"Migrating from Oracle to SQL Server: Part I"

http://www.sql-server-performance.com/np_migrating_from_oracle_to_sql_server.asp