Entries in suspect_pages but checkdb shows no error

I am using Microsoft SQL Server 2016 (SP2-GDR) (KB4505220) – 13.0.5101.9 (X64) Jun 15 2019 23:15:58 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 (Build 9600: )

Yesterday, I got two entries in “suspect_pages” for the same database. One of event type 1 and one of type 2

1 = An 823 error that causes a suspect page (such as a disk error) or an 824 error other than a bad checksum or a torn page (such as a bad page ID).

2 = Bad checksum.

database_id file_id page_id eventtype   error_count last_update_date 8           1       1482057 1           1           2019-11-14 14:40 8           1       1482057 2           1           2019-11-14 14:40 

I found the object related and they both point to the same table on the database.

DBCC TRACEON (3604); DBCC PAGE (8, 1, 14823057, 0); DBCC TRACEOFF (3604);

I had a valid backup of before the corruption and couldn’t afford a down time so I took a backup of the corrupted database, restored my backup on a new name. I dropped the corrupted table and then recreated it from the valid backup.

Today, I restored the corrupted database backup that I took yesterday on a test server and when I run a full checkdb, it detects no corruption.


How is it possible that the backup I took from a corrupted database (according to suspect_pages) doesn’t have any problems? Can those entries in suspect_pages be a false positive?

Database Compatibility Level is 130 (SQL 2016) Our SQL Server is running on Windows Server 2012.

Compiler Shows: Abort Called [migrated]

When does a C++ compiler give a this message : “terminate called after throwing an instance of ‘std::out_of_range'”? I was trying this problem a website. I wrote an algorithm but the code won’t compile.

enter image description here

The algorithm I wrote was this:

int stringSimilarity(string s) { int size=s.size(), sum=0;  for(int i=0; i<size; i++) {     string sub_str; int temp_sum=0;     //Creating a substring for comparison     for(int j=i, l=0; j<size, l<size-i; j++, l++)                {         sub_str.at(l)=s.at(j);     }      if(sub_str.at(0)==s.at(0))     {         temp_sum++;         int k=1;         while(sub_str.at(k)==s.at(k))         {             temp_sum++;             k++;         }     }     sum=sum+temp_sum; }  return sum;} 

Can someone please tell me where am I going wrong?

enter image description here

Field Modified shows date, but no time

In a view of a document library I have the field “Modified” and this is showing only dates but no time. I would like to display the time aswell.

From my understanding it is ill advised to alter this field OOTB, but rather to create a calculated field and format it the way I want.

I have checked the column properties for this Modified-field, and it is set to “Date and time”, which is why I find it curious that it only displays the date. In any case I have created another (calculated) field which I am attempting to format the way I want, but with not luck.

Under the Formula section of this new calculated field I am attempting to format “Modified” like this:

=TEXT([Modified],"dd.MM.yyyy hh:mm") 

I want the result to appear like this 14.10.2014 15:59. However, when trying to save the above formula I get the “Sorry, something went wrong” page and the mention that the syntax is probably wrong. I am unable to see any obvious errors with the syntax and have tried a multitude of approaches – like removing the “”, removing [] from modified and so forth.

I need the field to display time aswell and I am not sure if this is the best approach either. Anyone got any tips to how I could do this? Perhaps the calculated field approach isn’t the best either?

InfoPath: Drop down choice shows incorrect data

I’ve just published an InfoPath Form, however, when I open up the form in SharePoint my drop downs are displaying the incorrect choices. ie. for choice 1 SharePoint displaying the choices from drop down 3.

enter image description here

I’ve continued to publish and wonder how to sort my fields again so that the choices show up in the correct places. Any help would be greatly appreciated as this is urgent. Thank you

Ubuntu desktop shows odd layout

When I logged into Ubuntu my desktop looked like this image below and I can’t do anything with it. What can I do?


It’s inside VirtualBox, so the results of

ubuntu-drivers devices are:

== /sys/devices/pci0000:00/0000:00:04.0 == manual_install: True model    : VirtualBox Guest Service modalias : pci:v000080EEd0000CAFEsv00000000sd00000000bc08sc80i00 vendor   : InnoTek Systemberatung GmbH driver   : virtualbox-guest-dkms - distro non-free driver   : virtualbox-guest-dkms-hwe - distro non-free  == /sys/devices/pci0000:00/0000:00:02.0 == model    : VirtualBox Graphics Adapter modalias : pci:v000080EEd0000BEEFsv00000000sd00000000bc03sc00i00 vendor   : InnoTek Systemberatung GmbH driver   : virtualbox-guest-x11 - distro non-free