1) We need create table script and sample data to help with a query.

2) Why use integers for what looks to be a Boolean (isDay)? VERY inefficient data type choice...

1) are you SURE it is in SIMPLE recovery mode?

2) I think it won't clear until reaches end of current VLF.

3)

SELECT log_reuse_wait_desc

FROM sys.databases

WHERE name = 'MyDB';

4) Long-running...

1) I bet some third party systems can do this.

2) It is VERY easy to roll you own historical trending by just putting your results into a permanent table. HIGHLY...

Eric M Russell (8/12/2015)

---

Where is this feature...

I do not believe it is tracked, so there...

It means learn how to use online search tools such as Google, Bing, etc.

Standby mode in log shipping is a very nice feature that allows you to run read-only workloads from the log-shipped secondary. Someone set it manually or much more likely it...

Do NOT do what you want to do!! Here is a Guruism: slapping together code quickly is BAD, often for multiple reasons. Plus you will be creating a maintenance/troubleshooting nightmare....

Data distribution, statistics staleness, bad cached plan, just plain a lot of data hit/returned, etc.

I would almost ALWAYS run such queries with OPTION (RECOMPILE) to ensure you get best possible...

ricardo_chicas (8/6/2015)

---

as an update the sort in tempdb didn't work...

The latency between the primary and secondary replica (synchronous) is only 5ms

I am at a loss here, not sure what else...

MANY things can cause those est/actual row count differences: table vars, UDFs, functions around columns in where, stuff inside views, mis-matched column data types in joins, mismatched datatypes in parameters...

1) I see vw..., indicating likely views. Lord only knows what those have in them

2) Table variables should be replaced with temp tables

3) Someone got rid of the silly cursor

4)...

I took a quick review of the sproc. I lost count of the things that are suboptimal in it, and that doesn't take into account anything about the data structures...

I pretty much always prefer the sort in tempdb option when tempdb will support the size and load of the operation.

You have done monitoring and proved that the tlog...

ricardo_chicas (8/4/2015)

---

This is not in production yet so I was testing the maintenance jobs, the replicas are getting the logs properly and on regular use the backup strategy is able...