MDF, NDF and LDF

MDF: it's a data file, store the actual data with .mdf extension 
Store the permanent data.

NDF: it's secondary  data file, consist  of data and user defined  objects.


Primary data files
Primary data file is the starting point of the database. It points to the other files in the database. Therefore, every database has one primary data file. Also, all the data in the database objects (tables, stored procedures, views, triggers.. etc.) are stored in the primary data files. The recommended and the most common file name extension for primary data files is .mdf. 

Secondary data files
You can only have one primary data file for a database. Rest made up by secondary data files. But its not necessary to have a secondary data file. Therefore some databases may not have any secondary data file. But its also possible to have multiple secondary data files for a single database. .ndf is usually recommended to denote secondary data files. It’s also possible to store the secondary data file in a separate physical drive than the one which primary data file is stored. 

Log files
Log files in SQL Server databases hold all the log information. Those information can be later used to recover the database. Size of the log file is determined by the logging level you have set up on the database.  There must be at least one log file for each database. But it is also possible to have more than one log file for a single database. The recommended file name extension for log files is .ldf. 

PTE ACADEMIC Essay writing Question- 2

Parents should teach children about the importance of money. Do you agree or disagree. Give your own reasons and include examples from your knowledge and experience.

Sample response

There is no denying the fact that money plays a crucial role in our lives. Children are too young to fully understand the value of money or its significance in our lives. However, it still makes sense for parents to make them money wise from an early age.

Habits learned during childhood will stay with them for the rest of their lives. So, if parents can teach children how important it is for them to use their money wisely, they will become responsible spenders as they grow up.

Money may or may not be the root cause of all evil, but the truth is that we can’t live without money. Little children ask for just about everything they see. They don’t understand the financial difficulties involved in obtaining the objects of their fancy. They don’t understand the hard work their parents put in to earn the money necessary to provide them a comfortable living. By teaching children about the importance of money, parents can foster a sense of appreciation in them.

Parents can teach the importance of money in several ways. They can take the children along when they go shopping. This simple act teaches them that if they need something, they have to pay for it. Parents can cultivate saving habits in their children by gifting them a piggy bank where they can deposit their pocket money. Giving children monetary rewards for doing simple tasks around the house is another way of making them money wise. For example, if the children help dad in the garage or mom in the garden, parents can reward their time and effort by giving them a few pennies. This helps children learn many valuable lessons. They learn that to earn they have to work hard. This also helps them appreciate the value of labor.

I wasn’t raised by rich parents, but they were responsible people who knew how to live within their means. When we were kids, we didn’t have many luxuries. My parents, nonetheless, worked hard and made sure that we led a comfortable life and received the best education. It was the wise spending habits that I learned from my parents during my childhood that stood by me when I started living on my own.

To conclude, parents should teach children about money. This helps them acquire many life skills which will stand them in good stead when they start living on their own. Children who are involved in the financial matters of the family from an early age learn to appreciate their parents’ hard work. They also recognize the importance of spending money wisely.

PTE Academic Essay writing -1

Topic

These days many fathers stay at home and take care of their children while mothers go out to work. What could be the reason for this? Do you think it is a positive or a negative development?

Sample response

Thanks to widespread women’s rights movements, more and more women have become the breadwinners for their family while their husbands stay at home looking after the kids. In my opinion, this is the result of an extreme, yet naïve ideology that has created an imbalance in many families.

Organised groups which call for absolute equality between men and women are often shallow minded. Many such groups make illogical demands such as giving both couples exactly equal and reversible rights and responsibilities. In theory, this sounds fair and square. However, when you look at the details, it is not hard to see that this arrangement paralyzes both men and women by reversing their natural roles.

Improper allocation of roles puts exceedingly high pressure on women, and renders men’s roles rather ineffective. When women are the primary breadwinners for the family, they cannot afford to take long maternity leaves. Not only because such holidays may be unpaid, but also because they need to progress in their jobs to support their expanding family.

It is a well-known fact that mothers develop better bonds with new born babies. In addition, babies need to be breastfed multiple times during the day. This will not be possible if the mother has a demanding job that requires her to be away from the child for long hours. Therefore, it is counter-productive for the father to be the main caretaker. That said, it is indeed productive for the man to help with raising kids. The woman should also work to secure the financial future of the family.

In short, it is plausible for partners to share their domestic responsibilities, but an arrangement where mothers earn a living and fathers stay at home is way too extreme.

PTE Short answers

1)What kind of punishment is less severe, an imprisonment or community service ?
Ans:community service

2)In a figure of hexagonal, how many sides does it have ?
Ans:six

3)What key minerals makes sea water different from fresh water ?
Ans:salt

4)Which is a longest, a decade, a millennium or a century?
Ans:A Millennium 

5)How many sides are there in a bilateral agreement ?
Ans:two

6)What organs do cardiologist specialist in ?
Ans:Heart

7)In the animal kingdom, the purpose of camouflage to attract a mate, to find food or to hide ?
Ans:to hide

8)How do we weight butterfly ?
Ans:It is Grams

9)What Dermatology specialized in ?
Ans:Skin - Baldness & Hair

10)What is Hematology relates to ?
Ans:blood test

11)What is Orthopedic relates to ?
Ans:Joints, Knee, bones

12)What is term Neuro-Psych ?
Ans:brain injury or mental health

13)What is term Immunology ?
Ans:Immune related, HIV/AIDS

14)What is term Otolaryngology ?
Ans: ENT- Ear - Nose & Throat

SSIS Error: process cannot access the file 'ssisproject.ispac' because it is being used by another process.

I have got this message after I tried to run my package again and again after it was frozen.
This happened when Visual Studio crashes during run-time. If we kill Visual studio then the SSIS Debug Host will still be active locking the ISPAC file.

ERROR:
System.IO.IOException: The process cannot access the file 'E:\Comp_Optimizer\Solution\..................PATH.......ispac' because it is being used by another process.  

Solution:

Open the Task Manager (Ctrl + Shift + Esc) and locate "SSIS DebugHost" under Processes and end that process.

How to fix: The program cant start because MSVCR110 dll is missing from your computer

Today I am going to help you to resolve how to fix below error message when Start/Shutdown or login/logout screen.

It is really bad experience as a User. I faced this issue today on my computer and I am going to share how I resolve this on my computer.

The Program can't start because MSVCR110.dll is missing from your computer. Try reinstalling the program to fix this problem.

Microsoft Explains this issue as MSVCR110.dll is the Microsoft Visual C++ Redistributable dll that is needed for projects built with Visual Studio 2011. The dll letters spell this out.

MS = Microsoft, V = Visual, C = C++, R = Redistributable

For Winroy to get started, this file is probably needed.

This error appears when you wish to run a software which require the Microsoft Visual C++ Redistributable 2012. 

This can be downloaded on the Microsoft website as x86 or x64 edition. Depending on the software you wish to install you need to install either the 32 bit or the 64 bit version. Refer the following link:

http://www.microsoft.com/en-us/download/details.aspx?id=30679#

FAQ on Power Bank ..!

1) What’s power bank?
Power bank serve as an ‘extra battery’ or external charger for your phone or other electronic devices.


2) Where is power bank made from?
Majority of the power banks in the market are actually made in China.


3) How do I charge the power bank?
You can charge your power bank via the charger that came with your phone, computer usb port or using other power bank


4) How long do I need to charge the power bank?
It’s depending on the REAL CAPACITY of the power bank. The larger REAL CAPACITY, the longer charging time may required. Different charging methods may result different charging time as well. Charging with the original charger will be faster than charging with computer usb port.


5) Why sometime I need longer time to charge the same power bank?
Even though using the same charging method, the charging time may be differ due to environment,tem
perature, power flow and etc


6) What is mAh?
mAh mean milli Ampere Hour, the capacity of the power bank is measure with mAh


7) A 12000mAh REAL CAPACITY power bank, able to charge a 1500mAh capacity phone for 8 times full?
This is a common mistake make by most of the people. For rough calculation of the total charge time, kindly use this formula
REAL CAPACITY * conversion rate * phone battery health / phone capacity = total charge times
EXAMPLE: 12000 x 0.8 x 0.8 / 1500 = 5.12 charge times (0.5-1 times plus minus)


8) What’s conversation rate?
Conversation rate is the remaining percentage of the battery after the battery lost in heat or PCB operation.


9) What’s phone battery health?
In simple, it’s mean how‘healthy’ your phone battery is. Phone battery storage capacity will be lower and lower. That’s also the reason why our phone can last longer when it’s newly bought than after 3-6 months we used it. Different mobile phone models also will affect the calculation as some phone drain battery faster than the other.


10) What’s PCB?
PCB means Printed Circuit Board,its control all the operation flow inside the power bank. A good quality PCB will allow the power bank to charge more and have better durability
Source: Internet