Thanks for your valuable reply,

I googled found Parallelism in SQL Server is for Operators involved( actually its bit more but for practical purpose note this) not for the query,...

Dear Ramesh,

Did you looked into task manager that what service is taking more memory.

As per screen shot attached you have set max memory 25GB for sql server, please look into...

Thanks for reply

Sir,

I have run both the scripts , but could not get any result.

But i diagnose the dm_os_ring_buffer exception records , i found there are many errors with code...

Maintenance plans are too easy to schedule Backup,Restore and Index rebuild activities and its great for beginners DBAs ,who don't have too much experience with writing scripts also it saves...

Thanks for quick reply

I have dropped some archived tables from my database , that's why i want to shrink datafiles.

Sir i have two another confusion regarding datafile shrink:

1) Does shrink...

SET NOCOUNT ON

CREATE TABLE #temp(SERVER_name SYSNAME NULL ,Database_name SYSNAME NULL ,userName SYSNAME ,GroupName SYSNAME ,LoginName SYSNAME NULL ,DefDBName SYSNAME NULL ,DefSchemaName SYSNAME NULL ,UserID INT ,[SID]...

select sid,name from syslogins where name not like '##%' and name not like 'NT%' and

sysadmin=0 and securityadmin=0 and setupadmin=0 and serveradmin=0 and processadmin=0 and diskadmin=0 and bulkadmin...