Some things to check, roughly in order:

1) Verify that a valid and reasonable "max memory" value is set in SQL Server.

2) Verify that IFI is turned on in Windows to...

I can't imagine any tool that would be able to do that, given that each view level could be arbitrarily complex.

mike 57299 (7/25/2016)

---

I use the index for other queries as well. Can I create a new filtered index? How do I make the function use the new index?...

I agree overall with Alan's comments. If you're willing to convert existing code/queries, also look into an itvf to do the computation.

However, for now, let's tune what you have....

Jeff Moden (7/21/2016)

---

ScottPletcher (7/21/2016)

---

Jeff Moden (7/20/2016)

---

ScottPletcher (7/20/2016)

---

If the "isactive" flag is significant, i.e. a significant number of rows are actually inactive, then cluster first on it. If not, get...

Jeff Moden (7/20/2016)

---

ScottPletcher (7/20/2016)

---

If the "isactive" flag is significant, i.e. a significant number of rows are actually inactive, then cluster first on it. If not, get rid of it....

If the "isactive" flag is significant, i.e. a significant number of rows are actually inactive, then cluster first on it. If not, get rid of it. At the...

You could use a standard unique constraint if you continually deleted searches 2 hours or more old from the table. For example, have a job that deletes rows every...

The "standard/best-practice" way to get yesterday's date is:

DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()) - 1, 0)

Based on that, then make the necessary 6-hour adjustment on the starting time [the "+" in the...

While logged in as sysadmin, create a stored proc that includes "WITH EXECUTE AS OWNER". In that proc, have the command:

EXEC msdb..sp_start_job @job_name = @job_name, ...

Then GRANT the role(s)/user(s)...

To do any proper type of index tuning, you must have access to at least:

missing index stats, via sys.dm_db_missing* views;

index usage stats, via sys.dm_db_index_usage_stats;

index operational stats, via sys.dm_db_index_operational stats.

With that,...

I don't think the need the GROUP BY on the outer query, just a SUM() OVER(), so maybe this?:

SELECT

f.Country

,f.CompanyName

,f.InvoiceID

,f.SupplierCode

,f.InvoiceNumber

,f.[Scan Date]

,f.[Approval Date]

,f.[Days to Final Approval]

,f.[<7 Days]

,f.[>7 Days]

,SUM([>7 Days]) OVER(PARTITION BY f.Country...

You really do need a stored proc, given how complex the restore process could be, with a full backup, maybe differential, maybe log file(s).

I have a special user/utility db that...

Assuming you want to split first by a space, but if there's no space then by dash:

SELECT value, LEFT(value, ISNULL(NULLIF(CHARINDEX(' ', value), 0), CHARINDEX('-', value) - 1)) AS split_value

FROM (

...

If you:

1) always, or

2) almost always, or

3) most critically

search these tables using RECORD_TYPE_CD, as in this query, then you should cluster those tables first on RECORD_TYPE_CD. That...