Viewing 15 posts - 3,841 through 3,855 (of 18,926 total)
srinath.vanama (8/3/2011)
Thanks for your replies,
For temporarily i created certain indices, so that queries are performing not bad. But, still am not satisfied with that moreover i'd like to improve...
August 3, 2011 at 5:59 am
Lavanyasri (8/3/2011)
HI ,How to find calling SP ???
Borrowed from the activity monitor...
SELECT
[Session ID] = s.session_id,
[User Process] = CONVERT(CHAR(1), s.is_user_process),
...
August 3, 2011 at 5:56 am
What's wrong with the pivot function I gave you?
What have you tried and where are you having problems?
August 3, 2011 at 5:55 am
TheSQLGuru (8/3/2011)
Ninja's_RGR'us (8/2/2011)
TheSQLGuru (8/2/2011)
August 3, 2011 at 5:51 am
I just had a very quick glance at the xml plan for both operations and I can't see any difference.
Will leave that here for now. Other things to test...
August 3, 2011 at 5:46 am
TheSQLGuru (8/3/2011)
August 3, 2011 at 5:42 am
Danny Ocean (8/3/2011)
good one. but confusing
Glad it made you think... enjoyed the brain work out?
August 3, 2011 at 5:41 am
Can you expand a little bit more on what you are trying to do? Maybe another technology would be way faster... SSIS, SSRS, DW, CUBE...s
August 3, 2011 at 5:35 am
HowardW (8/3/2011)
August 3, 2011 at 5:34 am
Jeff Moden (8/3/2011)
Ninja's_RGR'us (8/2/2011)
Jeff Moden (8/2/2011)[hr
I haven't actually done a performance test but I know enough about machine language at the cycle level to say that it will always take...
August 3, 2011 at 5:30 am
Jeff Moden (8/3/2011)
Flexdog (8/2/2011)
Hi Ninja,I wonder if the conversion is outside of the aggregate, would perf improves?
'avg'=sum(Value)/cast(COUNT(*) as float)
...ignoring sum() int overflow scenario.
On my machine, that runs about 3 times...
August 3, 2011 at 5:29 am
and if going BCP out route... I'd go straight to network share (again to share the load with other spindles).
August 2, 2011 at 8:19 pm
Maybe not. I'd consider doing a bcp out to dump the data into csv (usually 100K rows / sec easy). Dump that into 3-9 files and let your...
August 2, 2011 at 8:18 pm
Re merge :
My first thought was nice idea. But then I realized that you do "all that" extra work for an event that happens less than 0.01% of...
August 2, 2011 at 8:10 pm
--Windows 2008 (64-bit)
--SQL Server 2008 (64-bit)
What editions? AND SP for that matter.
August 2, 2011 at 8:03 pm
Viewing 15 posts - 3,841 through 3,855 (of 18,926 total)