To use the formula, just change the variable with your "seconds" value. My guess is that you need to replace @Duration_Sec with sum([TalkTime]+[HoldTime]+[PostCallProcessingTime])/sum([CallsAnswered]).

For a simple count of the tables, you can use something like this:

SELECT t.name AS Table_Name, SUM(row_count) AS Row_Count

FROM sys.dm_db_partition_stats s

JOIN sys.tables t ON s.object_id = t.object_id

WHERE index_id IN (0,1)--heap...

Use the DATENAME() function.

curious_sqldba (8/9/2016)

---

Lynn Pettis (8/9/2016)

---

curious_sqldba (8/9/2016)

---

I am subscribed to these groups:

Current SubscriptionsNotification

Home » SQL Server 2008 » SQL Server 2008 Performance Tuning

Instant

Home » SQL Server 2014 » Administration - SQL Server...

AFAIK, errors with severity 10 or lower can't be captured as they're basically warnings.

No, the use of a scalar function in the query.

It's not about one join being better than the other. It's about using the correct join for each query.

Here's an explanation on how each join works.

http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

The Dixie Flatline (8/9/2016)

---

I would look at rewriting the scalar function dbo.calcperiod to a itvf (in-line table valued function) and modify the second option to use it instead of the...

Is this query:

select dbo.calcperiod(value) from sys_registry where system_code = 'gbl' and name = 'reportdate'

related any way to the outer query?

Will it return a single row? If so, why don't...

What's this?

Are you subscribed to the forum? Is the spam coming from spam threads created in the forum and then deleted?

ChrisM@Work (8/9/2016)

---

...because they're way too expensive for such a...

Even if with this amount of rows it might make no difference, avoid using recursive CTEs to count. Here's another version which might seem too wordy, but it will be...

Anandkumar-SQL_Developer (8/8/2016)

---

Thank u Luis Cazares ,

...

Did you try increasing the max token size as suggested in here:https://msdn.microsoft.com/en-us/library/cc645913.aspx?