We  have an Access front end with a SQL Server backend.  We have inventory that we need to scan and keep track of.  Is there a way to scan...

Getting back to the original post... you do know what sys.dm_db_index_physical_stats() is for, correct?

Dear Jeff Moden,  thank you for you kind help!   what you said is quite right.

if I ran it on the same server, sometimes it works fine, but sometimes not...

thank you Jeffrey Williams, the table has clustered index,  but  when I used "alter table oldtable rebuild" , the table released a lot space, many thanks!

when I did this...

Thanks for the reply, Stephen.  You should keep track of how things go along the way.  This migration would make an awesome article .

I'm having the same problem time-wise.  As the old saying goes, "So say we all". 😀

I also have to admit there's great incentive in learning something new if...

Jim,

Only you can answer a few questions about your article that have been nagging at me because I'd like to do some extra testing by setting up some test data.

You...

I've worked on a big personalisation project that produced a distance score between 250,000 products for 5 million customers.  That was 1.25 trillion records generating 37TB of scoring data.

The...

I'm having the same problem time-wise.  As the old saying goes, "So say we all". 😀

I also have to admit there's great incentive in learning something new if you MUST...

My recommendation  would be to read the documentation for BULK INSERT, which is located at the following URL:

https://docs.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver15

The two keywords to search for in that article are...

As much as I deplore the use of Cursors and While loops, I have to agree with JediSQL... sometimes there actually is no other way.  You probably won't ever see...

Way to go, Grant!  I'm still learning new stuff about T-SQL and SQL Server. 🙂

And good article although I do have a couple of black eyes from beating myself up...

I'm just curious... what are you going to use Snowflake to determine?  Or is this one of those things where they might yet be sure but will do more with...

The...

I suggest there's more that could have been covered here, for example:

1. Create a temp table having just the ID of the records to be deleted.
2. Delete the records...