I can make this work, thank you for your help.

Thank you for your reply. Perhaps I'm not being clear, There should be a way to get from the cache a list of queries from a specific database and return...

The guessing game that is the plan cost I agree is not accurate. I'm more concerned with cpu,ram,io and execution times.

That being said, the query will probably have to be...

Hi Jayanth,

I actually read that whitepaper and got that trace flag from there.

I understand some queries might degrade, but how can the query perform 15x better with no parallelism?

Understand this...

Hi,

I'm not sure if you are on SQL Enterprise Edition, but what about compressing your database using DATA_COMPRESSION (PAGE or ROW) option after analysing your table

requirements. Currently, I'm doing our...

Hi Jeff,

1.Upon my analysis, the Database is 2x the size of it's data files.

Now, I believe this had been caused by the archaic ETL processes over time,

but I have yet...

Lowell,

We like simple solutions and yours works well

Thanks for the reply.

Cheers

-RR

Yes, DR is very important, but not the topic of this thread.

I'm focusing on ISO 27001 standards which focus on information security.

For the moment, MS SQL Security best practices...

I am aware of what ISO 27001 is about, my question is what as a SQL DBA could I be doing to my database systems to align with my companies...

Hi,

Cheers for your reply,

I found that it was not the full path of the "physical_name" column of msdb.dbo.backupfile because that had used only 181 of max 260 chars,

but...

Thanks for the information, it makes sense. I suppose will have to restore and then defrag/truncate and compress all those unnecessary partitions.

For a refresh done daily, I was hoping for...

Thanks for the info Grant. Can you clarify how a partial restore works in terms of space allocated? I've read some blogs on the practice but they basically claim it...