The intention was to know the reason do we need to bother about fragmentation for tables with 10's or few 100's of pages. I see dev team...

getdate will get the current date from the server it is executed on - if you need UTC datetime as part of your processing you need to use one of...

and you have been advised before that if a join does not return the rows you expect you either

1 - don't have the correct data

2 - don't have the correct...

well.. on that case you should not be trusting this site either - garbage can be anywhere.

your solution is to turn, which it seems you haven't so far, to microsoft...

and what have you googleed and read on the documentation about moving datafiles? there are plenty of examples and documentation is rather clear on what to do.

error is likely related to the logon type within the computer itself - a service account used for SSRS needs to be setup "correctly" through the admin pages - not...

a VM is always a VM - no difference from being a Vmware vm, or a hyper-v vm (on prem or on cloud) - its all the same internally.

creating snapshots...

maybe they did it on VS2022 (this is the first one starting to be 64bit) or maybe they didn't use the ACE drive but one of the other ones.

or maybe...

• This reply was modified 2 years ago by frederico_fonseca.

To be honest, I've never needed the 32 bit version and so I've never tried to install it in parallel with the 64 bit version.  That being said, you've...

the first query is running on a loop, executing a series of statements ,including the delete you see. This loop has a outer transaction so until the transaction is finished...

Hi guys, With respect to both replies, I had a question I needed a straight answer.

To clarify, I have a Windows 2019 Server with two 2.20 GHz processors and...

For higher volume stores whose database can't fit within 10GB limit, we will deploy Standard Edition. Obviously Azure SQL would have advantages over on-sight deployments, but the issue is...

on a very busy system those values will cause many jobs to be cleared within hours.

on top of increasing those values (mainly the first one as it is the sum...

• This reply was modified 2 years, 1 month ago by frederico_fonseca.

are you using a ODBC connection setup on odbc32 ? if so ensure it is a SYSTEM connection, not a user connection.

ideally a DSN-less connection should be used if possible...

see https://www.sqlservercentral.com/forums/topic/cant-run-package-via-sql-agent#post-3999259 for an image of how to set the execution to 32 bit.

but I have to query WHY you are using a 32 bit driver on a 64 bit...

• This reply was modified 2 years, 1 month ago by frederico_fonseca.