http://www.datamanipulation.net/SQLQueryStress/

pkloukas (5/5/2011)

---

I am not the server administrator, I will ask the guys here about the service packs. I guess we are talking about the Microsoft SQL Server 2008 R2 service...

Same info, without jobs.

SELECT

...

toddasd (5/5/2011)

---

I agree with you wholeheartedly, Ninja. But this will work fine for small to moderate size tables. That's also something for the OP to figure out, when to use...

You might as well run the R2 upgrade advisor while you're at it... might save you some work on the next upgrade and future devs.

dateadd(hh, <find the setting>, max()).

I can't help you with the setting.

pkloukas (5/5/2011)

---

I am glad we are thinking in the same direction :-).

I also used textboxes on the subreport to check what parameters are passed on.

BIDS: correct parameters

IE: only the...

golden-1131024 (5/5/2011)

---

there should not be a blocking happen as i should be notified through my blocking alert notification..

my concern is...

will this MP affect any of my current DB engine operation?

if...

yes, it's called quality assurance. It's the part of the plan where you rerun all the parts of your app on a test server and see what breaks.

This is...

Right now I would be adding textboxes in the subreport to display the parameter values.

Something just doesn't add up and I'm not seeing it.

I'm sure you'll figure this...

Too late :hehe:.

Sorry, we're all telapatically telling you to run sp_who2 to find if you're connection is blocked... and...

I guess you tried killing EM and rebooting the machine?

I've had a similar issue in 2k5 where I couldn't delete the MP because the credentials of the login used in...

That's only 10% of the problem.

Run the same thing with 600 columns and 10 000 000 rows of data. :hehe:

Parameters are annoying in deployement (sometimes they don't erase correctly and that part of the update fails).

Go in IE, DELETE both reports. Redeploy.

That always solves my problems with parameters...