Please note: 2 year old thread.

URLT.

Start by informing the owners and users of the database that there's a good chance that data has been lost, if not the entire DB and that they should expect...

In case you didn't get the hint :-), you need to check the config of the anti-virus. There are plenty of articles (including a kb article from Microsoft) that details...

nm.

Sorry, what's the question?

ON in an index creation script refers to either a filegroup or a partition scheme

If the CheckDB repair is failing and you have no clean backup (Why oh why oh why????), then there's pretty much no option left. I hope the DB's not too...

Errr, kinda

Autocommit is the default. If implicit transactions is off, then every statement is it's own transaction that's automatically started and committed. Hence autocommit

If you explicitly BEGIN TRANSACTION, then you...

Not a direct cause, no. But if you have a mis-configured antivirus or some other process that,...

Please note, 3 year old thread. Reported for spam

And I'd suggest changing to use JOINs, not the old join syntax which has been out of favour for ~15 odd years or more. It looks like you have some...

jackimo (4/16/2015)

---

Another interesting bit is that if I use the left outer join with the query hint - OPTION (HASH JOIN), the query runs in about 1/3 the time. ...

And there's the reason.

Until a table hits at least one extent in size (8 pages, 64kB), a defrag...

Can you suggest to those who are responsible for it that storing dates in anything other than one of the date/datetime data types is... not ideal?

In the mean time, for...

No, it will not (well, maybe for a scan, but not for a seek).

Aside, why are you storing a date in a string column?

If you're trying to improve performance, these may be of interest

http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/