I would typically use a JOIN with MAX query for this kind of thing.

Something like the SQL below, did you already rule this out for some reason?

update...

Do you have Query Store enabled for the database(s) you are interested in? sys.dm_exec_query_stats has a column called last_execution_time.

The default for STALE_QUERY_THRESHOLD_DAYS is 30 - so if it has run...

Drop all the non-clustered indexes then re-create the clustered index with the DROP EXISTING option and use the FILEGROUP name instead of the partition scheme name, and then re-create the...

It looks like the query got truncated.... the common-table-expression data does get completed (there is no closing bracket and no other T-SQL statement using it), the rest of the query...

• This reply was modified 3 years, 3 months ago by  tripleAxe.
• This reply was modified 3 years, 3 months ago by  tripleAxe.

It sounds very much like a running total calculation that you want to do therefore I am guessing you need to use SUM with an OVER clause.

I would just run DBCC SHRINKFILE(2, 30720)

Are you using Visual Studio?  You could always use the SQL Server Schema Compare and Data Compare utilities for this, so long as your source database is not too large...

I would look at introducing a Conditional Split Transformation between the data source and the destination if you can define appropriate conditions on which to split the data.  You can...

Have you been able to review the xml_deadlock_report? This will show you the resource involved in the deadlock which might help point you in the right direction.

https://www.red-gate.com/products/dba/sql-monitor/resources/articles/monitor-sql-deadlock

Just wondering if it is the column names and the tables they come from you want to find out if you could use a sql parser on the queries you...

Do what Grant said!

i.e. start with

select @MaxRows = count(distinct AT.AccountId) from ATable AT

Does that work?

Next, do

select @MaxRows = count(distinct AT.AccountId) from ATable AT 

inner...

Do you have query store enabled? This can be very useful in tracking slow running queries down.   I'd also recommend taking a look at Extended Events and setting up traces...

• This reply was modified 3 years, 4 months ago by  tripleAxe.

I would leave the tables and stored procedures in place, unless you know for certain they are not being used.  As suggested by others I would script out the jobs...

I am sure you can do this using sub-reports, you would send the Invoice Number or Order Number value through to the sub-report.  I'm also sure you could do this...

I have worked with an array of numpties but never used a numpy array.