Yes. For few entries this is the case.

GilaMonster (3/26/2012)

---

None of those 13 columns depend on...

Gail,

I have a real time scenario where this one table has 15 columns and out of which 12 are in non clustered unique index.

Now for some particular condition, to...

In my case this table gets populated daily with around 1000 records and also we daily purge around 800 records from this table. Will that be a good idea to...

Also want to know if having too many group of columns in the unique constraint can have any performance issues

In my case this table gets populated daily with around 1000 records and also we daily purge around 800 records from this table. Will that be a good idea to...

Not possible - there I am first selecting data from a big table to temporary table, then doing some updates and finally inserting it back to the main table. This...

Is there any change in the return value or behaviour of bcp in case of any error in SQL 2008 ? like Data conversion resulted in overflow or Unexpected EOF...

Thanks. Is there something same for memory utilization monitoring ? I tried googling and didn't found anything.

Thanks Gail, I got it from your point. Thanks to others as well for describing.

I agree but why does not it works like this ? I mean is there something more precise or some doc where I can get deep understanding on this ?

create table #t1

(id varchar(5))

insert into #t1 values('xyz'), ('kkl'), ('tln'), ('cxz'), ('dfa'), ('tprq')

select * from #t1

Declare @p1 varchar(50) = 'xyz,tln,tprq'

Declare @p2 varchar(50) = ''''+replace(@p1, ',', ''',''')+''''

select @p1

select @p2

select * from #t1...

Thanks for the detailed test and clarification. However I've changed only that thing [turning off the option] and monitoring it from past 2-3 days and there is absolutly no locking....

select a.spid, b.text from sys.sysprocesses a cross apply sys.dm_exec_sql_text(a.sql_handle) b

This is the query I'm using. This is giving me even those sessions which are closed in query analyzer.

If you have turned both of those off, the only lock that can be taken is a full table lock, so if SQL even wants one row in that table,...

Agreed - The only thing is that I can use sys.sysprocesses in joins with other tables to get useful information. Else I always has that sp_who[2] option.