have you read the manual?

you already have the sql to execute - you just need to copy and paste the 2 lines and reduce the size accordingly yourself

you were given options and directions on your prior post - what did you do with it and if you did try it what was the result?

https://www.sqlservercentral.com/forums/topic/shrinkfile-option-not-working

and shrinkdatabase is not...

that is a SQL issue - not VS or Schema compare issue.

basically server needs more memory or needs to have less memory allocated to SQL Server - other processes running...

WOW, Frederico, YYY999 as variable names. Yes, at least "VSC" did make sense, given that we worked with a data that was called "Voucher Service Code". The naming convention...

I totally agree, Louis! Once I had a coworker who hated naming anything like VoucherServiceCode. She insisted that all columns in tables had to be abbreviated, so in this...

Why are you duplicating this question? I don't see a link suggesting this is spam, but the answers to that almost identical question are going to be...

error message is very clear - a attempt was done to login to the server with a connection string that is a AD account, but trying to connect as if...

not sure if a TVF would solve this - still worth a try. but try both ways.

regarding the images - I use Plan Explorer from SQLSentry - https://www.sentryone.com/about-us/news/sql-sentry-plan-explorer-free-for-all-users

it is a...

so.. the plan you supplied does not have the MAD percentages / row counts - but it does show, very clearly in my opinion, the issues you have.

So your understanding...

those "mad" numbers show up frequently in certain plans - they should be ignored.

most of the times if you get a ACTUAL explain plan those numbers will be correct -...

regarding the temp folder you missed the point.

Assume a account named "SQLAccount" - your SQL instance runs under this account

this account will have a folder

c:\users\SQLACOUNT\AppData\Local\Temp

the account itself will obviously have...

• This reply was modified 2 years, 1 months ago by frederico_fonseca. Reason: add registry property name

Thanks for this response.  I'm only looking at it because it opens fine on my older server and not on the new one I am building.

I also have a...

you never answered the questions of how you loaded from their system onto SQL Server - neither on how you are extracting it and trying to save to a file...

smells like SPAM - but if not then you can look at this thread https://www.sqlservercentral.com/forums/topic/help-decoding-a-wait-resource-from-sysprocesses

and same questions asked there you can answer as well.