Hi,

Ok, but this is not the best strategy. It would be a better idea to call Adobe Acrobat from web application NOT SQL Server. Your application should be...

Hi,

Looks like you have x64 version of product?

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi,

Why are you trying to open Adobe Acrobat from SQL Server?

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi,

What service pack does your Windows OS have installed? What kind of hardware are you using?

What type of shared storage are you using (e..g direct attached or SAN)? ...

Hi,

As long as the column on the table has the identity property turned on, this will autogenerate a value for each row imported.

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi Carl,

Absolute pleasure.

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi,

No, as it needs to figure best way to get to the data? You can "guide" using hints, but other than that, you cannot tell it not to create...

Hi,

You should be fine, as logic is based on physical processor.

Here's some reference info:

http://download.microsoft.com/download/6/8/9/68964284-864d-4a6d-aed9-f2c1f8f23e14/hyper_threading.doc.

Thanks,

Phillip Cox

MCITP - DBAdmin

Hey,

It's a master database query.

Thanks,

Phillip Cox

MCITP - DBAdmin

Hey,

Have you tried adding the covering index on:

COBDATE, ACCOUNT?

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi,

have you enabled remote connections via the Surface Area Configuration tool?

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi,

You'll need to enable the Agent XP's by using following:

sp_configure 'show advanced options','1'

RECONFIGURE

go

sp_configure 'Agent XPs','1'

RECONFIGURE

go

This will enable Agent XP's and SQL Server Agent should start.

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi xgoulay,

Umm..they execution plan is exactly the same? Do you have an index on the CODOB column on each table?

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi,

Try this and let me know results:

execute sp_executesql

N'SELECT COBDate,Account,SUM(Amount) AS Amount FROM uv_rules WHERE COBDate = @COBDate GROUP BY COBDate,Account',

N'@COBDate smalldatetime',

@COBDate = '20080229'

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi,

You can re-write the query using sp_executesql, as using this strategy will ensure sp_executesql gets an execution plan, which will be compile with a value for the varible and hit...