I was looking for information like this. We have recently implemented SCOM and as a DBA I need to learn part of it. Yesterday I upgraded one of my moitored...

Thanks for the response.

I already have auto create and auto update statistics off on the destination database. my source is sql 2000 and my destination is sql 2005. Do you...

Hi,

I am having the same problem. I have transactional replication from 2000 to 2005. Were you able to resolve your problem? Can you post your experience here.

Thanks a lot.

Did this command worked for anybody? I am getting the same exact error.

Thanks

Hi

I got this info from BOL

Although SQL Server database pages are 8 KB, disks perform I/O operations using a 512-byte sector. Therefore, 16 sectors are written per database page....

Its 15 months that I am working with the current company. I was promised last year by my manager that I will get the SQL PASS training. In December 2006,...

Bowled23,

I have experienced the same thing couple of time. Because I am the only DBA in my company and nobody else has access to these jobs. So I was also...

Please create database roles such as group1 and group2. Add appropriate database users in the respective role and then assign permissions to the roles.

Lumigent's log explorer also has most of the same functionality. Please correct me if I am wrong?

Thanks

Ameena

select objectid, indexid, sum(*) as scans

from IndexCapture

group by objectid, indexid

In the above query change sum(*) to count(*).

This is a very nice article. But I agree with the other post that...