One should ALWAYS explicitly fill...

I am probably one of the most qualified out there to answer this, since I actually have run 7400+ databases on a single (SQL 2005) server and managed to do...

Thanks for that Jason!

When I want to test the server performance of a large set I usually do it thusly:

declare @var1, @var2, @var3, @var4, @var5 (appropriate definitions here)

SELECT

@var1 =...

Please give us create table statements and inserts to set up the data the way you list it. Then we can give you a statement to reproduce your desired results....

Several things:

1) Main one is that you are putting NULL into the running total column to start. You KNOW you are creating fragementation with page splits. So why didn't you...

Jason, I don't think we can call your test apples-to-apples, at least not "real-world" anyway. At least 95% of the real-world running totals cases I have ever seen are a)...

Grant Fritchey (5/28/2015)

---

TheSQLGuru (5/28/2015)

---

This is SIGNIFICANTLY misguided, IMHO! I will jump through EXTRAORDINARY hoops these days...

Done correctly (i.e. with ROWS instead of the default RANGE), the enhanced WINDOWING functionality blows away even the Quirky Update method for Running Totals. Here is a great blog...

This is SIGNIFICANTLY misguided, IMHO! I will jump through EXTRAORDINARY hoops these days to trade CPU...

raf.figueroa (5/27/2015)

---

Kevin,

I am not sure where did the 6 disk come from? in my original posting the scenario is to use 2 (two) 6TB disk, when spanned the two disk's...

raf.figueroa (5/27/2015)

---

Hi,

I plan to implement the disk spanning feature in Windows Server 2012 in order to create a single 12 TB volume (using 2 x 6TB disks). The new...

99.x% it is this, or plan caching got you a plan for inputs that were optimal for that set but...

Nope, sorry. I don't like to...

This thread has become a laundry list of worst practices!! 🙂

I have had several clients have significant problems with McAfee on production servers, especially SQL Servers. I have never had a client use McAfee on a SQL Server with success.

Has...