Perry

Thank you for the reply.   That was one of the Connect workarounds I tried but gave it another whack after confirming my paths match yours (they did).  Here is...

It is not a command I would typically user either since the properties dialog of the role would give you the membership. The lack of support for properties...

Know why they call it "the cloud"? The Marketing department didn't think "server room without a door" or "server room you don't own" would sell.

:w00t:;-);-)

My big concern is how much the Managing Partner will cry when he sees how much of his bonus goes to taxes. He is definitely making bonus this year.:-D

I've been certified and gone years without updating them. I have found them valuable in two ways. One it gives me focus to help learn a...

Interesting article. Curious about why you did the rebuild (particularly after the first failure)? I would have thought moving directly to a restore of master would you...

I was having the same struggle and situation. This blog entry helped get me past the security hump:

http://mystuffisallhere.com/blog/post/2010/01/26/SQL-Server-Reporting-Services-2005-and-2008-e28093-cancelling-a-long-running-report-causes-the-next-e2809cView-reporte2809d-to-hang-the-UI-until-the-original-finishes.aspx

Additionally, I couldn't get my Sql 2008 SSSR instance...

Thanks for challenging my assumptions. I haven't reviewed the basics and should have.

I'm the only Sql guy in my shop so kicking ideas out here and getting feedback...

272 VLF's. It is a vended app that has always had one or two problem querys that were good for a 2 or 3 blocks a day....

Feel free to mock and ridicule. I'm guessing this one might wind up on the never ending "Are the questions getting dumber" thread. 😀

I was looking at the output in...

Ran the queries today in test and got some interesting results. Running them unmodified, I can reproduce the original block. The block didn't resolve until the SELECT...

Sorry for not updating the thread sooner. New employee orientation, fun, fun, fun.

The spid 94 query takes almost 4.5 minutes to run on it by itself and...

Craig

I've updated on the post with the full sql statement for spid 94.

The detailed trace file has everything the spid 94 did from the full minute before the block...

BTW, first this I should learn about Teradata is how to spell it correctly.

😀

Grant makes an interesting point. I still remember the launch event for Sql 7 and the presenter saying that new features eliminated the need for the DBA role. ...