Sorry Jeff.

I have been working with open query trying to get the values I need for my Insert into Staging Table. The query I have is returning some of my...

I'm having syntax problems doing OpenQuery with pulling values..

DATEADD(s,t_stamp/1000,'1969-12-31 20:00:00') as 'DateRecorded'

In my original query I was using this on linked server

t_stamp >= DATEDIFF_BIG(MS, '19691231 20:00:00', GETDATE()) - (1000 * 60 * 30)) along with the local join..

This is the table name from the Linked Server --          rem.db1.dbo.sqlt_data_1_2021_08

SM_Query_Lookups tbl is on the local server .. The remote server contains all of the values...

• This reply was modified 2 years, 10 months ago by Bruin.

The source table has 2 billion but not all records are chosen since it does a lookup ql.Tag_ID = sd.tagid

Any example of a script to do it in batches of...

Thanks for post.

Thanks Jeff .. by default, will all sorting be done in tempdb during Index creation?

Just so I understand I just need to rebuild Index with:

CREATE UNIQUE CLUSTERED INDEX PK__UserLog__7F8B815172CE9EAE ON UserLog (UserLogID)

WITH (DROP_EXISTING = ON)

ON HISTORY

Thx.

I have 10-15 tables I would like to move to help balance the drive usage on that server. The tables I'm moving are just for reporting by the front-end application.

Thanks.

I had a drive start filling up and it couldn't be expanded... 2TB defined on the backend storage.

I created another 1TB drive and then a filegroup called History and defined...

I was thinking maybe the way to go would be create a new tmp table and transfer the table data from Primary FileGroup to the History in batches say 150,000...

should this process fill up the Transaction Log for the DB if it's set to SIMPLE?

ALTER TABLE UserLog

DROP CONSTRAINT PK__UserLog__7F8B815172CE9EAE WITH (MOVE TO HISTORY)

thanks.

Any rule of thumb to use or steps

Example:

USE master

GO

ALTER DATABASE TestDB ADD FILEGROUP HISTORY

ALTER DATABASE TestDB

ADD FILE

(

NAME='History_Data',

FILENAME = 'E:\DATA\TesDB_2.mdf'

)

TO FILEGROUP HISTORY

GO

USE TestDB

GO

ALTER TABLE UserLog

DROP CONSTRAINT PK__UserLog__7F8B815172CE9EAE WITH (MOVE TO HISTORY)

USE...

Thanks for suggestion. I think that's what I'll do

There's also the concept of keeping only the most recent data on the primary file group, which may require different indexing than...

Currently just one file and the default file group...