Skip to main content

Difference between Lock and Nolock


Lock

Lock in  MSSQL is used to prevent concurrent access of tables. It is widely used to application that have large number of users who access database. In case if a user tries to alter a table the table will be in lock state so that no other user can try to alter the table until the lock release. 


In this case User 1 is trying to alter the table in database. User 2 has to wait until the lock is released by user 1. After that User 2 will put lock and execute the query. In case if user fails to use lock it will results in error

Note: Lock is used in DML statement.

Nolock

 Nolock is used so that two or more user can access the table simultaneously.It widely used in DDL statement.

 

 This is many number of user can select (View) data from table. select statement is similar to read. Where as DML is similar to write. By using nolock the data retrieval speed is increased for the user. There is no need wait until other user data selection ends.
Labels:

Popular posts from this blog

CONVERTING TORRENT FILE TO ZIP FILE

HOW TO CONVERT TORRENT FILE TO ZIP FILE 1>>click the link below  http://www.zbigz.com   2>>upload your .torrent file  3>>wait until conversion, after conversion your  file can be downloadable in .zip format.
Read more

Responsive PanelGrid in JSF Primeface

Here, we are going to learn about responsive PanelGrid in JSF Primeface component. As we know primefaces providing lots of good stuffs for JSF. In Primeface, there is a component name Panel Grid which we are going to use for our convenience. In most of the cases, PanelGrid used for making our content in a proper way. If users opens our website which we have made in jsf using panelGrid component that not in responsive manner, that could be really ugly as for as user concern, So here we are going to break it just by using Layout attribute in the panel Grid component. for exaple, < h3 >Responsive</ h3 > < p:panelGrid columns = "3" layout = "grid" >                 < h:outputText value = "Content" />      < h:outputText value = "Content" />      < h:outputText value = "Content" />      < h:outputText value = "C...
Read more

List Of Some Good Proxy Sites

List Of Some Good Proxy Sites               Below is the list of some good proxy site  which you can use to surf  anonymously on the internet . Even you can use this proxy sites  to open block website  in school or offices. For example you can use facebook if it is block at your school or office. List Of Top Proxy Sites http://aniscartujo.com/webproxy http://www.badboysproxy.com http://www.surfscreened.com http://www.hagiomusic.info http://www.greenpips.info http://urlbrowse.com http://www.hideipaddress.net http://www.sneakfilter.com http://www.browsestealth.com http://www.sneak1.info http://proxiesrus.com http://www.surfindark.com http://www.navydog.com http://falsario.com http://www.proxypit.com http://www.proxypan.com http://myspacewebproxy.org/ http://www.allfreehere.info http://www.takefreely.info http://autobypass.com http://www.proxcity.info http://www.proxyzip.org http://www.cheekyproxy.com http://w...
Read more