it can take days to shrink depending on how busy the db is.

and I would expand that command - prefer to be specific about which files get truncated and to...

I may be wrong but this would only prevent LOG file shrink - not data file (which I...

what exact command are you using for it?

Tom - that is the perfect example of WHY code reviews SHOULD be done - the reaction that individual had would also be a good pointer to go and review...

did you implement the indexes I mentioned on https://www.sqlservercentral.com/forums/topic/query-filling-up-tempdb ?

some of them would help on this particular issue as well.

and while not necessarily the issue on this case replace that...

why do you say it does not work?

SMO, and that particular script (with a few changes required on the scriptingoptions block as it its missing significant items) is one of...

• This reply was modified 2 years, 1 months ago by frederico_fonseca.

this may not be the correct way but check https://www.mssqltips.com/sqlservertip/5437/adding-a-database-to-an-existing-sql-server-always-on-configuration/

why is it difficult? you just need to...

if you have them on sql_modules you will also have them as SP's - so a normal "drop procedure xxxx" on master will delete(drop) them.

(to be safe generate their definition...

this is the type of sql you should confirm yourself in a dev box - if it is wrong you will see the errors.

as for executing it blindly as you...

and how is sproc_ValidateUser  getting executed?

and were are transactions being set on the full chain - starting with the top level code that executes sproc_ValidateUser.

a possible way of changing the...

and on this case I would nearly bet that the 2 procs involved on the deadlock are called in a loop with an outside transaction

process 1
exec dbo.sproc_ValidateUser

...

• This reply was modified 2 years, 1 months ago by frederico_fonseca.

on my case the issues we had was not on the data retrieval but on rendering and processing - which is done after all data has been loaded.

the OP didn't...

had lots of those as well - even after increasing the timeout significantly they were getting similar errors after 90 min - as we were only using SSRS to generate...

have a look at this example - based on something I do for dynamic reports

drop table if exists #data

 CREATE TABLE #data 
( RecordID int identity(1, 1) --...