SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

select statement

/* something here please to revert to 'normal' */

more sql statements

Jeremy

One other question. if I turn on SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED within a stored procedure and I want to turn it off, what is the best?

Jeremy

Vladan,

I always find it difficult to understand everything that is going on with other people's systems when all you get is a few lines in a post. I suspect...

Andy:

I don't serialise the jobs because it would take too long to create the data. The data is split by year and the client app can request data for...

The client app allows users to make selections from 5 different list boxes. I store these values in the table so that when I ask the question of whether...

brokenrulz,

I have checked the query plan and the index is being used in the query.

I accept that having the status column in the index and changing the value the column...

Andy:

Yes I have several jobs that run concurrently but I have tried to space them out by using WAITFOR DELAY (nn.nn) so that each second only one job should determine...

Yes there is an index on the status field. There are approx 290,000 rows in the table and I need a quick way of finding if there is a...

It very much depends on the type of query.

If you have a simpel query such as:

select column1

from table

where ...

then the performance will not suffer much if the table grows very...

If you are using BCP there is a parameter -F which determines the first row to import. There is a similar option for Bulk Insert in an SQL Statment.

Jeremy

...

I remeber having similar problems in the past and now whenever I create dynamic SQL I use char(39) to put in a single quote into the string.

Jeremy

One thing you might consider is a case statement:

update BOOKLOOKUP

set Reviews =

case

when @field = 'Reviews# then @uvalue

else [Reviews] /* set to...

OK - another stab.

declare @continue char(1)

set @continue = 'Y'

set @rowcount 1

while @continue = 'Y' begin

insert SoldItems

select SoldItem, max(SoldItemId) + 1

from SoldItemsImport, SoldItems

where not exists (select SoldItem from SoldItemsImport where SoldItemsImport.SoldItem...

No - you will have to specify specific columns for IsNull.

Jeremy

Try this:

insert SoldItems

select SoldItem

from SoldItemsImport

where not exists (select SoldItem from SoldItemsImport where SoldItemsImport.SoldItem = SoldItems.SoldItem)

Jeremy