Viewing 6 posts - 1 through 6 (of 6 total)
Hi guys,
any other solutions / explanations for this behaviour?
I do not feel comfortable with adding OPTION(RECOMPILE) to every INSERT we are using to load our data...
October 18, 2017 at 3:13 am
When i use OPTION(RECOMPILE) to the INSERT statement, there is no time difference anymore.
GREAT, but why?
@jeff Moden
Anonymized, compressed DDL:
CREATE...
October 16, 2017 at 3:22 am
Hi,
i did some more testing and checked the data file i/o behaviour:
Without GO: writes in LDF. At the end high writes to MDF
With GO: writes in MDF....
October 13, 2017 at 1:46 am
GregoryAJackson (5/2/2012)
do you think it would be a big performance loss to store tempDB data and Logs on the same Raid?
in our BI(OLAP) enviroment , we use
1. RAID 10...
May 3, 2012 at 2:52 am
Cois (5/2/2012)
I would store it on the logs RAID.
Hi
do you think it would be a big performance loss to store tempDB data and Logs on the same Raid?
in our...
May 2, 2012 at 9:58 am
Where would you store the tempDB Logs in the described "SQL Storage Recommendations"?
On the same Raid as the tempDB data or on the Logs Raid?
May 2, 2012 at 2:06 am
Viewing 6 posts - 1 through 6 (of 6 total)