good.

that is almost the same script I was going to send you (with a few modifications of mine)

90% of prod...

Sent you a private message.

big financial group - lots of sub companies/teams

small shop you have there.

Just on my side of the ocean we have over 750 servers (half is prod) - with a total size of 100 TB space used spread...

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

moving to ssdt is not something I would advise - SSMS is a administrator tool, SSDT is a developer tool - functionality is rather different and SSDT will be missing...

touch-typist

As part of my travels through the air force (transmissions/communications) we went through intensive typing training - at start of the course we were having 12 hours a week of...

you have other views there - and views over views over views always cause issues with the query processor.

the actual explain plan for this will be useful - and all...

I find this a bit amusing - you ask for help, we give you some and we point you to...

what type of files you talking about - if SQLProjs then SSMS works differently from Visual Studio and there is no straight migration.

which one failed?

and did you do

execute as login = 'domainname\username'

SELECT * FROM fn_my_permissions(NULL, 'SERVER');

i've used this with other windows groups only granted to sql and it works fine without the...

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

size of the column

e.g. varchar(xxxx)

so do give the ddl as asked.

that death.location column is bigger than 1k bytes I would assume by the error.

but do give has the ddl for the 2 tables involved.

alongside what has already been suggested (plenty of it and with indication of what how you could/should approach the issue).

hire a rather good SQL Developer to do this for you.

placement of files on physical drives (same or separate) as well as being local or SAN (and type of SAN) as well as being SSD or SATA (and RAID setup)...

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