So the reason (I suspect) is that you are using string_agg wrong. I don't have sample data from you to test things, so just guessing here, but I'd start by...

If the package isn't deployed, then Visual Studio tracks the time. No need to look at the database side. If you need to track the time on the database side,...

Just to expand on your article a bit in terms of hidden heroes - pretty much all of IT is a "hidden hero". Without them, companies would suffer a lot...

If it is just 1 stored procedure causing it and not everything coming from that system, I would suspect that the code is different between the 2 systems and that...

Just wanted to point out - that parameter not existing is what I (and others on here) have been saying the whole time, so it is no surprise that it...

My next best guess is that something in the connection string is setting it (not likely as I don't think you can set that in there), in the driver (possibly),...

as a guess, I think that can be a default on the instance level (maybe database level), so it may be set on the server not in the web service.

Failing...

In case nobody wants to download the file, this is the content (I viewed it safely):

SELECT TOP 25
 
dm_mid.database_id AS DatabaseID,
 
dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact,
 
dm_migs.last_user_seek AS Last_User_Seek,
 
OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id)...

Just to add to hmbacon's reply, sometimes the problem isn't found during the deployment. I've had problems found days or weeks after deployment. Rolling back in those scenarios can be...

You asked if we got "desired results" - what results were you desiring? Are you looking for performance gains (or losses)?  If so, turning compression on across the board will...

• This reply was modified 3 weeks, 1 days ago by Mr. Brian Gale.
• This reply was modified 3 weeks, 1 days ago by Mr. Brian Gale.

Just to add to what deubel_m said, Ola's scripts are not managed, maintained, or supported by SQLServerCentral. SOME users of this forum use them and can offer advice about them,...

My opinion - if you don't have access to their systems, that means it is not your problem. You can't see how they have their script configured plus I doubt...

Another thing - like Steve Jones said - having the API server just moves the load. If the API server caches things, you run the risk that the API server...

Another question for you is what problem are you trying to solve and how will you know it is solved? "Too many connections" is very arbitrary and not helpful. BUT...

Probably a dumb question, but you created a key correct and updated the instructions to use your key not the example one they have in their sample scripts, correct?

What I'd...