I'm not sure. You may need to open a case with Microsoft. I'd say it sounds like you've set them up on the same ports, but you said you checked...

There isn't a single definition for what exactly is meant by "data dictionary."

Do you mean the table definitions, indexes, constraints, all as defined by T-SQL? Or are we talking about...

IgorMi (12/11/2013)

---

bugg (12/11/2013)

---

I have considered this, but it will mean downtime to Enable READ_COMMITTED_SNAPSHOT ON, which unfortunately I cannot do anytime...

Not really. If a user can create a database, they can access that database.

On the existing instance, you can set the user as data_reader only which will prevent them...

It's largely because heap storage goes where ever. It's one of the fundamental issues with heaps and why it's worth pointing out that fundamental storage and access in SQL Server...

Which, the cost threshold change?

Obviously you're getting two different plans with two different execution times. I'd say the principal difference is in the hash keys residual that adds the CustomerSets data to the combined...

Absolutely!

yayomayn (12/11/2013)

---

Grant Fritchey (12/11/2013)

---

If you understand that NUMERIC is a precision and then a scale, then you'd know that you need NUMERIC(10,5). Read up on it here. I'd also suggest,...

If you understand that NUMERIC is a precision and then a scale, then you'd know that you need NUMERIC(10,5). Read up on it here. I'd also suggest, instead of NUMERIC,...

It's probably your code, or your statistics, or the lack of an index. Those are much more likely than fundamental memory issues, but they can all lead to memory issues....

Without seeing the execution plan I couldn't say for sure, but I'll bet the plan for the statement without the CASE is more accurate to your indexes and statistics while...

What does the error log of the system being shut down say? Are there any entries in the Windows logs suggesting possible problems?

Unless you've set up extended events (or a server-side trace) to capture that type of information, there's no way to get it just by querying SQL Server. It's not stored...

Be careful with statements like that. Parameter sniffing is an automatic process...