#nolock

[mydatastuff]

While tuning a query we had a situation when we had to check if the query is locked during the execution of not. To test our theory out we had to put a nolock hint for every single table of the long query. However, it was no way possible to do so as the Stored Procedure was super huge and involved over 90 tables and 14 views in multiple SQL Statements. It was indeed a huge challenge for a developer team to modify that SP. If you ever face such situations, you should not stress out. There is a much simpler way to read uncommitted data.

[the-bikeboy-blog]

Parked #legal #nolock #beach #heat #marbella #spain🇪🇸 #thebikeboy (at Marbella, Spain) https://www.instagram.com/p/BySU3dEjoQr/?igshid=dzo2uqurqpql

[humanintel]

So this new @smithwessoncorp 442 Pro Series arrived today for an upcoming article. #proseries #moonclips #federalpremium #HST #smithandwesson #nolock

[cherylsjoys-blog]

NOT breaking & entering... More like opening & exiting. 🔓 #ChateauMarmontRooftop #NoLock #LAviews #ThatTimeWeBrunchedAcrossJesseMcCartney @tifftheabstract

[sevennet-blog]

How to: Is the NOLOCK (Sql Server hint) bad practice?

How to: Is the NOLOCK (Sql Server hint) bad practice?

Is the NOLOCK (Sql Server hint) bad practice?

I’m in the business of making website and applications that are not mission critical -> eg. banking software, space flight, intensive care monitoring application, etc. You get the idea.

So, with that massive disclaimer, is it bad using the NOLOCK hint in some Sql statement? A number of years ago, it was suggested by a fellow Sql Administrator that I…

View On WordPress

[goodanswerbiz]

Fixed SQL Server - when should you use "with (nolock)" #dev #it #asnwer

Fixed SQL Server – when should you use "with (nolock)" #dev #it #asnwer

SQL Server – when should you use "with (nolock)"

Can someone explain the implications of using with (nolock) on queries, when you should/shouldn’t use it?

For example, if you have a banking application with high transaction rates and a lot of data in certain tables, in what types of queries would nolock be okay? Are there cases when you should always use it/never use it?

Answer: SQL Server – when…

View On WordPress

[sevennet-blog]

How to: SQL Server - when should you use "with (nolock)"

How to: SQL Server – when should you use "with (nolock)"

SQL Server – when should you use "with (nolock)"

Can someone explain the implications of using with (nolock) on queries, when you should/shouldn’t use it?

For example, if you have a banking application with high transaction rates and a lot of data in certain tables, in what types of queries would nolock be okay? Are there cases when you should always use it/never use it?

Answer: SQL Server – when…

View On WordPress

[dbareactions]

When the customer and the business users are finally happy! (HT @BorisHristov)