"Listing 6: Subquery in function call" looks same as Listing 5.

Thank you for the replies. I'll prepare sample data and examine the plan. Then I can share the results here as well.

I asked the question because if I get a...

Abs-225476 (6/29/2011)

One thing I would say is to make sure you do a test run to yourself, you wouldn't want an incorrect report to be sent out to 2000 users...

Yes that is exactly what I want. Thank you very much.

In this article it is explained well: http://msdn.microsoft.com/en-us/library/ms169673.aspx

Thank you very much. I'll try to find more resource on data driven subscription topic.

I found something, it may help others as well:

http://msdn.microsoft.com/en-us/library/ms157252.aspx

http://www.codeproject.com/KB/reporting-services/PDFUsingSQLRepServices.aspx

http://www.sqlservercentral.com/articles/Development/datadrivensubscriptions/2432/

My question is how do I use report service to send N number of reports, while N can be changed. And in my case it is ~2000.

So is it possible...

Hi, as I said in my first post, it is still worth because SQL Server creates a thread to read data for each file even those files are on same...

Hi,

Multiple files gains some performance since SQL Server uses multiple threads to read data. If those file are on different physical drives then you gain some more performance.

If your database...

log table ~9-12 GB (rows for 3 months)

archive table: depends on how many records but same size with log table. 3 months = 9-12 gb. mostly my customers holds rows...

I created that computed column as primary key with IGNORE_DUP_KEY=true, so it won't lead an error if hash collide. And of course it is a very (very!) little chance to...

Thank you very much for your explanations.

As you said, it is not a clustered index, I use it just for making rows unique without creating a big multi-column unique index....

Don't use BEGIN TRANSACTION and COMMIT, it will rollback if an error occurs.

If you use Management Studio put GO (batch separator) between each lines.

INSERT ...

GO

INSERT ...

GO

...

If you use vbscript or...

Try using BULK INSERT instead (or bcp.exe) and play with batchsize setting.

Thank you for the replies, I use asterisk just to keep the example short.

I sometimes don't use FKs because of compatiblity with other db systems.

I know it is important for...

Thanks for the reply, I guess no chance without adding new/computed columns.

Even constant values prevents using the index.

select * from t where a + 1 = 500

a is indexed, but...