Viewing 10 posts - 1 through 10 (of 10 total)
I don't think that you are not able to shrink the file because of the binary data. Just use DBCC shrink and also make sure that you are doing some...
February 6, 2002 at 10:21 am
There is approx 3 million records in one of the table.
quote:
When you are talking about data movement, how much data?K. Brian Kelley
February 6, 2002 at 10:18 am
Yes, I am aware that NoLock allows dirty reads. Dirty reads are not a huge problem on your website. We would like to allow our users much faster access. Our...
February 5, 2002 at 5:07 pm
Error Number is 601.
We are not using cursors.
quote:
Ok I was thinking maybe in an app. However are any of the Stored Procedures...
February 5, 2002 at 5:01 pm
Its not exactly the same thing tht you posted but these are some of them I looked at :
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q275427
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q268081
I guess they have not fixed the problem...
February 5, 2002 at 2:05 pm
Yes, we have few tables where user can add or update the records. If during the reads from those tables we don't put NoLocks the queries take very very long...
February 5, 2002 at 11:57 am
The stored procedures I am talking about are very big stored procedures using lot of custom tables.
Its not that I get this error everytime I use that stored procedure....
February 5, 2002 at 11:52 am
I don't think anything has changed. But what kind of changes are you referring to. I have many stored procedures that gets changed regularly.
Are you aware of any reason...
February 5, 2002 at 11:48 am
Viewing 10 posts - 1 through 10 (of 10 total)