I need to ask...

Changing the column from varchar(245) to varchar(max) is an option?

The performance problem is at the .net development.

Tell you development team to take advantage of cache, lazy load, etc.

Most of the performance problems with nHybernate lies in loading entire sets...

Thanks GSquare that is worth to know!

Snapshot isolation was introduced in SQL 2005, most...

I remember when i learned abou NOLOCK. I used it for each table in each query.

It solved many problens and created some more...

But it was with SQL 7 a long...

Maxer,

If all you want is copy the columns to a notepad try this:

With the SSMS use the Object Explorer,

Select the desired database,

Open tables and select the target table,

expand the table,

drag...

Sean,

This is running at 1million rows/20 min.

Not too slow since actually I managed to apply this query only to recently updated/inserted data and for a few hundred rows it...

Something like this?!

create table tableA(id int, name char(3))

create table tableB(id int, number int)

create table tableC(name char(3))

create table tally(number int)

GO

insert into tableA values (1,'ABC'),(2,'DEF'),(3,'GHI')

insert into tableB values (1,3),(2,5),(3,7)

insert into tableC values...

Below is my batch,

If anynone can manage to wipe the cursors and change it to use only relational logic to booster performance I ill be grateful.

/* dbo.Tagger receives a string...

Like this?

create table tableA(id int, name char(3))

create table tableB(name char(3))

create table tally(id int)

GO

insert into tableA values (1,'ABC'),(2,'DEF'),(3,'GHI')

insert into tally values (1),(2),(3)

GO

select * from tableA

select * from tally

insert into tableB

select a.name

from...

The question is a litele vague.

It's like

table A

10,

20,

30

populates like

table B

10,

11,

12,

...

20,

21,

...

39

???

Sami,

You cannot order by a non-existent column (in the returned dataset) for this case.

You must put ChartID column in the select.

try this:

--create table relation (ChartID int, SourceCode varchar(100))

GO

--insert into relation...

thanks for the tip.

I tried it but there's no improvement in performance.

I Also tried FORWARD_ONLY STATIC OPTIMISTIC.

The problem is not the tables the cursor are reading, its the tables its...

Sean,

"Snapshot isolation transaction failed accessing database 'xxx' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation."

And I'm not allowed to use ALTER DATABASE...

Thanks for the reply Sean,

1. Yes, I agree most of cursors can be replaced by a nice, fast and elegant relational query but that's not the case indeed.

2. I need...

After some years of observation I found if 2 queries are similar the optimizer ill process both in a similar way.

It means its likely there's no difference in performance for...