Viewing 15 posts - 976 through 990 (of 5,504 total)
Jeff Moden (9/13/2011)
September 14, 2011 at 1:03 am
Please have a look at the CrossTab article referenced in my signature. This concept will work if you have a known number of comments. Otherwise you might want to read...
September 13, 2011 at 2:25 pm
Step 1: get the c.u.r.s.o.r. *cough* approach out of your head.
Step 2: get the relevant max values off the "big table".
Step 3: perform the running total on the 10k rows...
September 13, 2011 at 2:20 pm
virgilrucsandescu (9/13/2011)
They need one Excel column for each row in the dataset, and...
September 13, 2011 at 1:18 pm
Please have a look at the CrossTab article referenced in my signature.
Even though it has a MAX() aggregation in there, it still provide the results you're looking for.... Don't be...
September 13, 2011 at 7:04 am
change authorised_date <='2011-05-31' to authorised_date <'2011-06-01'
September 13, 2011 at 6:43 am
From my point of view the expected output doesn't match the original data:
In the original data there's one update capture missing where Test changed to Test1. Also, ActionTime is not...
September 13, 2011 at 6:41 am
Thank you for the feedback.
I'm not sure if we're just "chasing the wind" here since I'm observing exactly the same (everything runs fine except the number increase).
If neither one of...
September 13, 2011 at 4:03 am
Hi Nils,
thank you for your prompt reply!
Unfortunately, there's no transaction involved (neither in the SEND nor the RECEIVE block).
The concept is based on Rusanu's reusing-conversations script (link in the SQL...
September 12, 2011 at 8:46 am
Duplicate post. Already answered here
September 11, 2011 at 3:03 am
I guess Jeff asked to decide whether a CrossTab or a DynamicCrossTab would be required.
Both concepts are described in the related links in my signature. Disclaimer: Jeff is the original...
September 11, 2011 at 2:48 am
How did you measure those numbers? It's unlikely a single table can be larger than the whole DB (unless there are different filegroups and not all have been taken into...
September 10, 2011 at 1:41 pm
Kevin Dahl (9/10/2011)
All indications so far are that our new infrastructure/schema/app layers are all performing worse than what they're meant to replace, and the big glaring elephant in the room,...
September 10, 2011 at 1:34 pm
Is this all possible within one sql statement and is it the most efficient way of doing this?
It depends what you're looking for: if it's only a SELECT statement, then...
September 10, 2011 at 2:28 am
can virtualizing the DB enable us to cut our CPU power by a factor of 6?
No and yes.
Virtualization cannot cut the absolute CPU power an application requires. But it can...
September 10, 2011 at 2:22 am
Viewing 15 posts - 976 through 990 (of 5,504 total)