anthony.green (12/15/2011)

---

Well I passed, was doubting myself a little while I was in there, and was glad that I reviewed a couple of the questions otherwise I bet it wouldnt...

frankcastle509 (12/15/2011)

---

I think there are many SQL dumps are available over the web and you can find many of them. I specially recommend you to search for video tutorials of...

Thanks Koen, appreciate your input!

Monitor your network statistics, latency for a a few days and see if its network related.

It could be a timeout issue as well.

Thanks. Yes, active/active. I assume if "Prevent failback" is checked in a situation when N1's resource fails and it fails over to N2 and then that same resource fails again,...

from your question I assume you are running an Active/Active Cluster?

when a resource in N1 fails, the whole resource group will fail over to N2, and if a resource fails...

Simple answer: Yes.

Advantages: You will be able to recover critical info such as Logins, Jobs, configuration.

RTM hasnt been released yet, but you can download RC0 to play with in the meanwhile:

http://www.microsoft.com/download/en/details.aspx?id=28145

Well, firstly, great career choice 😀

The best would be to keep on learning and playing, because one day you will end up in a position where you may/could flaunt your...

great question (if you didnt run the t-sql)....certainly whipped by butt today 🙂

lesson learned.

http://lmgtfy.com/?q=SQL+server+Analysis+services

L' Eomot Inversé (11/30/2011)

---

Henrico Bekker (11/29/2011)

---

even though x=y, and y=x, your case statement catered for the following result:

'v3 = v2' and no where specifies v2=v3.

"None of the Above" should be...

even though x=y, and y=x, your case statement catered for the following result:

'v3 = v2' and no where specifies v2=v3.

"None of the Above" should be correct as well.

erm...just me or does this query in fact work?

name fileid

master 1

Ran it in Denali and seems fine... 😎

try using the following:

use master

go

SELECT

percent_complete AS ‘PctComplete’,

start_time AS ‘StartTime’,

command AS ‘Command’,

...