1st step - change the schedule to 7.30pm - then if it still fails we can rule out the time issue

if it still fails we can look at other options

my understanding is that it is number of processors -1 up to a maximum of 8 for the number of tempdb files

initial size , you are going to have to...

1. a plan will stay in the procedural cache for a varying amount of time - memory pressure, data changes, new indexes etc may all push the plan out of...

the query store is a useful tool, but as soon as your proc cache changes or you reboot your server then you start losing all of the valuable information it...

I might be tempted to do it in 2 stages

select * from dupes inner join (select first4 from dupes group by first4 having count(*) >1) dupes2  on dupes2.first4=dupes.first4

you might have...

I feel for you

you can script out your publications and subscriptions nice and easily

depending on whether you can knock...

select N'\\ABCD\EFGH\IJKL\MNSP\'+ @@servername+'\AL.txt'

unfortunately transactional replication is "distributor led" - you will need to move distribution to the 2016 instance (highest version wins) - which means you will need to rebuild the publications,...

it is...

We don't ever allow our Devs access to Production. What we do for them, however, is create a "production copy" database on a daily basis down to a non-prod...

also check out "attach single file db" - but don't forget to clean up the old ldf files if you do use this

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-attach-single-file-db-transact-sql?view=sql-server-ver15

ok - so why not script the attach

EXEC sp_attach_db @dbname = N'mydatabase',   
    @filename1 =   
N'C:\mydatabase_Data.mdf',   
 ...

I've started using MERGE for updating records because UPDATE just freaks me out. It takes more thinking out but will get faster with practice and it's good to get...

Hello!

I need to run weekly report for each month on Friday, beginning the first day of each month, and ending the last day of the month

Example

·         10-1-2019 thru 10-4-2019

·        ...

Del - just in case you missed it (outside our private messages) - on the link i sent you, just scroll down and you'll find the standalone installer - don't...