To my knowledge, all that Keep Alive does is check if the other machine is still turned on (effectively). I could be wrong about that, but I've never found...

Steve Jones - SSC Editor (6/9/2011)

---

Brandie Tarvin (6/9/2011)

---

Hey, Steve (and other Prius owners), I just heard about this and wanted to pass it along:

Toyota says a problem with electric power...

The reason I asked about it being a heap in the first place is because that exact behavior is one of the reasons Microsoft recommends against using heaps in SQL...

clare.xia (6/9/2011)

---

"Now back to the question. The nolock is not 100% guaranteed, if there are inserts updates affecting that exact row, or other memory resource issues, and sometimes a clustered...

To my knowledge, SQL Server doesn't hold onto connections or dispose of them on its own. The application, or its data access layer, does that.

Here are the articles I wrote on the subject.

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

Make sure to read the discussions as well, since there's a lot of good data in those.

Is the table a heap?

Chad Crawford (6/9/2011)

---

So I just started a consulting company and I have a question for you. What should my title be? If I'm the CEO, the company...

Nah. It's measured on a ratio of knowledge:posts, which actually means you post too little.

Because of what it is and what it does.

Do you have a more specific question? There's a lot to the subject of compatibility levels, what they do, what they...

Revenant (6/8/2011)

---

". . . That's the federal guideline (US)."

On a secopnd thought, it does sound like something that came from the DC. I am afraid the next step will...

Per your first post, the value would be "blank", per the code you just posted, it will be "0", in the cases where you want it to be NULL instead....

Backwards compatibility has limitations, especially on new data types.

What would you do if you had to convert CLR data type columns to SQL 2000? Varbinary maybe? Still wouldn't...

bopeavy (6/8/2011)

---

GilaMonster

This is specific and unique to tempDB and likely has to do with what uses tempDB and how it's used.

To determine that a TempDB data file can be...

Take a look at RedGate's SQL Doc tool. I've used that for this kind of thing, and it works quite well.

You can add extended properties to database objects pretty...