Viewing 15 posts - 5,536 through 5,550 (of 18,926 total)
Put only 1 pivot once the union is done.
June 4, 2011 at 12:33 pm
GilaMonster (6/4/2011)
With normal row versions the version can't be removed until all queries that could possibly need it have finished. May be similar with triggers, I'm not sure.
I don't see...
June 4, 2011 at 5:44 am
Well here's what I do that doesn't require a lot of space. I take daily full and then 15 minute trans.
The full is 20 GB but the logs are...
June 4, 2011 at 5:36 am
Does the first query actually return anything if your run it on it's own?
June 4, 2011 at 4:29 am
luismarinaray (6/3/2011)
Thanks for your help
SELECT * FROM (
SELECT * FROM Query1
UNION ALL
SELECT * FROM Query2
) dtUnionAll
ORDER BY ...
Is possible to pivot this...
June 3, 2011 at 2:40 pm
Well for 1 ROW_Number is not available in sql 2000 so I'll assume 2005.
What happens is that the query is actually treated as such :
SELECT * FROM (
SELECT *...
June 3, 2011 at 2:02 pm
Hoping it's not too late...
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
June 3, 2011 at 1:03 pm
GSquared (6/3/2011)
digdave7 (6/3/2011)
June 3, 2011 at 12:48 pm
June 3, 2011 at 11:19 am
Lowell (6/3/2011)
June 3, 2011 at 11:04 am
WayneS (6/3/2011)
Ninja's_RGR'us (6/3/2011)
WayneS (6/3/2011)
Mr. Ninja... I know you're lurking... do you see any other things to do, or that you would do differently?
Nothing major... at this point I'd also be...
June 3, 2011 at 10:54 am
WayneS (6/3/2011)
Mr. Ninja... I know you're lurking... do you see any other things to do, or that you would do differently?
Nothing major... at this point I'd also be whacking the...
June 3, 2011 at 10:35 am
It's weird. If I use SSMS 2008 R2 for the exact smae query it saves both plans. The weird part is that use SSMS 2005 it opens the...
June 3, 2011 at 10:18 am
WayneS (6/3/2011)
Right click the graphical plan, select "Save Execution Plan As..."
Doesn't work. It always and only saves the plan for the query in which I did the right-click.
Same thing...
June 3, 2011 at 9:59 am
WayneS (6/3/2011)
tfeuz (6/3/2011)
I dropped the redundant index
Added the new index to the rb_invoicestoprocess table (invoicekey,ruleid)
Made the change to the SP as you suggested....
It actually went from 23 seconds up to...
June 3, 2011 at 8:28 am
Viewing 15 posts - 5,536 through 5,550 (of 18,926 total)