1) Get a copy of Itzik Ben-Gan's Windowing Function book.

2) Fabiano Amorim did a great blog series on Simpletalk.com on WFs

3) You shouldn't need to put the data into...

gkramer 23701 (10/31/2016)

---

@TheSQLGuru

I located the failed logfile, but executing the restore, it stated this one was too young and the previous logfile stated it was too old - and there...

I haven't seen this particular error in the past, but once you fix the full-storage problem you "should" be able to restore the same log file that failed and then...

That's stretching the inquiries appropriate for a free support forum there Jimmy! 🙂

I am traveling today and will be pretty busy tomorrow with family stuff. But I will definitely try...

Chris-475469 (10/27/2016)

---

Yeah I'm aware of those things as well. Tuning this system is going to be a long and painful process.

One thing I am surprised about is how bad the...

most likely cause is a long-running transaction. You can set up a variety of things to watch for that.

If the consumption has been removed (dbcc sqlperf(logspace) may show it) you...

One more thing for grins and giggles: have you tried Trace Flag 4199?

Chris-475469 (10/26/2016)

---

Thanks for you reply.

I discovered someone had added an index on the risk__tag table which was causing the strange plan in production. I agree the code isn't great and...

Jimmy M (10/27/2016)

---

Thanks for your responses.

For where we are right now, the criticality of the problem, and how little we are able to simplify the T-SQL in the offending reports...

Definitely don't want to just drop them all!!

DTA is just HORRIBLY misused in my experience! I once spent almost 200 man hours cleaning up rampant DTA use by a...

1) misconfigured/over provisioned virtualization can cause memory flushes

2) I have seen probably a half-dozen different firmware/driver/other bugs over the last 2 decades that caused complete memory flush. Are you patched...

Jimmy M (10/26/2016)

---

Hi all,

We have an issue whereby over-complex filters within queries generated by a report engine are resulting in wildly overestimated cardinality estimates.

In turn, this leads to...

Rechana Rajan (10/23/2016)

---

TheSQLGuru (10/23/2016)

---

Note that if you decide to shrink the main database after pruning data that evolution will cause EXTREME FRAGMENTATION of all your objects!!! You will need to...

PiMané (10/22/2016)

---

Hi,

I'm remotely analyzing a SQL installation on a virtual machine in a blade server...

I don't have access to the hardware configuration nor I know the virtualization software... The person...

Note that if you decide to shrink the main database after pruning data that evolution will cause EXTREME FRAGMENTATION of all your objects!!! You will need to leave free space...