Hans Lindgren (10/22/2015)

---

In SQL Server 2014 (maybe also in earlier versions) SWITCHing unpartitioned tables is easy.

Example:

(Summary: SWITCHing between T1 and T2)

--Table/Index creation

CREATE TABLE [dbo].[T1] ( [A] [INT] PRIMARY KEY);

CREATE TABLE [dbo].[T2] ( [A] [INT] PRIMARY KEY);

GO

-- Populate some example table data

DECLARE @val INT = 1;

WHILE @val < 100

BEGIN

INSERT INTO dbo.T1(A) VALUES (@val);

SELECT @val=@val+1;

END;

Perfect for a some cases! 🙂