December 19, 2008 at 8:43 am
I have created a view with NOLOCK option in the table. when i am trying to create a index it says. "Cannot create index on view 'dev13d1.dbo.viewname' because the view contains a table hint. Consider removing the hint." When I am removed the NOLOCK condition it works fine But I need the index to be created with the Nolock on the view is there a option to create it?
December 19, 2008 at 8:52 am
Why do you need the nolock?? That data is persisted so the nolock shouldn't really matter, or does it?
December 19, 2008 at 8:56 am
As per ours DBA instruction's we were told to use NOLOCk on the query.
Is there any problem when we give NOLOCK in the View.
December 19, 2008 at 9:44 am
The answer is that you cannot do this. If you need to index the view, you must remove the hint.
I would go back and question the use of NOLOCK. This is a hint that is almost always mis-used. It should really be avoided.
Make sure that you, the other developers, and the DBA understand what it will result in. The NOLOCK query hint will not only read uncommitted data, but it will cause the possibility of missing committed data or even reading committed data multiple times. It is important to understand and properly handle these situations.
December 19, 2008 at 9:53 am
I completely agree with Michael. Worst part is you'll present inconsistent data to your users. You got to understand the dangerous part of it. Users tend to take help of NOLOCK hint to avoid delays due to possible locks.
December 23, 2008 at 6:11 am
I'd also suggest getting your DBA into the discussion here. They might have a good reason for using NOLOCK, or, more likely, they need a better understanding of what it is and what it does.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
December 30, 2008 at 2:38 am
In my first times I used to NOLOCK hint but it reads uncommited transactions and it is problem when you want to take stock amount or sales amount but in your table there is a lot of transactions you can use because you don t wait the transactions. But I prefer to use READPAST only read commited transactions
ESAT ERKEÇ
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply