using the ONLINE=ON is most likely what is killing the index creation.

but all other comments still valid.

from what I can see the output of that query will filter out the cases where either accountid or alternatecode is null - why are you stating it is not...

to load the full file without errors you basically define a table with a single column and you load the file onto it without specifying field delimiters - only record...

this may give you a hint https://www.mssqltips.com/sqlservertip/3456/getting-sql-server-metadata-with-python/

it would seem that one of your applications does like to get info about tables and its columns a lot - I've seen this...

this looks like code converted from Oracle - is your database/tables really setup to be case sensitive that you require to use UPPER for every single column?

there is a way...

• This reply was modified 4 years, 10 months ago by frederico_fonseca.

although not a direct help on this you may wish to consider testing doing split file backups (not stripped) to see if performance improves.

sometimes it does sometimes it doesn't.

see https://www.sqlservercentral.com/forums/topic/creating-split-backups-question...

openquery uses a linkedserver name - that name DOES NOT need to be the physical server name although when you create it through the gui and you specify it as...

no one can really prepare for something like what we had this year - at least not without spending money that may not ever be needed just for a worst...

you need to shrink files, not database.

example - replace test with your database name on the use statement, and with the logical name of your datafile on the shrinkfile command.

the...

a simple outer apply would do.

single pass on the table and it is clearer than Pivot/unpivot (at least for me)

select CID
     , t.CustType
from...

no matter whether you like it or not, 1)application developers write managed code more; 2)application developers implemented the functions, including FORMAT, CONVERT, CAST, LTRIM, RTRIM, TRIM, LEFT, RIGHT; 3)FORMAT...

I did say reading the manual is advisable.

format 110 will give the mm-dd-yyyy you asked for the other columns.

and easier as you don't need the right function

format is very slow and should be avoided whenever possible.

it does help to read the manual

convert(date, dob, 105) -- 105 format is DD-MM-YYYY

full

select right(convert(char(10), convert(date, dob), 105), 7)

I'm not surprised after those 158 million rows deleted - most likely done all in one go.

depending on your system and on what space it takes on the log file to rebuild your indexes I would reduce the size of the log file - assuming I...