I am not a DBA for this company, just a temp assignment for 4...

I am aware of that but due to the nature of LOB application and some tasks that processes...

Not very familier with Oracle but try,

Dynamic Management Views should give you a lot of information. Which version of SQL are you using?

http://msdn.microsoft.com/en-us/library/ms188754.aspx

select * from sys.dm_

* Sets some database to Simple Recovery Model

* Sets AUTO UPDATE STATISTICS on some databases

*...

Ofcourse it will be tested first but we are not using any specific feature that...

GilaMonster (2/19/2012)

---

Just a point, if SQL is not on a dedicated server, then setting a sensible max server memory is almost essential. It's recommended even on a dedicated server, especially...

The maintenance task takes around 110 Minutes to finish but it does a lot more than just Reindexing. We have also collected a massive work load files using profiler and...

Thanks Steve.

Yes I know that SQL Server should be on a separate host but we are stuck with it for now.

I have checked and the Target Memory for SQL Server...

Thanks Anthony.

I have already downloaded the trial of Apex softwares. From what I can see, it can also load BAK file directly without restoring. Anyways, at the moment we are...

Hi,

How would I set that trace? Do you have some code handy? I would really like to be prepared for the next delete phase as I am almost certain that...

Thanks. Much appreciated.

Yeah we have asked the DBA to take transaction log backups every 30 minutes during the course of this investigation. After that we will change it to an...

Hi,

This just happened again. Sunday 2 PM was a full backup right after we restored all the missing records and Monday 9:20 AM 250000 records have been deleted. I am...

Hi Lynn,

Thanks for a quick reply. We are using Full Recovery.

We are experiencing of deletion of records that we think is not legit. We have changed all the passwords and...

So I assume that 1000 records per query would be ok.

Thanks skcadavre,

That works great. I was pondering upon your remarks of improving it, was wondering what you meant! More efficient code, faster performance, less code?

TA 🙂