At the very least please post the Actual Execution plan and give us some insight as to why you want it to optimize it in the first place - is...

If it were me, I'd give it an "internal" deadline - meaning, pick a date that things need to change by and then make the decision to give your boss...

+1 Grant, that's where I was heading with my thoughts but very hard to guess at it without any example of the code used :hehe:

Can you post your code for the function, the code calling the function, and some sample data so I can run it?

Well, add the [name] column to the query?

SELECT QUOTENAME(SCHEMA_NAME(schema_id)) + '.' + QUOTENAME([name]) AS SchemaTable

FROM sys.tables

WHERE is_replicated = 1EDIT Removed the DISTINCT (not needed)

If all that's in there is old records from 2011, you're good to go. These can and should be removed. In fact, by default the size of the...

Something like this?

SELECT DISTINCT SCHEMA_NAME(schema_id) AS SchemaTable

FROM sys.tables WHERE is_replicated = 1

Wow Grant, that "SQL Server 2012 Query Performance Tuning" book is $40- do we get an SSC discount? 😀

How about this? You could just both result sets into a temp table or use CTE to select out the results SELECT

ja.job_id,

...

My Bad 😉 Was just teasing:

http://www.mssqltips.com/sqlservertip/2628/how-to-find-outdated-statistics-in-sql-server-2008/

🙂 I think we've all been in a similar situation so stay positive and don't get personal, stick to the facts and what's best for the company (and your role...

If you have a job that runs frequently that updates statistics, or have auto statistics turned on, then they should be fairly up to date. To see when they...

Include a JOIN to msdb.dbo.sysjobactivity and ORDER BY the run_requested_date DESC - it will return 0 for any job step that is currently executing - example: (SELECT TOP 1 ISNULL(last_executed_step_id,...

It's TSQL isn't it? You should be able to find the executing...

Here's a thought, play devil's advocate: go to the husband who set up and configured the server - Ask him how he configured the storage array: Ask how he aligned...