Have you checked to see if the named instance is listening on TCP/IP ? By default, I dont think SQL Express is "connectable" over the network if thats what you...

Haven't tried FILESTREAM with CSV's, although we do have CSV's implemented in our A/A cluster. I did have one issue at one time when there were some changes made to...

Try setting compatibility level to 110 and see if that helps.

Not sure if you're seeing any memory pressure. Here is my experience which I posted just a few days ago:

.

I also find that overall performance of SQL 2014...

Hey Jacob ! Thanks for the reply. My tests are very specific(but very involved as well). There are a few thousand use cases that I run through with a powershell...

A more basic question : Do you have any baseline runs of the same process(CHECKDB) on SQL 2008 ? In general, it would not be a good idea(I think) to...

Check your SPN's. You may have lost an entry or two in AD. Here is more info : http://support.microsoft.com/kb/811889

Set the database recovery model to simple. It should at least reduce the logging.

Update : I did burn a ticket with MS support for this. As usual, something as abstrtact as this got escalated, and it turns out that the escalation engineer also...

Same problem - no solution. I have servers where they do return data, and some on which they seem to be empty. I wish I could get a reply without...

No one ? :w00t: Not even Sean ? Gila ? GSquared ?

I'm not as much of an expert as some of the other contributors on this forum are, w.r.t. interpreting execution plans, but I would say that your culprit is...

and how does this get classified as a SQL Server administration question ...? :w00t:

You do not have a primary key on the dbo.ED table. A foreign key can only be created to reference a primary/unique key in another table. As for datatype, varchar...

If the purge was accompanied by a clustered index rebuild OR if the choice of keys in the clustered index is right, the table should resize after the purge. And...