A logical processor is not the same as a core. A core can have 1 or 2 logical processors. Reference: TechNet: Computing Capacity Limits by Edition of Microsoft SQL Server

The...

Right off the bat, I would recommend to try converting the multi-statement function into an in-line TVF. In-line TVFs offer better performance when compared to multi-statement TVFs. Here's a BOL...

Nice question, however, I must admit, the first answer that came to me was "Depends upon the file system."

muthukkumaran Kaliyamoorthy (6/13/2012)

---

In my server the browser is disabled. and the port is 5555

Server is listening on [ 'any' <ipv4> 5555].

Dedicated admin connection support was established for listening remotely on...

Koen Verbeeck (6/13/2012)

---

So it can be different, but there is no indication that it will be?

So there is a chance DAC will succeed for the default instance as it tries...

Koen Verbeeck (6/12/2012)

---

Nice question.

The MSDN article Using a Dedicated Administrator Connection says the following:

SQL Server listens for the DAC on TCP port 1434 if available or a TCP port dynamically...

Nice & easy for a Friday. Thank-you, and have a great week-end, everyone!

Hugo Kornelis (5/31/2012)

---

george sibbald (5/31/2012)

---

I think we should clarify that you should not remove a service pack simply by replacing the resource database with a previous version of it. I'm...

Hugo Kornelis (5/31/2012)

---

Nakul Vachhrajani (5/30/2012)

---

It is my understanding that the service packs/upgrades have the potential to modify all databases on the SQL Server instance, therefore, simply replacing the resource database...

It is my understanding that the service packs/upgrades have the potential to modify all databases on the SQL Server instance, therefore, simply replacing the resource database to rollback an SP/update...

Nice & easy question. Brings back memories from a couple of days ago 🙂

Hugo Kornelis (5/29/2012)

---

Okay, I was unaware of this limitation (though I have no idea why anyone would ever even WANT to do a differential backup on master!), so I guess...

By default, SET XACT_ABORT is OFF.

Good question with a couple of learning points.

1. By default SQL does not abort the entire transaction if it encounters a statment-level failure. In this case, the primary key violation...

Good question!

This one takes us back to the basics, and requires the reader to read and think carefully - and after you think through it, you realize that there is...