Brilliant that worked, I was also able to perform an update using that hint.

I ran the CHECKDB again and this is the full output

Msg 8928, Level 16, State 1, Line...

Ok the output is now

Msg 8928, Level 16, State 1, Line 1

Object ID 181575685, index ID 1, partition ID 72057614513340416, alloc unit ID 72057614701428736 (type In-row data): Page (1:18504) could...

The clustering key is on the StudyID column, however its not unique and there is some pretty heavy fragmentation. %60.

As a side note I think I have fixed the...

Hi Gail

I would love to fix the data purity error so we can see if the recommended repair level is stated, but at the moment this is proving difficult.

I have...

The second is not going to work properly. The order by on the date column will make SQL look at that column as a date and, if there are invalid...

Hi Paul - I have run the command CheckDB with no_infomsgs against my database through a query window. To be sure I have done this again this morning, and...

Hi Gail 🙂

In response to your questions, the queries I am using are below

--This returns a count of 16, where has extra row come from?

select count(*) from dbo.AccrualSnapshotCCRN

where StudyID =...

No I understand that but I was taking this opportunity to learn how to trouble shoot and understand the layout of the XML thats all.

Oh wow I was just looking at some of your code on another post 🙂 it makes it much easier to read thanks.

I do have some niggly questions like...

Hi thanks for your reply. I think I am reading the XML incorrectly. I had thought that the code in the Input Buffer was the one executing during...

I am getting a lot of the following on all servers in the logs

Message

The mirroring connection to "TCP://XXXXXX:XXX" has timed out for database "XXXX" after 10 seconds without a response....

Well I will monitor and let you know. The scenario was that I just logged onto the server and saw the T-logs at 56GB for a database that was...

Ah great stuff thanks

Hi and thanks for the replies - This thread is primarily about calculating IOPS.

I have looked at the sys_dm_io_virtual_file_stats and can see the amount of reads and writes. I...

I am using the IP address\Instance name to connect already.

Ok the steps are as follows:

1. Launch SSMS on my lcoal machine

2. Select Database Engine to connect to using windows auth...