no. not the best way, neither the minimum access - its more like FULL access.

grant control on a table is a SUPER SET of permissions that include ALTER (which is...

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

you may be right - issue here is that the process is backing up all databases and outputting all commands to log - and it shows truncated.

so backup would have...

if you go from Access to SQL and with 8 users you most likely will be able to work well with a 2 vcore and 8-10 GB ram - won't...

date(o.created_datetime)

change to

convert(date, o.created_datetime)

if(od.amended_quantity is not null, od.amended_quantity, od.quantity)

change to

case when od.amended_quantity is not null then od.amended_quantity else od.quantity end

regarding "and date(o.created_datetime) >= '2020-04-01'" - this should be changed as using...

attach that as an image or text and someone may be able to help - and do explain what you trying to do

try values instead of value

FacilityID - Decimal (12, 0) - takes 9 bytes - better to use a bigint - 8 bytes so I would look at this particular column to see...

thats all pretty and so on. but what tests did you do so far - and what was the performance difference between loading the data onto that table

...

look at this http://bilearninghub.blogspot.com/2018/05/format-date-in-ssis-mm-dd-yyyy-or.html

RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , getdate() ), 2) +"-"+RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , getdate() ), 2)+"-"+(DT_STR,4,1252)DATEPART( "yyyy" , getdate() )

as you are doing a bit of calculation...

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

thats all pretty and so on. but what tests did you do so far - and what was the performance difference between loading the data onto that table

• table with...

you are the one that needs to figure that out for your own environment. test test test.

Hi folks

I can't find anywhere else to ask this, so here it is. SQL Server 2017 Standard Edition is restricted to 24 cores. Does this mean that the...

please don't post same issue twice.

original thread here https://www.sqlservercentral.com/forums/topic/msg-537-level-16-state-3-procedure-recover_truncated_data_proc-line-113-inva

Ratbak already gave you a indication of what you should do - what did you find so far after following those instructions?

that is where some disagree.

on my 1500 production db's 220 have RCSI enabled - and most new db's are being created with it enabled unless the team requesting it ask...

with that server I would change maxdop to 8 (and try out other combinations - 4 6 12)

and CTFP change to 50 - never below 25 unless fully tested and...