Viewing 15 posts - 1,501 through 1,515 (of 5,843 total)
Jason A. Long (6/1/2015)
TheSQLGuru (6/1/2015)
Thanks for that Jason!
No problem. Thanks for kicking me in the back side to get it done... With the data partition and the select output. 😀
When...
June 2, 2015 at 8:54 am
Although the defaults for the over clause do imply "and current row", I prefer to spell them out rather than relying on the defaults.
One should ALWAYS explicitly fill...
June 2, 2015 at 8:40 am
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...
June 1, 2015 at 7:43 pm
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 =...
June 1, 2015 at 7:35 pm
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....
June 1, 2015 at 11:57 am
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...
May 31, 2015 at 8:07 am
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)...
May 30, 2015 at 8:31 am
Grant Fritchey (5/28/2015)
TheSQLGuru (5/28/2015)
Also, I was leery of adding OPTION (RECOMPILE) for something that runs that often.
This is SIGNIFICANTLY misguided, IMHO! I will jump through EXTRAORDINARY hoops these days...
May 29, 2015 at 8:14 am
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...
May 28, 2015 at 1:12 pm
Also, I was leery of adding OPTION (RECOMPILE) for something that runs that often.
This is SIGNIFICANTLY misguided, IMHO! I will jump through EXTRAORDINARY hoops these days to trade CPU...
May 28, 2015 at 12:40 pm
raf.figueroa (5/27/2015)
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...
May 27, 2015 at 3:40 pm
raf.figueroa (5/27/2015)
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...
May 27, 2015 at 12:10 pm
GilaMonster (5/27/2015)
Bad cardinality estimations perhaps. Can you post the problematic plan?
99.x% it is this, or plan caching got you a plan for inputs that were optimal for that set but...
May 27, 2015 at 10:12 am
Eirikur Eiriksson (5/23/2015)
TheSQLGuru (5/23/2015)
This thread has become a laundry list of worst practices!! 🙂That by itself presents an opportunity, care to do a write up?
😎
Nope, sorry. I don't like to...
May 25, 2015 at 9:57 am
This thread has become a laundry list of worst practices!! 🙂
May 23, 2015 at 2:34 pm
Viewing 15 posts - 1,501 through 1,515 (of 5,843 total)