First of all, make sure you create full backups asap. Big tranlogs are usually a sign of absence of full backups altogether. After this, design a backup strategy/BCP.

I've heard of the reporting service going to sleep. The resolution was to create a scheduled hourly dummy report to keep it awake. I'm afraid I do not have any...

In the meantime we have found out with wireshark that the address is sent to SMTP correctly so with the quotation mark after Nomen: "Nescio, Nomen" nomen.nescio@noreply.com. Apparently the SMTP...

To add to Grant's remarks about statistics maintenance: hard to overestimate the importance. In the past when we encountered performance issues we first checked if the maintenance plan was running...

Thanks for informing back on the issue and glad you got it fixed.

Bouke

As I understood it there are Power Management and Performance options for CPU and Memory. The details depend on the BIOS and are not easily generalized (so our system specialist...

We have seen something similar but not for sql due to energy saving settings on the host. No details at hand. We had to change bios settings if I remember...

If you are asking for VIEW SERVER STATE (VSS), you might want to ask for VIEW ANY DEFINITION (VAD) also.

I work for a software vendor, our software uses SQL Server....

Lynn Pettis (5/19/2014)

---

Well, I hope you got what you wanted. I still can't quite figure out how you get your expected results from your sample data as your code...

LutzM (5/18/2014)

---

I'm sorry Lynn for not providing any addtl. information how I ended up with the solution I posted....

Here's the "story behind":

I looked at the result set based on the...

SSMS uses row by row processing. You could see this wait type when you run a query in SSMS on the database server itself. Indeed there is no network involved...

I totally agree. I pick up something useful everytime I browse around the forums. And I could give quite a bit of examples of practical usage in my work of...

ChrisM@home (5/6/2014)

---

Without sample data to test against...

Try this.

;WITH Updater AS (

SELECT

FTEHrsAVG,

NewFTEHrsAVG = AVG(CASE WHEN FlexVast = 'VAST' THEN FTEHrs ELSE NULL END)

...

Google Glenn Berry's diagnostic queries. They have helped me in various situations and give a good insight in the most important aspects of an SQL Server instance. He has sets...

I have come across examples where views make it easier to introduce performance problems. Especially when columns are an outcome of a function or case statement etc. A view might...