Viewing 15 posts - 3,466 through 3,480 (of 6,486 total)
Jeff Moden (4/30/2008)
I still like the ultimate power saver... turn it off when you're not using it....
April 30, 2008 at 9:38 am
Jeff Moden (4/30/2008)
Matt Miller (4/30/2008)
I was being funny last night - just remember the "math" version and the "stats" version actually give you different results (based on their different definitions)....
Not...
April 30, 2008 at 8:18 am
I'd have to agree with Michael and Grant. What is it that's being done to take so long?
Like Mr Myagi would say: "Best defence - no be there"....
April 30, 2008 at 7:34 am
Tomm Carr (4/29/2008)
Matt Miller (4/29/2008)
The primary characteristic for a primary key (in addition to uniqueness) is immutability, specifically because of its "deisgnated use" in table relations. And that's where...
April 30, 2008 at 7:23 am
I forgot that my test machine was running a full backup and a virus scan last night...Without the impediments:
(1000000 row(s) affected)
==================================================
Jeffs Statistical Median
==================================================
(70271 row(s) affected)
SQL Server Execution Times:
...
April 30, 2008 at 7:11 am
Jeff Moden (4/29/2008)
Say... do you happen to have the full test slab for that 16 second version?
Sure - I stole your test setup....
--===== If the temp table already exists, drop...
April 30, 2008 at 6:30 am
Shalini - you now have two separate methods which would do what you want. Jeff's doesn't even mess with your initial table, so it's probably the better method (although...
April 29, 2008 at 10:52 pm
One more - this is the "windowed function" version of the statistical median:
select r.Rep,r.MileCode, (r.deltat +r1.DeltaT)*.5 dt from
(select m.Rep,m.MileCode,
...
April 29, 2008 at 10:49 pm
(Jeff - psst)....
(1000000 row(s) affected)
=====================
Jeff's Statistical Median Calc
=====================
(70266 row(s) affected)
SQL Server Execution Times:
CPU time = 70031 ms, elapsed time = 42039 ms.
========================
Matt's Mathematical Median Calc
========================
(70266 row(s)...
April 29, 2008 at 10:31 pm
I could swear I saw the exact opposite article a few weeks ago (about tech salaries firming up)....
April 29, 2008 at 9:34 pm
Jeff Moden (4/29/2008)
Matt... shouldn't that be 0-9?
I knew there was something missing there......:blush:
April 29, 2008 at 9:30 pm
..by the way - it's probably worth pointing out that there are multiple definitions of Median.
The solution Jeff is showing is what is called the statistical median (the...
April 29, 2008 at 9:15 pm
While you're at it - make sure auto-close is turned off as well...
I've had a few installs that somehow "like" to create new databases with autoclose turned ON....not a good...
April 29, 2008 at 3:48 pm
Could you tell us what the data type of TEAM_MEMBER_ROLE is? If it's CHAR or NCHAR - there might be some extra space at the end that is messing...
April 29, 2008 at 3:40 pm
Sergiy (4/29/2008)
To avoid "Division by 0" error it's better to use "else NULL" instead of "else 0".
correct! wasn't paying attention.
April 29, 2008 at 3:17 pm
Viewing 15 posts - 3,466 through 3,480 (of 6,486 total)