DMA issues SQL calls to the database. You can view currently executing SQL statements on SQL Server with the following SQL:

SELECT sqltext.TEXT,
     ...

If migration would only take 2 hours and they only want read access during the conversion.

1. Make the system so it can only read the database.
2. Take a backup
3. Restore...

Another possibility is that the SQL is written in a sub-optimal way. Rewriting the query might allow SQL Server to chose a better execution plan more easily. If you want...

Apologies, i got mixed up, i remembered that if a table is referenced by a FK it cant be truncated, but thats not the case here, so yes, truncate...

IF OBJECT_ID('tempdb..#gifts_to_give','U') IS NOT NULL 
    DROP TABLE #gifts_to_give;

SELECT * 
INTO #gifts_to_give
FROM (VALUES
(1, 5, 'luis', 'Barcelona'),
(2, 3, 'pedro', 'Albacete'),
(3, 10, 'Antonio', 'Madrid')
) T(Id_give, number_of_gifts,...

Do you mean literals not laterals?

The query with parameters will have a compiled plan that it reuses, so it looks like this plan is a better one than the one it...

comment deleted

• This reply was modified 6 years, 11 months ago by Jonathan AC Roberts.

Looks like it might be some  Oracle SQL.

You can get the table names from INFORMATION_SCHEMA.TABLES

DECLARE @myCursor cursor;
SET @myCursor = cursor
FOR SELECT t1.TABLE_NAME, 
           t2.TABLE_NAME
...

Have you tried upgrading the files that have been converted to 2013 to 2014 instead of directly migrating the 2008 files?

select convert(decimal(9,2),100*(convert(decimal(15,4),24698891))/convert(decimal(15,4),39552506)) Percentage

I like to think of it as...

Emph mine...

ANSI-89 style may have been a standard back in the day, but has long been supplemented. In fact it returns incomplete sets. There used to be a page...

SELECT LEFT(SCHID, x.Pos - 1) [Id],
       REPLACE(SUBSTRING(SCHID, x.Pos + 1, 8000),',','|') [AdditionalIds]
  FROM #X1
 CROSS APPLY(VALUES (CHARINDEX(',', SCHID))) x(Pos)

I think it actually increases fragmentation, because records are typically added in increasing date order rather than decreasing date order.  It improves efficiency, because the index is organised in...