Viewing 15 posts - 15,586 through 15,600 (of 22,211 total)
Jeff Moden (3/31/2010)
CirquedeSQLeil (3/30/2010)
Lynn Pettis (3/30/2010)
March 31, 2010 at 12:55 pm
That's the best way I know to handle it within the database. Just remember, if the error is of severity high enough to cause a disconnect, the CATCH can't catch...
March 31, 2010 at 12:51 pm
Just taking a guess, there's probably something in the WHERE clause that's preventing you from getting the updates. But, as everyone else has said, without specifics, I'm just guessing.
However, it...
March 31, 2010 at 7:26 am
Part way there. That's the structure, but what do the queries look like? And what do the execution plans look like? Can you run this query against the table and...
March 31, 2010 at 4:44 am
david meagor (3/30/2010)
If you pm me with your address I'll post you a...
March 31, 2010 at 12:21 am
Cause you're holding open a transaction on the client. As long as that's working that way, you'll be waiting.
BTW, you can get lots more information out of profiler besides RPC...
March 30, 2010 at 1:07 pm
CirquedeSQLeil (3/30/2010)
I just realized one more complication with the review board. If the MVP were paid by Microsoft to be on this review board, then that person could no...
March 30, 2010 at 10:36 am
Code and structure are your primary points of pain when it comes to performance. Your structure needs to be laid out such that the code is facilitated with a good...
March 30, 2010 at 10:32 am
david meagor (3/30/2010)
I was looking at covering indexes yesterday, I have to admit...
March 30, 2010 at 7:37 am
The Dixie Flatline (3/30/2010)
Barry and Grant: I'd love to hear (privately) the comments that might get you in trouble. My imagination is failing me.
Oh wait,...
March 30, 2010 at 7:10 am
The Dixie Flatline (3/30/2010)
Barry and Grant: I'd love to hear (privately) the comments that might get you in trouble. My imagination is failing me.
At this...
March 30, 2010 at 7:09 am
david meagor (3/30/2010)
March 30, 2010 at 6:57 am
Jack Corbett (3/30/2010)
Lynn Pettis (3/29/2010)
Here is what I think, before presenting anything to the PASS board, we really need to flesh things out more and put it in a more...
March 30, 2010 at 6:19 am
Jack Corbett (3/29/2010)
March 30, 2010 at 6:08 am
CirquedeSQLeil (3/29/2010)
Tough call. I was thinking volunteers because it could be more important to them in that fashion. However, their time is extremely important. Thus maybe they...
March 30, 2010 at 6:04 am
Viewing 15 posts - 15,586 through 15,600 (of 22,211 total)