without changing the logic of that task it would be possible to change it to be a script component (source) and instead of doing the inserts adding the values as...

SSRS is not free - it is part of the SQL Server license you bought.

From a licensing point of view you can install as many instances as you wish on...

New CE can do quite bad stuff.

One case I had, huge CRM database, had one simple query -- select 6 columns from tbl where field = 'abc'

table with 200 Million...

why don't you try it and look at the resulting explain plan? That should have been your first call before asking on forums.

but answer would normally be yes it will...

I would also try the following. it may be fast enough to allow connection

change the service so it has the -mSQLCMD flag

create a small cmd file with

net stop service

net start...

Just thinking... are you starting sqlserver from the command line or are you changing the service properties and (re)starting the service?

if on the command line then that window will indeed...

I'm with Jeff on this - lots of what is on that are personal preferences and should be decided by each team/organization

For example I do not allow any uppercase  so...

your "requirements" do not match what you trying to do on the sql so please do clarify it exactly.

To get the records added today - which is what...

from the description you are then opening that CSV file with Excel and you wish them to automatically have a particular format applied.

This is not possible with CSV files -...

not just ssms.

SQL Server Agent will grab it immediately if it is active - always stop the service if doing maintenance

but other servers (monitoring tools for example) can also grab...

possibly another process grabbing the admin session before you can do it.

I would try and use the -m startup option with a program name associated. e.g. -mSQLCMD and then connect...

Sam - did you read my comments?

Adding those indexes are not necessarily what needs to be done (as recommendations from the engine are just that)

and is the field I mentioned...

I'm curious - do you have 2 processors with 5 cores each with HT active? or 2 * 10 cores = 20 HT?

Regardless of it I would probably change that...

your "requirements" do not match what you trying to do on the sql so please do clarify it exactly.

To get the records added today - which is what your subquery...

Apologies I should have remove the t1. from the order by when I added the outer select to filter on balance.

Now you have added a further block inside the query....