For those recommending modifying the code - this is 3rd party vendor code and modifying that code without the vendors permission could invalidate the contract.  Some vendors will allow customizations...

So would you recommend to run update statistics with full scan for the whole database weekly instead of normal update statistics? One thing I noticed when I compared...

You really should be schema qualifying all objects - it guarantees that the table/object being used is the correct object.  For example, if you had a table called Person in...

Sorry - but it still isn't clear.  Users don't connect to databases - they connect to an instance.  I don't think you can build a trace or an XE to...

So - where is this failing and what is the failure message? ...

What version of SSMS are you using?  There was a bug in one of the older version where you couldn't see the files from the GUI.

If the secondary has not been configured for read-intent, then even with the application intent set in the connection string the select statements would not be redirected to that secondary.

If...

@jeff - I thought about the CTE method, but I've only used written one CTE successfully on my own to this point a few months ago...I'll keep monkeying around...

Right.

But we are changing the order of the select (or the Group By) not the when clause. And if you do - you get an error that says...

Because of the way CASE expressions work - a case expression will stop when it hits a true condition, and changing the order of the WHEN portion can change the...

• This reply was modified 4 years, 6 months ago by Jeffrey Williams. Reason: Moved the count(*) to the outer query where it should be

I feel that my SQL Agent service account is missing a permission since it runs OK when I login as sa, but fails under job execution.  The service...

I tried copying your code as-is into Azure Data Studio - it immediately shows some problems.  Redgate's SQL Prompt won't even format the code due to these problems.  You are...

Nope - no easy way.  You will need some project to identify the tables and determine what process will be needed for each table.  This can be done using SSIS...

You are on a very old version?  You need to upgrade to the latest version

https://www.microsoft.com/en-us/download/details.aspx?id=54616

Try this change:

$directoryList = Get-ChildItem -Directory  | % { $_.FullName } | Sort-Object

foreach ($directory in $directoryList) {
    $dirContents = Get-ChildItem -File -Path $directory...