Hi,

Please help me on this as i am not getting any solution for this.

Thanks,

Ajit

Hi,

I open configuration manager as administrator but still sql server and sql server agent services are missing and

yes services are showing in services.msc

Thanks

Ajit

Hi Koen,

No its standalone SQL server 2008 R2 enterprise.

Thanks,

Ajit

Hi All,

Please provide you help on this .

Hi,

I am having the same situation can anybody help me on this by giving a details example or any helpful link

Thanks

Ajit

Thanks all for giveing me the answer

i surprised by the question posted ................

answers not matching with question posted................:w00t:

Thanks Jim

I am looking for any approach that using DBCC showcontig properly.

Thanks In advance

i think to change DB collation you can use the following simple script

USE [master]

GO

ALTER DATABASE [TEST_DB] COLLATE New Collation Name

GO

HI all

this is condition in which every DBA has to live --Work when you are not at work.

i generally got the phone call on my cell and then connect the...

I am a bit confuse abt it so i didn't add any user in

lock pages in memory option

server is using 10 GB memory for some other process .......

let me check the things as u guided

Thanks

Ajit

yeah we have memory pressure but i am not able to understand some thing

when i executed ur query i got the same value for total memory and target memory ...

hi

thanks for replying

in my scenario i have 64 GB of RAM and i set the min memory =1GB and max Memory 45 GB

but when server is busy the...

Pradeep

Thanks for reply

but in the buffer count buffer comitted is looking static its not changes as the memory usage reduced in task manager

can u please describe these things...