i done this in help---index in ssms

but i want the simple meaning in common words

this is the query

select count(*) from acmt

when we execute this output has to display the records count in it

but some times it is taking 12 to...

i replied to alivn

awesome reply alivn

from my point of view ithnk so if not please correct ----any one can suggest me------

coz inthis sort of scenarios only u will have two options

1. as...

HI jeff

After discussion with application team and client

>1. WHAT are you using to do the upload with?

-- Around 800 mb size in around 600 .dat files...

hi jeff

1. its the data of the transactions from the bank[client ]

2. no idea

3. may be csv and batch files

4. no idea coz no blocking happens till...

HI jack & jeff

1) IT is in the batch format from bank [client is banking domain]

2) yes update statistics are enabled and runs at morning 2AM]

3)when ever this issue comes...

HI,

1. there are so many process running in the activity monitor and neither of the process should be killed for that so much of long protocall has to follow

2. i...

2.13 ghz and 16 gb ram is available in the server

ivl check and get back to u soon and thanks for the nice guidence from u and gail

ya anthony is asking me the details but frankly saying i dont know how to check and also dont want to take any chances inthis production servers and as...

1. i followed ur posts and suggested same to my team also but not accepting just they want to reduce onlyy and ur posts also provided nice guidence

2....

please suggest the quick solution to reduce the memory utilization high again same issue happend and windows team send me the mail to resolve this i tried to reduce...

in client its damm difficult to make them accept to increase RAM and all and about windows team they are doing there work to intimate me they are doing that...

i didn't konw actually i goolged and set the value 100 in t&d later i tried 512 mb for the max memoery instead of 1024 mb [actuall] but before changing...