Wao, 7 credits in the morning. Started with a good day.

More precisely, it's "Apple Macintosh Powerbook 5300"

It says : "Stretch Database lets you archive your historical data transparently and securely. In SQL Server 2016 Community Technology Preview 2 (CTP2), Stretch Database stores your historical data in...

Google/Bing is the all time partner but experts do have authentic suggestions. Anyways, not getting useful tips in Internet. Anyways, thmx for the great advise, I appreciate! 🙂

Any update , Experts?

tempdb is like a scratch pad, so it will be filled up with many unnecessary stuff.

Create temp table (#) wisely. If not required, don't perform sorting operations on large tables,...

So if the databases state says = 3 (I.e. encrypted) and is_encrypted column value says = 1, so can I term that the db is properly encrypted?

I did something extra.

I...

Thnx Guys.......Even I too knew but elder folks like to argue on the matter, so now I will paste the links for them to know.

Just one more point, I liked...

Thanks. Can you ping me a suitable MSDN link to show that.

I think its not because of divide by zero issue. The results appear as it matches condition 1 so results 1, condition no#2 does not match condition, so result =...

Any update from anyone?

Hi Gerd

I have sent an email to you asking yu to send me the document but got a bounced back email.

Can you please tell me your present email id?

Both the path details you mentioned are diff

Thnx, I thought to check using a quick demo script, but anyways, you did the part.

Thnx Steve. I knew the answer so it did not take time to click the right radio button.

But, 1 question, if any of the non cluster indexes in a table...

Well, I have identified the issue and fixed it.