ScottPletcher (9/1/2015)

---

Jacob Wilkins (9/1/2015)

---

ScottPletcher (9/1/2015)

---

Jacob Wilkins (9/1/2015)

---

I know it's rather off-topic, but it's an interesting diversion, so I thought I'd just chime in on NOLOCK and temporary tables.

SELECT queries against...

ScottPletcher (9/1/2015)

---

Jacob Wilkins (9/1/2015)

---

I know it's rather off-topic, but it's an interesting diversion, so I thought I'd just chime in on NOLOCK and temporary tables.

SELECT queries against temporary tables typically...

I know it's rather off-topic, but it's an interesting diversion, so I thought I'd just chime in on NOLOCK and temporary tables.

SELECT queries against temporary tables typically only take a...

I'm actually working on my first QotD submission, coincidentally enough. From those of you who have done it before, is there a way to preview what the submitted question will...

Perhaps something like this?

SELECT

Userid,

Cartid,

pay=SUM(CASE WHEN ActionType=1 THEN pay ELSE 0 END),

Back=SUM(CASE WHEN ActionType=2 THEN pay ELSE 0 END),

Pure=SUM(CASE WHEN ActionType=2 THEN -pay ELSE pay END)

FROM P INNER JOIN...

Lynn Pettis (8/28/2015)

---

mar.ko (8/28/2015)

---

Exactly, another...

Sean Lange (8/26/2015)

---

A bit late to the party and surprised nobody else commented on this yet. The reason you are having this problem in the first place is because you...

I wasn't so much interested in the log_reuse_wait_desc, as that's just getting pulled from the primary. I included it just to be sure about that piece. I was more interested...

That is interesting. When run from the primary, what does this query show for the database in question on each replica?

SELECT arcs.replica_server_name, d.name, d.log_reuse_wait_desc, drs.log_send_queue_size,drs.redo_queue_size

FROM master.sys.databases d

INNER JOIN master.sys.dm_hadr_database_replica_states drs

ON...

That indicates that data movement for that database from the primary to the secondary is not occurring, either because it's disconnected or movement has been suspended.

I'd check to make sure...

You're already in a good spot for the fix with Gail's excellent advice.

Just for a bit of explanation in case you're curious, that is expected even with just the value...

A couple questions that are worth covering, even though they seem a bit silly:

1) Are you perhaps looking at Program Files, and not Program Files (x86), or vice versa?

2) Are...

Are there supposed to be duplicates in the data? It seems that this row is repeated:

SELECT 140675887, 072915205, 1580, 'D'

Cheers!

EDIT: Fixed a typo.

If that's the exact query you're trying to run, then you have a comma after the last expression you're selecting, so you'd want to remove that.

Cheers!

My apologies, but I'm not really following what you're saying.

Perhaps it would be best if you posted a small sample data set for this thread that illustrates the incorrect results...