Don't use RETURN for returning values.

It returns error code and it's better to leave it this way.

ALTER PROCEDURE dbo.cdds_Download_Count_Select

@DataId uniqueidentifier,

@RowCount int OUTPUT

AS

SET NOCOUNT...

Jeff,

should I post couple replies?

Just to show how good you are to OP.

:hehe:

CREATE PROC dbo.MyProc

@param1 ...,

@Rcnt int output

AS

SELECT .....

SET @Rcnt = @@ROWCOUNT

GO

Read parameter @Rcnt after SP execution and get your query rows counted. 🙂

Defragmentation won't help much.

You can even polish your highway - scooter would not go any faster.

I can see only 2 suggestions:

1) improve Documentum software;

2) replace Documentum software with something matching...

Probably what you need is bcp utility.

Read the topic about bcp in BOL, it's quite good, if any questions remain don't hesitate to ask.

Arun T Jayapal (1/18/2008)

---

Ok here is a scenario. What if based on some condition your procedure displayed two or more different kinds of result sets? Is there a way to...

Drop all indexes on this table.

SQL Server uses indexes to find the page with requested data.

You whole table fits in one page. Any index on this table is just a...

Identity column follows the order defined by

order by b.somecolumn

lindasmail76 (1/17/2008)

---

I'm creating a #tmptbl table based on a query. I want to create a sort order column so I can join this temp table with another table and...

No, it's 4 seconds every time, very rarely 5 seconds but I consider it's rounding.

If job steps take 2 seconds in total, job take 6 second, if 10 then 14...

Create a table with your intervals:

StartTime, EndTime

1/1/2008 00:00, 1/1/2208 01:00

1/1/2008 01:00, 1/1/2208 02:00

....

Don't worry, it's just about 85k rows per 10 years, not a big deal for SQL Server.

Disk size...

It's not a clever way.

It's just following one of normalization rules.

Read it on your spare time.

String 'sampletest^' has 11 symbols.

And you parameter is VARCHAR(10).

11^th symbol is just truncated.

Really?

Can you share your negative experience?

Because I use...

You welcome.

Me too.