Grant Fritchey (7/22/2008)

---

Thanks. Great description of automatic statistic maintenance, although it's for SQL Server 2000. Here's the BOL entry for 2005. There are a few differences, but nothing major.

I guess...

Jonathan Kehayias (8/1/2008)

---

For this particular question, here is the example code.

DECLARE @InstanceName varchar(100),

@InstanceLocation varchar(100),

@InstancePath varchar(100)

SELECT @InstanceName = convert(varchar, ServerProperty('InstanceName'))

EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',

@key='Software\Microsoft\Microsoft SQL Server\Instance Names\SQL',

@value_name=@InstanceName,

...

I think enabling Snapshot Isolation Read Committed would solve your problem.

But there are other implications to enabling this isolation level, so you will have to test carefully before implementing in...

Jonathan Kehayias (7/23/2008)

---

There are a couple of ways to do this. Just using standard TSQL, you can use XP_REGREAD to read the registry key for the instance root key:

HKLM\Software\Microsoft\Microsoft...

Don't forget about your tempdb data files.

Those need to be separated from the rest: separate disk array, device etc. (I'm not clear on this terminology).

vasaharshit (8/1/2008)

---

Thanks a lot!!!

Just one confirmation needed i will have to create this table before right UpdateDBStatsStatus?

and i will have to run it once in a day,right?

so...

PaulB (8/1/2008)

---

You have to populate a table using the output of that query, just run the process once a day and you will end up with one row per object...

The datafiles piece, yes.

But don't rely on that link for SQL 2005, it is outdated. For example, implementing trace flag -T1118 is not applicable.

Check out these links instead:

Configure SQL Server...

where is the difficulty?

vasaharshit (8/1/2008)

---

Hi All,

I have near about 1300 tables i just want to check which tables are updated or have new rows added ....

...

Marios Philippopoulos (8/1/2008)

---

i6004835 (8/1/2008)

---

Are you running another transaction or query during the execution of the slow transaction? I mean is it the only query/transaction executed on the server without any...

i6004835 (8/1/2008)

---

Are you running another transaction or query during the execution of the slow transaction? I mean is it the only query/transaction executed on the server without any other query/transaction...

i6004835 (8/1/2008)

---

Are you running another transaction or query during the execution of the slow transaction? I mean is it the only query/transaction executed on the server without any other query/transaction...

Carl Federl (7/31/2008)

---

In sysprocesses I see lastwaittype: PAGELATCH_SH and waitresource: 13:1:6396860.

A bit before the query completes execution I see lastwaittype: PAGEIOLATCH_SH and waitresource: 2:1:274.

I know the first number is the...

OK, here is the latest info. For the longest time, the lastwaittype is PAGELATCH_SH and waitresource is 13:1:6275751.

I have been able to find the table and index this resource corresponds...