have a look at https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-version-15?view=sql-server-ver15

There are a few differences that can affect performance - you may or not suffer from them as it will depend on the type of usage...

as you were advised on other threads you created here over the last 2 years you either use a third party tool to monitor and log this type of events...

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

sometimes GUI does that - if you can get your hands on ntrights.exe (https://www.microsoft.com/en-us/download/details.aspx?id=17657 try using it

see https://littlekendra.com/2009/11/12/automating-sql-local-security-policy-rights-posh-and-ntrights/

you do need to learn how to read then - it is very clear the steps to do it post install.

To grant an account the Perform volume maintenance tasks permission:

On the computer...

did you follow the instructions here https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-instant-file-initialization?view=sql-server-ver15

If a third-party tool is an option, you can consider using our SSIS Productivity Pack. Within the Productivity Pack, our Premium ADO.NET component will allow you to...

to go from 2012 to 2008 your only option is to recreate the package from scratch.

you can go higher easily, sometimes without even doing a package upgrade, but not lower

have a look at https://stackoverflow.com/questions/6921105/given-a-filesystem-path-is-there-a-shorter-way-to-extract-the-filename-without

from your code above "path" is not a System.IO object but rather a string - so you should even just be getting an error on the...

as I told you above you need to test your system and see if they are required.

Nothing we may say should influence you on that - we may tell you...

google is your friend - sadly most people don't use it.

https://stackoverflow.com/questions/4095627/blank-lines-at-end-of-ssrs-csv-export

Please stop posting  the same question over and over.

you were given the answer before on https://www.sqlservercentral.com/forums/topic/the-tabular-view-feature-is-not-included-in-the-64-bit-standard-edition-of - and as you seem not to like the answer please go and read...

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

That's not really the best way to do it as you have multiple "joins" to the same table when you can do it with a single one

try like this

            
April 24, 2020 at 10:00 pm
            
#3746210

            
            
                                                
        

Hi Frederico Fonseca,

Yes, that might change the collation of my database, but not that of TEMPDB. So any query using a #temp table would need to be checked (and...

Henrik - you can change its collation - just not as easy as doing it on Prem

see https://www.mssqltips.com/sqlservertip/5530/how-to-change-an-azure-sql-database-collation/

could you please explain in more detail the layout of your DV with regards to this transaction data, both hub, links and sats - having their DDL including indexes would...