Pretty interesting. So thats how trigger always work ? Can't we force trigger to not use the version based operation ?

we have pinpoint the process which is creating tempdb space issue. While we are purging the tables, the records are going to audit tables. For big tables it is creating...

If a table contains 5-10 statistics and some performance issue arises because of statistics, then is there a way to nail down to the level where we can get the...

If you check DBCC SHOW_STATISTICS for any clustered index or nun clustered index of a table, you'll see data sampling for only first column of the index [If an index...

Thanks Gail, It means if we have READ_COMMITTED_SNAPSHOT set to ON and we use SET TRANSACTION ISOLATION LEVEL READ COMMITTED, then it will disable READ_COMMITTED_SNAPSHOT for that session and not...

We are using READ_COMMITTED_SNAPSHOT isolation on database level. Can we still force some stored procedure within the same database to not use row versioning ?

Great knowledge feast on statistics these days. I was checking that statistics on any index maintains informaiton based on the first column of the index only. Now if our query...

Doing some more R&D on Statistics... Really exciting. DBCC SHOW_STATISTICS is wonderful. Cross verofying it with execuiton plan as well. However can anyone tell where to get colmodctrs value ?

Ninja, Updating the stats with 20% may faten the process. However In our scenario, it may not resolve the issue entirely. There are two points:

1. The entire dataset on which...

Ninja, I had already gone through the link. It's pretty useful. I agree with your point in having Update Stats job after the loading of tables, that is, in between...

Hello Ninja, We do rebuild for all the indexes in the tables [which I think updates the stats on those indexes as well].

Thereafter our batch starts which populates further...

We already have a job created before our batch starts to rebuild the indexes. However the main thing is that one of the procedure within the batch populates data in...

We are facing tempdb space issue again. After observing through perfmon graphs, I found that version cleanup rate is zero while generation rate is over 1000 Kb/s at times. How...

Thanks a lot again Gail. I got it now. There was a varchar(max) field on the table. 🙂

While checking the indexes on few of the tables I found that one clustered index shows two entries. One for IN_ROW_DATA and another for LOB_DATA. Though there are only two...