I would say like Gail, 1118 has an impact on all databases allocation:

On a SQL2005 SP3 instance started with -T1118:

[font="Courier New"]

create database uniformext

use uniformext

create table T1(a char(8000))

insert into T1 values...

Hi,

There was a bug fixed in SQL Server 2008 concerning rebuilding index using with drop existing and case mismatch. Is this the way you rebuild your indexes ?

cf the connect...

Hi,

Check that you are running a build higher or equal to 9.00.3166 on your 2005 SQL Server if you intend to switch -T1118 on. cf http://support.microsoft.com/kb/936185

Please post the results of:

^{DBCC CHECKDB([Test]) WITH ALL_ERRORMSGS, NO_INFOMSGS}

GO

Thanks,

Hi,

If you have read through this section, you know that page corruption happens in most cases because of hardware failures, or filter driver misbeheaviour. SQL Server asks for a page...

Once the trace is set, the deadlock graph will show up in the ERRORLOG file. ( -> when it happens)

The second error looks to be more related to Sharepoint. There...

The only database problem you may have is a deadlock situation at some point. You can turn on trace 1222 on the instance to check what objects and sessions are...

falisalaam (8/19/2010)

---

In looking further, I can see that the issue is that there is database corruption in one or multiple databases. (...)

I have run both DBCC CHECKDB and DBCC CHECKCATALOG...

In Rob44's case, RID = (1:1368905:38) represents the location of the damaged row. You must understand it is very specific to his case, it is not some sort of magic...

Hi Ravi,

Sounds familiar: http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-bug-that-people-are-hitting-Msg-8967-Level-16-State-216.aspx

From Paul's article, state 216 means that checkdb runs through a page that has a higher LSN value than the LSN of the inital snapshot. Try to...

Hi,

Thanks for your answers. I know PAE allows windows to go beyond the 4Gb boundary. I was rather interested because in the referenced KB article, it is said :

"The Complete...

Hi Stanley, thanks to share.

Can you tell us whether your server is 32 or 64 bits ?

David B.

Hi dma33 & John

Linchi Shea has posted an analysis on the impact of page checksums and default trace with various IO workloads. You can review it here. I didn't want...

Forget it, I didn't see the timestamp in the main post :-D. I guess the pages are long gone now...

David B.

By external I mean a certificate issued by a trusted third party company like Verisign/Thawte...

The certificates you can create through T-SQL are not used to encrypt the communication channels between...