I guess I'll split up the tables...

Can I infer from your answer that we wouldn't have this problem with Standard Edition? I have a feeling the additional development time get...

There are three indexes:

Clustered index on composite primary key (datetime2 and int)

Spatial index on first geography column

Spatial index on second geography column

Here are the sizes:

Clustered: 1638464 KB

Spatial1: ...

Update:

I've been able to duplicate the error. I created a new database from scratch and ran DBCC CHECKDB with no problems. I exported all the data from the original...

The server has 4GB.

For memory allocation, I looked in Server Properties > Memory. The Maximum server memory is 2147483646 MB.

FYI, this is SQL Server 2008 Express. So I...

Yes, apparently there are issues.

Some quick background. The original database is running on a demo / test server that is receiving data from a live feed.

Yesterday I was running DBCC...

This is way beyond my level of expertise...that said, unless there are any other suggestions I'll start with PerfMon using the recommendations from Brent Ozar's blog post: http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

Wish I'd known this months ago...Thanks!

As soon as I posted this, it occurred to me that there might be a way to do it. And there is! The listing isn't how I imagined it (you...

Last year I wrote a white paper for a project about row-level security. The info in the document is proprietary to one of our products but I do have all...

This can be done by granting execute permissions on the undocumented system stored procedure xp_readerrorlog.

Two caveats are: 1) undocumented stored procedures can change in future editions of SQL Server...

Thanks for the input. I didn't think about the security permissions either...

At the risk of getting blasted by an expert, here is my take:

The CTEs are used to find all the duplicate instances of data for columns TagIndex and Val....

Hi,

Not sure if this will help, but you should be able to achieve the same thing this way...

CREATE PROCEDURE usp_TestRestore AS

BEGIN

RESTORE FILELISTONLY FROM DISK = 'c:\code3Billing\ClientSQLData\Master\code3billing.bak'

END

GO

IF...

Something just occurred to me. If the outside application

is managing a BEGIN and COMMIT TRAN in the c# code, then doesn't that mean that any errors logged to the table

would...

That's a great article and I think it's something we'll have to implement. Thanks very much...