You can only have one default instance on a machine. An installation will create 0 or 1 instances, depending on what is selected. If an instance is installed, it can...

Thanks all.

Next step, chat with management so that there are no unpleasant surprises, then start making some changes. And some plans. And some <redacted> :hehe:

Don't.

Hints are for rare cases. They're for when you absolutely are sure you know better than the query optimiser on the best plan for a query and you know that...

Kinda, but not really. You can force a plan, the USE PLAN hint, but it doesn't mean that it'll use a specific plan in cache, rather that the optimiser will...

That's not a SQL Server query. Looks more like MySQL (the limit). You'll probably get better answers on a MySQL forum as this one is dedicated to Microsoft SQL Server.

Try...

Which cache? There are several of them

All caches can be explicitly cleared, other than that what kind of manipulation are you interested in?

The second query will only return rows where the doTableDate is exactly 03/01/2014 00:00:00, because the upper and lower limits of the BETWEEN are the same

What do you want it...

Definitely Enya. When the situation is very stressful, the last thing I want is music that's going...

Huh?

Could you perhaps be a little more specific as to what's wrong?

Does a consistency check return any errors? If so, what errors?

DBCC CheckDB ('<database name>') with no_infomsgs, all_errormsgs

Of course you can take backups of the principal.

There are a number there that are wrong. They're great for figuring out who, in an interview, went memorising questions from the...

Perfectly legal afaik.

afw (5/14/2015)

---

Could you tell me what...

Alan.B (5/14/2015)

---

Add a the following WHERE clause to your Query after that and you get a non-clustered index seek (the plan has a slightly lower subtree cost on the SELECT...