I Just read an article n..

On windows server we just need to ENABLE WOW64. It is usually disabled, so we need to re-enable it. By, this it works.

......

Understood. Thank you for your information

Thank you Elliot. You got me a very good Information. Even I set the password using symmetric key method. But, you have got a good point of breaking up the...

In order to protect against external threats. As you know it contains most of the PII data, I would like to apply some kind of encryption technique to the database....

I would like to protect whole 'SQL Server Database' for security reasons.

Excellent. Thanks for clear explanation.

I am still not so clear with your explanation. Can you please, explain which statement executes first in a step by step method. Thank you

CONVERT(DECIMAL(9,5), --Executes 3RD

CONVERT(DECIMAL(18,5), SUM(PH1 + PH2 + PH3)) / - - Executes 1st

CONVERT(DECIMAL(18,5), COUNT(*)) -- Executes 2nd

)

ABOVE mentioned steps it...

The datatype for Totalavg is 'Decimal' of prec 9 and scale 5. This I am using on a select statement. I just need is explanation of why multiple decimal...

got it. Thank you

Yes, by adding clustered index onto column reduced the Fragmentation level. Thank you all for your support.

--Every Day is a Learning Day...:-)

Yes exactly, created clustered index will usually provide some change. I will update, once i add clustered index.

The good thing what I noticed on my DB is it actually happening on most of temporary tables. But, for time being it can be ignored. But, if it...

Understood. So how about if we have the following situations:

Index Type: Heap

Avg_Fragmentation_IN_Percent: 99

Page counts : 885

or

Index type: Clustered Index

Avg_Fragmentation_IN_Percent: 66

Page counts : 3.

If we have less page counts then do...