Try to put your data...

You should never write a trigger assuming only a single row gets inserted.

You cannot control which queries will be executed against the table, so make sure your triggers are done...

Here is the quickly baked test script:

DROP TABLE TestCalendar

CREATE TABLE [dbo].[TestCalendar](

[ID] [bigint] NOT NULL,

[N_Date] [datetime] NOT NULL,

[WeekDay] [smallint] NULL,

PRIMARY KEY (ID) WITH FILLFACTOR = 100

)

CREATE TABLE [dbo].[Tmp_TestCalendar](

[ID] [bigint] NOT...

Igor Micev (2/9/2016)

---

Not so different from my approach. I make a column drop and rename, and you make a table drop and rename. The prepared dependencies goes for creation after...

With my approach?

No.

Read it again:

1. Create a new table with desired table design.

2. Start populating the new table with portions of data...

Yeah, right.

I once disabled an index which was a duplicate of another one and was only taking space without any benefit (as I thought).

Hours...

That alone would be enough to see your stuff packed in a box.

Igor, all your suggestions may be good for...

Yep. That's it.

Simple and flexible...

Indianrock (2/9/2016)

---

Unless you expect your database to remain small, the lesson seems to be make your data types large enough for the next 10 years, not for the next 10...

Igor Micev (2/9/2016)

---

I don't say Sergiy approach is not going to work, but it's more risky. Simply you can do it without dropping the table.

-- Steps:

-- 1. Script the Drop...

sqlfriends (2/9/2016)

---

It looks now the best option could be using to create a noteTable for each business table that needs note.

Let me think about more, and may come back with...

Sergiy (2/9/2016)

---

Or you may wish to create...

Or you may wish to create a...

http://www.sqlservercentral.com/Forums/Topic875968-391-1.aspx

GilaMonster (2/9/2016)

---

The CTAS statements will be executed one after each other. T-SQL is synchronous in terms of statement execution. Each one may run in parallel depending on the distribution of...