BLOB_EATER (5/10/2016)

---

I am seeing a lot of training events recently and I am wondering, If level 300 is intermediate level, level 400 is advanced, then what is level 500? Superman...

Datediff returns the number of whole intervals between the two dates, it will never return a fraction.

Try taking the difference in minutes instead of hours and then dividing by 60.0.

Where's the join?

FROM <table> [LEFT|RIGHT|INNER] JOIN <table 2> ON <join condition>

[LEFT|RIGHT|INNER] JOIN <table 3> ON .... repeat for the rest of the tables in your query.

So,

FROM person...

Probably because it's spelt wrong.

From your earlier query:

JOIN Context ctx ON ctx.currentValue = bi.description2

but also because there's...

Try updating statistics on MyTable, with fullscan

Please don't post multiple threads for the same problem

No replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1784238-2799-1.aspx

Yes, you have to add all the table joins, but you've specified all of them as inner join (inner is implied if nothing else is specified), the join between timeperiod...

And the name? Or the pattern of the names?

On the basis of the extension, that's a profiler trace file, and that's about all that can be concluded.

Might be useful if you mention the file name, extension, or at least the pattern of the file names.

Yes, the approach that was suggested 4 days ago.

GilaMonster (5/5/2016)

---

Identify the queries using the most CPU and tune them. This may not be the most expensive...

You could look at DBCC OPENTRAN and the transaction-related DMVs, you know the normal way you diagnose long-running transaction. There's nothing special about the fact that it caused the backup...

Looks like there's a long-running transaction that's keeping the transaction log active (and making it grow).

Actual plans please. The estimated (which is what you posted) are lacking run-time information.

Could you also please post the definitions of the indexes on POLICY_DATA?

Is this a star-schema?

Can you post the execution plans of the queries (the one that's fast, and the slower plans with the added clauses)?

Actual plans please.

Did you look at just expensive individual queries, or ones that, on aggregate, use a lot of resources? If the former, that's not going to get you very much, you...