I will try setting min memory to the same value as max and report back the progress.

I have configured max value used by SQL Server leaving 6GB to OS. The min value is currently set to 0.

Is that what you meant?

Thanks Nicholas! I saw several cases like mine and people were reporting that Microsoft came up with hotfix for their enviroment. I was wondering if this fix might have been...

This is a brand new server we just configured. There is no other applications besides SQL Server and OS. SQL Server doesn't have any user databases and nobody and no...

Thanks everybody for their comments!

Igor

Thanks a lot Paul!

Hello Paul,

I have just implemented procedure to perform integrity checks on server in question ;). I am pretty much sure that backups we have contain corrupted information....

I wanted to collect/analyze this information through TSQL. I think I came with solutions (thanks to help from other user):

SELECT h.destination_database_name,

...

It is not. Actually, you don't event have to make database name in lower case. DELETE FROM [SPRSTRATA].[SBMsdata].[sro].[MediaPlanAdMap_Staging] also works.

Thanks again Paul! I am just surprised that nobody noticed this before.

Igor

As strange as it might seems:

delete from SPRStrata.SBMSData.sro.MediaPlanAdMap_Staging - error

delete from SPRStrata.SBMSData.sro.MediaPlanAdMap_Staging where mediaplanid = mediaplanid - works, although logically similar to previous one (assuming there are no NULLs)

delete...

Paul,

Thanks for looking into this!

Igor

Hello Paul,

Thanks for you reply! I did check this table and found no entries with restore_type R. This is weird as I definitely reverted to snapshot several...

Thanks Andras!

In General section I have Auto list members and Parameters Information selected. When I type in MDW database: SELECT * FROM core.sou

I expect to see some sort of list similar...