You can check the ring buffers for one of three different error messages, Out of Memory messages, Low Physical memory or Low Virtual memory. You can also use the DBCC...

It's a giant topic. But, as with everything else SQL Server, start with the Books Online. Microsoft Developers Network (MSDN) also has an example of a plan. And finally you...

It's limited based on the available memory.

But why would you be nesting IF/ELSE statements to the limit of your memory capacity? It strikes me that you might be going down...

Creating a clustered index is generally considered to be part of the work of designing a database. Who designs a database? There's no absolute, hard and fast rule on that....

SQL Kiwi (9/25/2012)

---

I tried my best, but it is...

SQLSACT (9/25/2012)

---

Ok, so I'm definately going to change the option to false.

Question is, if I...

anthony.green (9/25/2012)

---

As with anything surrounding licensing, it is best to speak to MS directly, please do not take what people say on the matter as litteral that is the way...

Yep. By design. Here's some description of it. Yet another reason to avoid auto_close.

I'm not getting what this guy is after, so I'm clearly not helping. Could someone else check it out please?

Oh, and don't pile on the poor guy. I just mean...

I'm still very uncomfortable with the loop approach. It's just going to be slow. But, you need to make sure that each command is a single transaction, or, the entire...

To my knowledge, no, no additional licensing needed.

However, always, always, the best answers for licensing is not some dude on the internet. You should go to Microsoft for confirmation.

If you know for sure that you've removed data permanently from the database and the data is not going to just grow to refill the space you freed up, you...

In your situation, I think you're right to focus on getting your queries to run as efficiently as possible. You won't be able to dictate hardware, so your maximum efficiency...

Yeah, I wish I wasn't already traveling so much...

If you're parachuting into a situation where there is no monitoring in place, then, as was already mentioned, use the Dynamic Management Objects (DMO) to query the cache in order...