Perry Whittle (5/30/2011)

---

well i have never bothered myself but if you query the parameter

SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

this returns the actual node name the instance is active on.

Apply some logic and check this...

Nice question really.

Thanks for the question

I think you can consider some new roles available in SQL Server like the ones below.

SQLAgentUserRole

SQLAgentReaderRole

SQLAgentOperatorRole

I think Jr.DBA

Thank you Steve, good question.

In this case, no intervention is required, failover happens automatically

If not using witness...

Yes, I agree. It is better to use scripts to get familiarized with the underlying commands.

I'll give it a try (in a technically simplified way): The HoBT level (HoBT = Heap or B-Tree, see http://technet.microsoft.com/en-us/library/ms189849.aspx) is the structure underlying a table. If the table is...

Thank you Michael and Richard. It is clear to me now 🙂

You can also try through SSMS. Follow these steps.

Right click on database-> Tasks-> Shrink->Files->

You will see option at the bottom for ->Empty file by migrating the data to other files...

I thought row level locks would be escalated to table locks only.

I referred the link provided in the answer, but couldn't find any information regarding escalation to partition.

The Database...

How recent are the backups?

Were you able to check the maintenance plans or any backup job etc?

Nice question really

No offence, but please try to google this kind of information. It is better right?