Blocking 101

Pretty new to SQL Server and support multiple applications on SQL Server.
Just encountered a situation where "blocking" was occurring.
Can someone provide me more information or a link explaining Blocking and
how I can use SQL Server Enterprise Manager to determine who and what is
causing the blocking.
Any help is appreciated and I Thank You in advance for your help.
wnfisbaINF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
http://support.microsoft.com/defaul...kb;EN-US;224453
Typically, it's caused by long running transactions that hold row, page or
table locks.
"wnfisba" <wnfisba@.discussions.microsoft.com> wrote in message
news:2DC94438-B2D4-4BEE-A781-AC16DE69A7B7@.microsoft.com...
> Pretty new to SQL Server and support multiple applications on SQL Server.
> Just encountered a situation where "blocking" was occurring.
> Can someone provide me more information or a link explaining Blocking and
> how I can use SQL Server Enterprise Manager to determine who and what is
> causing the blocking.
> Any help is appreciated and I Thank You in advance for your help.
> wnfisba

BLock records using UPDLOCK

Hi all,
here my question :
I have 2 applications.

connection 1.
one does select max(grp) from orv and one does select max(grp) from orh. orh is the historical file from orv. We did this to know which is the greather grp between these 2 files.
After having did this, we add 1 at grp field.
we insert into orv the record max(grp) + 1

connection 2.
an other application could insert at the same time record in this table orv with same parameters.

my problem is the following. I need to block record in orv table either on the select ( connection 1) or Insert ( connection 2) to avoid having select max(grp) + 1 on orv at connection 1 and Insert a record into orv at connection 2.
I believe I need to use HOLDLOCK, UPDLOCK.
but I have not the habitude to use them.

Can I do this ?
connection 1
select max(grp) from orv WITH HOLDLOCK
connection 2
what should I use to avoid lock when I need to insert into orv. ?

thanks for your quick answerCan you explain what you are trying to do from a business or "real world" perspective? It sounds to me like you've dropped into the technology so far that you've lost sight of the original goal, and are making this a lot harder than it needs to be!

-PatP

Blinking in HScrollBar / VScrollBar

I am using VB6, my Applications has several HScrollBar and VScrollBar. Both
work perfectly, but; when I use any of them and "leave" the control, Scroll
Bar starts blinking. It is extrange. Can you explain that? Is there a way to
correct it? Please, help me.
Beforehand, thank you very much
Luis Garcia
IT Consultant
On Wed, 30 May 2007 16:06:04 -0700, LUIS wrote:

>I am using VB6, my Applications has several HScrollBar and VScrollBar. Both
>work perfectly, but; when I use any of them and "leave" the control, Scroll
>Bar starts blinking. It is extrange. Can you explain that? Is there a way to
>correct it? Please, help me.
>Beforehand, thank you very much
Hi Luis,
I think that you have a better chance to get an answer if you post to a
VB6 newsgroup. This newsgroup is for SQL Server :-)
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
|||Hi,
Just make the 'TabStop' property of the Scroll bar to 'False'. Done...
*** Sent via Developersdex http://www.codecomments.com ***