I was looking for some response here but looks like there are no specific reasons for this behaviour.

Hi

This query is in a proc which is called by application. So SSMS settings doesn't count here.

Only 1 top record is returned, and there is no order by.

vinu512 (4/25/2012)

---

Have you...

Hi

There is where clause and there are nonsargable arguments as well. But there are indexes to support the where clause and select clause. I'll see if i can get the...

Yes, and it will only work if plan for your query still lies there....

If it is flushed out, you won't getanything and then there is no way to get the...

How does it matter how it was written? I think the only probability of getting it is if it still lies in your cache.

manoj_lanser (4/25/2012)

---

I don't want that insert generate...

Yes you can do that. Right click on database, then go to 'tasks' and then 'generate script'

There at one of the screen you can specify, generate insert script. it will...

Really nicely summarized points. Thanks Gail. There were new things here for me.

GilaMonster (4/24/2012)

---

They log less than temp tables (though not a huge amount less)

They aren't affected by an explicit...

Here are the questions:

They can be the target of an OUTPUT clause of an INSERT, UPDATE, or DELETE.

Can't we use temp table there?

They can be used to capture audit data...

Sorry my questions went in quote. I thought they will be printed separately.

Lynn Pettis (4/24/2012)

---

Table variables have their uses.

They can be the target of an OUTPUT clause of an INSERT, UPDATE, or DELETE.

Can't we use temp table there?

They can be used to...

Hi Gail

Then it leads me to the question "why on earth we need table variable then?"

Temp table also stays in memory if data is less. Temp table even has stats...

I was just going thru some posts and I believe the answer is largely going to be "sql server decides it dynamically looking at the memory pressure" 🙂

You may check if the backup is restorable or not with RESTORE VERIFYONLY. You might also be having a corrupt backup file.

You can use encryption provided by SQL, where you can use keys, certificates etc for encryption. Another option is that application send password to database after encryption i.e. encryption is...

It's advisable to have passwords encrypted rather than storing them as it is...