Shrinking always is not good practise check the file why its growing and check the recovery models

and also how was your backup strategy.

sql 2008 --right click on database -->tasks-->shrink--> select files--> select file type log simple!

In sql 2000--you need do with the script google it

I think you have more number of rows of data in your prod tables than your stage server.

This is what the issue the tables you use in your store proc...

try opening through the run

open run--> type in SSMS

Just try!

check in task manager to see any other applications running and stoping your serevr to connect .

Try everything you...

did you look at the paging file...

what is your paging file size and what is your physical server?

I think he needs find out who or what are doing the deletes not the data what is deleting.

give security admin permission it would work on both sides.

memory management is controled by sql server

when it requires it gets memory by deleting some plans from the cache

you can still release memory from plan cache by doing...

You no need to stop any service while you do rebuild indexes offline.

schedule it when your server is less productive or less no.of connection depends on your business.

My select query runs fine when i search with IS NOT NULL criteria and works terrible when i assign a value..Example is mentioned below:

SELECT * FROM myview WHERE column_flag =...

Check on database when was the stats last updated

run this script if they are updated long back

USE pubs -- Change desired database name here

GO

SET NOCOUNT ON

GO

DECLARE updatestats CURSOR FOR

SELECT...

same results no improvement. It is retrieving from a view and it was working fine until yesterday..

Run both queries and include exec plans and see you will find the difference...

first thing never use select * instead write column names because it causes table scan in many cases.

any way use

is_flag like N

and try

do

dbcc checkbd

dbcc checkalloc

then sp_update stats.

Check the query you are running may be they are using a temp table or temp variable

to load data temporarily.

If is that the case then you should...