To prevent someone from logging on with your account follow these three guidelines:

- Don't share your password with anyone.

- Don't write your password down somewhere where someone else can read...

Yes indeed, the client tools are installed in different directories like C:\Program Files\Microsoft SQL Server\{80, 90, 100, 110}.

Also BIDS uses Visual Studio and multiple versions of Visual Studio can be...

Yes, you are correct.

You can install zero or one...

On a stand alone server Microsoft Distributed Transaction Coordinator (MSDTC) run as a normal service.

On a fail over cluster MSDTC has to be installed as a cluster resource. Up to...

SQL Server is a...

If you use SSMS of SQL Server 2012 the cariage return and line feed characters are copied when you use copy and paste.

Hi Chewychewy,

You may want to look at these articles:

PerfMon: High Number of Pages/Sec Not Necessarily Low Memory

Enable the Lock Pages in Memory Option (Windows)

You have might other processes running on the principle server which are not running the mirror server. This way there is more memory for SQL Server on the mirror to...

Most memory used by SQL Server is used for the Buffer Cache. The Buffer Cache is the working space in where data is kept for frequent access. This works similar...

I wouldn't worry much about his behavior. As it has been said this is normal behavior. Over time SQL Server will allocate otherwise unused (wasted) memory. It will give it...