Are you running the select * statement from the same process that locks the records?  If so, the select * statement should return all the records from the table, because...

Here is one way that does it:

declare @t table (name varchar(50))
insert into @t (name) values 
('ARANESP 100MCG PFS SOLD BY THE'),
('ARANESP 200MCG PFS SOLD BY THE'),
('ARANESP 40MCG...

select iif(len(first_name) > 10, concat(SUBSTRING(first_name, 1, 10),'...'),SUBSTRING(first_name, 1, 10)) as first_name from @t1

Adi

I think that this update should do it:

update #test
set AmountAll = Amount * NumDays
where NumDays > 0
go

Adi

The ring buffer stores the information only in memory and does not store it also in a file.  There are some problems with ring buffer.  The first problem is that...

I don't think that creating a covering index will help you.  Since you are using the clustered primary key as your search argument, you are not doing any lookup.  Are...

Many of comments to reply, so I'll just write my comments for all of them, on this message.

It is nice and amusing to read slogan such as “Those who know...

You mean like virtually everyone on StackOverflow where such...

They're also a good way to...

SELECT DATEADD(DAY, -DATEDIFF(DAY, 0, [Order Date]) % 7, [Order Date]) AS [Week of],
  COUNT(*) AS Count
FROM dbo.your_table_name
GROUP BY DATEADD(DAY, -DATEDIFF(DAY, 0, [Order Date]) %...

I know that it is a shot in the dark, but did you check if the table was drop and recreated between the time that you dropped it and created...

As other wrote without the code there is no way to help you.

Also I agree with Jcelko212 that the keys should be taken from the table and not be computed...

• This reply was modified 3 years, 4 months ago by  Adi Cohn.

I don't think that the server is creating new column to an existing table as sparse columns.     Creating column as sparse columns has a big effect on the storage...

One more option is to use Audit.  I have to admit that I didn't use it for a very long time (few years).  The advantage that it has is that...

Can you write a small script that creates your table, insert some data and show us the results that you expect to get?  It would help us make sure that...