Hi,

Sorry...forgot to include that answer. Yes, the files will be spread across separate drives and I will be working with our sysadmin to monitor the I/O of the files...

Hi,

Well this is the reason for my testing this out...to see if it in fact does improve our performance. I will see if I can find the specific error...

Hi,

Yes, based on a consultant who came in to help us trobuleshoot performance issues, the two filegroups that we have each with one 300GB file was determined to be a...

Hi,

Thank you for your suggestions. I will definitely look into the order of the transactions to see if we can understand what is happening and why it is now...

Hi,

Yes, the query in the 2nd part is familiar and I know exactly what it is and why is it running. It is a normal part of our ERP...

Hi,

Yes...the first one is for the just comes up as sp_execute

select *

from sys.dm_exec_sql_text(0x0400ff7fb925310a01000000000000000000000000000000)

dbidobjectidnumberencryptedtext

3276717099308110sp_execute

And the 2nd one is the UPDATE that is the victim

select *

from sys.dm_exec_sql_text(0x020000007fd11b0e9277f5657526adf4e320ad4e5becad1a)...

Hi,

We are actually evaluating some different Backup software for that exact reason. Idera's SQL Safe Lite cut my backups down from 500GB to 60GB and only 2 hours vs...

Hi,

Thank you for your replies. Unfortunately I am dealing with some tables that are about 30GB with over 40 million rows, so i don't think some sort of SSIS...

Hi Brian

Thank you so much for that information! I created seperate directories for each instance and it worked! I have another server with two instances using the same...

Hi,

The server is running Windows Server 2008R2 Standard.

Thanks.

I would love to do that for our test environment where space is a premium...restore it and then resize before moving it to the server. Great suggestion!

Thanks,

Isabelle

ok...thank you both for that quick confirmation! That's what I was thinking but just wanted to be sure.

😀

Isabelle

Hi Patrick

Our sysadmin was able to successfully run the command you provided to the F:\ drive and create and save a text file using the domain account that is runninng...

Thank you both for your reply. That's kinda what I was looking for. I will check and see how our licensing works here and choose accordingly.

Isabelle

Got it....found another example in the past posts on the forum....

SELECT CAST(ROUND(OANTAM * (OAOTDP/100),2)AS DECIMAL(10,2))

FROM MVXJDTA.OOHEAD WITH (NOLOCK)

WHERE OAORNO = '1001357174'

result: 23.18

Is it time to go home...