The test is simple and straight forward

set statistics time , io on
go

select FORMAT(datecol, 'yyyy-MM-dd') as Datetext
from #TallyDate
--order by DateCol

/*
(10000 rows affected)
Table '#TallyDate__________________________________________________________________________________________________________000000000008'. Scan count 1, logical reads...

just to add to Jeffrey's hints:

Keep in mind your secondaries will also need the same size available !

Don't forget your LDF files ! (these do not benefit from IFI !...

Which cloud(s) are you using?

how did you configure your connections?

how does your routing work?

did you configure the needed firewall rules?

 

If possible, avoid linked servers.

your code may block others ( local to the linked server ) !

Maybe your process is even better off doing its stuff using e.g. SSIS (...

You could put it all in a table ( non-# and non-## ), kind of a key-value pair thing.

Then have the query selecting your stored row from the table

 

            
June 15, 2022 at 12:59 pm
            
#4049881

            
            
                                                
        

Best is to have sp_send_dbmail execute the query and store the result in a given filename to be added to the email

e.g:

declare @subject varchar(1000)
set @subject = @@servername...

I don't know for Aurora and mysql

 

In SQLServer you can just use "GRANT view definition TO ..."

I would not rename the new server (to much a hassle ), but have an alias for the name of the old server point to the new server.

I figured out why the exec @cmd wasn't working. I was filtering out the files before it got to the cursor. Now I have one last problem. I am...

Does your service account have access to 'D:\TelcorLogDump\' ?

 

crossed with your last reply 😉

 

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

1. Of course, updating the existing table will cause splits / fragmentation
2. My guess, your primary key is non-clustered ( dbatools scenario ), so insert into a heap ( quickest...

Using "with standby" you force the engine to make your database available in a read-only state.

If you know you'll have to restore all log backup files, use NoRecovery in stead...

SQLServer will have to rewrite the whole table as internal workings of varchar(n) versus varchar(max) !

1. You could also prepare the modification via SSMS and script the operation.

It will probably...

So, someone has a local instance of SQLServer on his/her/its client and declared a Linked Server pointing to another SQLServer instance which can be available with an active VPN connection.

...

On top of Grants replay, you should probably be using last_request_start_time to avoid killing sessions which are still actively used.

( maybe killing one of your sessions with which you are...