Viewing 15 posts - 5,746 through 5,760 (of 18,926 total)
Only a crappy workaround I can offer at this point (not studied 2k8 R2 dds). Output to file renamed as required, then use the mail services of the server...
May 25, 2011 at 6:37 pm
mpartridge (5/24/2011)
May 25, 2011 at 6:35 pm
Just query the plan cache for that proc every x minutes. Then poll the history table you just filled to find out when the plan reuse goes down to...
May 25, 2011 at 6:32 pm
I make them use the web interface. They can bookmark specific urls for all their favorite reports so it's 1 click after IE is open.
May 25, 2011 at 6:30 pm
Posted the bug about something really similar (different application but same source issue methinks)
It was closed as "by design" and if it is the same issue then any of the...
May 25, 2011 at 5:10 pm
Not really. The commands are really simple but going about might be a little more complicated.
Step 1 is that it's really best to copy than move. If for...
May 25, 2011 at 5:01 pm
coronaride (5/25/2011)
I'm the only one on this server. 😀
Hopefully an internals guru will see this and provide more hints of what you could do... right now that's beyond me.
May 25, 2011 at 4:00 pm
I'm not 100% sure about the internals on this. It "could" be a way but then again how do you figure that it's not some other query or ETL...
May 25, 2011 at 3:56 pm
Don't know, never seen that b4. Google turned up anything usefull?
May 25, 2011 at 3:55 pm
river1 (5/25/2011)
What did you mean with your last post?
did you mean that i am doind right if i create the...
May 25, 2011 at 3:38 pm
coronaride (5/25/2011)
Thanks Ninja's. Yep, tempdb has plenty of room, and I'm keeping an eye on the dest. table, waiting for *anything* to show up.
Just like I was thinking... you...
May 25, 2011 at 3:34 pm
**wrong quote bug***
I'm a hopeless romantic... but this was my last try unless he comes up with an intelligent question we haven't covered so far here or in your excellent...
May 25, 2011 at 3:32 pm
opc.three (5/25/2011)
Ninja's_RGR'us (5/25/2011)
The only real...
May 25, 2011 at 3:30 pm
When I can't port the datetime column in the report I simply do group and order by YEAR, then MONTH. But I guess that concatenating that into a...
May 25, 2011 at 3:28 pm
The only thing I have in mind is to watch tempdb to make sure it doesn't run out of room. Because this db is probably getting hammered at the...
May 25, 2011 at 3:27 pm
Viewing 15 posts - 5,746 through 5,760 (of 18,926 total)