you should know better by now that such a basic question without some google investigation is not getting you nowhere fast.

lots of info about that subject already that you should...

could you post a link to that book - that used to be something that applied only to tempdb files, and even that is really a myth.

see https://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core/

for most cases...

first I hope you aren't doing those inserts one by one - if so change it so you work with sets not with a record at the time

in order to...

have a look at https://www.php.net/manual/en/function.sqlsrv-prepare.php

or https://docs.microsoft.com/en-us/sql/connect/php/sqlsrv-prepare?view=sql-server-ver15

different functions than the one you gave the link for - this may work for you

did you try

$spSQL = "exec p_1A_insert ( ?, ?, ?, ?, ?, .....

$storedProc = sqlsrv_query( $queryLink, $spSQL, $spParams );

or

$spSQL = "exec p_1A_insert @parametername1 = ?, @parametername2 = ?, ?, ?,...

in 2016 they work fine - I have a DB where most of of the tables have a CCI's and no issues with them.

but in compat 2012 .... test it...

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

Mike - this is shown on this site - not on any email I get

google for "winevents load to sql server" and you will find a few examples of how to do it

I do think it is very clear that it is free. And it is the vendor you should be asking in the first place.

https://zappysys.com/products/ssis-powerpack/compare/

you have the wrong order there

and 2 servers mean 2 different ip's and 2 different names so they can be alive at same time.

keep old server with old name

1 -...

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

you need to use the output clause

With ProductName(ProductID, Description)
AS
(

    SELECT ProductID, ProductName
    FROM dbo.Products

)


INSERT INTO ProductName     ...

Having said this in my shop some of the teams do do some level of code review - and...

ahhhh... who will code review my SP with 10k lines ..

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

could be a bug - but it is also how ADR / PVS works.

look at the troubleshooting section of https://docs.microsoft.com/en-us/sql/relational-databases/accelerated-database-recovery-management?view=sql-server-ver15 - DMV's will probably help you determine what is causing...

you will need mapping tables for sure - with source ids and new id's

how many will depend on your system.

so initial migration step is to do the "base" tables e.g....