Job adverts would be the best thing, then you will get an idea of what employers want you to know. Also, sign up to linked in. Have a look through...

have a look at this

http://stackoverflow.com/questions/560621/sql-convert-column-to-row

If backing up across multiple disks, just make sure all...

and does the Quorum act as the "witness" like database mirror requires?

DaveDB (10/4/2013)

---

Hello,

This is kind of a basic question, but I'll ask anyway lest I look bad in front of my boss....

I have to upgrade a 2005 SQL box to 2008....

Also depends on the amount of files you back your database up across.

Personally, for TEMPDB i have all of the files on the same drive by default. They are always on their own dedicated drive though.

For the Data and log files for...

SSAS is cluster aware from SQL 2008...

Ed Wagner (9/12/2013)

---

SQLSteve (9/12/2013)

---

The only people who can edit jobs is the job owner and people with SA. So unless people have a requirement to edit their jobs on a...

The only people who can edit jobs is the job owner and people with SA. So unless people have a requirement to edit their jobs on a regular basis (which...

Talib123 (9/12/2013)

---

I need to install SSAS as an extra feature on a 2 node SQL Cluster.

This will have to run as a separate instance, what is the process to...

mike.dinnis (9/11/2013)

---

Just wanting to get your views on the use of a common sa password for all instances vs individual sa passwords.

Obviously the sa login is to only to...

Erland Sommarskog (9/9/2013)

---

The thing about "one file per core" is not correct, but what is correct is more difficult to say. I vaguely recall something about 1 file for every...

I would personally have more than 1 Disk for the Data, Logs, tempdb and backups ;).

G_Dubyah (9/11/2013)

---

Hi,

I installed Standard Edition of SQL Server 2012 instead of Enterprise Edition. Do I have to remove all of the features before installing enterprise edition or is there a...