Welsh Corgi (6/30/2015)

---

I do not see where this code is reading a Transaction Log?

SELECT [Transaction Id], [Begin Time], SUSER_SNAME ([Transaction SID]) AS [User]

FROM fn_dblog (NULL, NULL)

WHERE [Transaction Name]...

This is all rather interesting, so I thought I'd chime in.

Based on what I've tested, Scott is technically correct. Under the right conditions, even where it is not preventing blocking,...

I'd make sure the account under which the cluster service is running on those machines has a non-disabled login in SQL Server. Just being a member of the public server...

Sure, I know it has to take the X lock on the DB, so it's unlikely you'd get it to run on a busy DB, but it's not just impossible....

Joie Andrew (6/26/2015)

---

I think the real disadvantages are the requirements for AlwaysOn that mirroring doesn't have. Mainly:

- Requires all nodes be a part of the same domain

- Requires AD

- Requires...

Also, if you want to make sure that you always get the name of the primary replica (in case you connect to the listener with read-only intent and have that...

Depending on the amount of activity, you can also get some information from the default trace (session ID, application name, login name, and such). If your server's especially busy, the...

ken.trock (6/26/2015)

---

sgmunson (6/26/2015)

---

Jacob Wilkins (6/26/2015)

---

In 2012 you still have to enable 2371 to get the new auto update behavior. It's easy to confirm following the same methodology as used here:...

In 2012 you still have to enable 2371 to get the new auto update behavior. It's easy to confirm following the same methodology as used here: http://www.sqlskills.com/blogs/erin/understanding-when-statistics-will-automatically-update/.

I just ran a...

From https://msdn.microsoft.com/en-us/library/ms188388.aspx:

REBUILD [ WITH (<rebuild_index_option> [ ,... n]) ]

Specifies the index will be rebuilt using the same columns, index type, uniqueness attribute, and sort order. This clause is equivalent to...

To follow up on what Gail said, the issue of poor estimations due to out of date statistics on ascending columns is a fairly well-known problem. https://www.simple-talk.com/sql/database-administration/statistics-on-ascending-columns/ is a good...

Getting values <1 for the highest PERCENT_RANK() is quite normal. All that has to happen is for the value ordered last by the ORDER BY to be repeated in the...

No problem!

Since my previous reply I've had more caffeine, and remembered that I was incorrect in one very important way, namely, you can get some blocking.

Writes to the source index...

In an online rebuild, the X locks you are seeing are on the new index structure being built, not the current index structure your queries are hitting.

You can confirm that...

A CTE's scope is limited to the statement immediately following its definition, which is why the second UPDATE is throwing that error.

There are a few things you could do instead.

1)...