Yup - I did that in a few cases where squeezing any amount of time...

Note that the domain account in this case should be a GMSA/MSA account - not a normal user account.

If this is not the type of account you created/used I would...

good to see that at least 2 members did understand what I was stating about count(*) vs count(1).

Brahmanand stated that "count(*) would need to read all data from the table"...

from my personal testing over the years splitting onto 4 files even if they are on the same destination disk will normally yield best results than 1 or 2 files...

its not for all things - I have a particular case on a DB that I am working at the moment.

big table - 150 Million records -

Most common sql on...

• This reply was modified 5 years, 10 months ago by frederico_fonseca.

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...