if you already have a good spec (you didn't tell us what you have) then you might be better off supplying us with some of your "bad behaved" queries and...

sorry but I did not say that is should be 10-20% max.

What I said is that in one of my servers (and we have over 800 SQL servers) we have...

get an I7/I9 with 6 cores+ and 32GB+ ram and some SSD disks.

you may also need to tweek max DOP and CTFP so your queries to not overload the machine....

• This reply was modified 5 years, 6 months ago by frederico_fonseca.

what may have left you bad was mixing cpu with log file growth.

although for SQL to grow a file it requires a small amount of cpu that is not enough...

can you supply a ACTUAL plan instead of estimated of a query with problems - a 1 row estimated is not an issue

on the plan you supplied your big issues...

not much you can do on this except remove the sort.

plan here https://www.brentozar.com/pastetheplan/?id=BJrAKS0RD

SELECT [DocumentCategory].[CategoryID] AS [CategoryID]
     , [DocumentCategory].[ProcessEvents] AS [ProcessEvents]
  ...

• This reply was modified 5 years, 6 months ago by frederico_fonseca.

stop mixing questions - you asked for something that was answered - thats it.

your last post is a completely different question - so raise a new thread for it.

But before...

if there is a FK column on that column and the column is not null(not sure if this one required) then if no column is retrieved from the other table...

regarding using "PKWare SecureZip" - this is a commercial software - I suggest you also look at 7zip - quite good and free.

all remaining comments above apply.

kind of you can.

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-server-permissions-transact-sql?view=sql-server-ver15

• View any database
• connect any database
• view any definition
• select all user securables

you can do it - but not easy.

option 1 - Sharepoint Excel Services - https://docs.microsoft.com/en-us/sharepoint/dev/general-development/excel-services-overview 

option 2 - use OpenXML https://github.com/OfficeDev/Open-XML-SDK - C# code - better as an independent...

Hello everyone,

I am currently looking for a way to create Excel reports that include formulae (probably also Pivot tables and other stuff) from Reporting Services. Searching the web...

try

,convert(decimal(38, 2), case when f.HAI ='A' then (isnull(f.NUM,0)/f.DEN) *10000
                  ...

add required indexes - and see why the table does not have any at all - including a clustered index as that is normally, although not always, a good idea

I assume you are running that query and outputting onto a table so you can compare changes between runs - those are cumulative values since last instance startup - having...