I assume you replaced the '...' with your own columns :-).

What specific error are you getting?

Yes, you will query back to the original db for the unchanged pages. I confirmed this using BOL as well; from BOL:

"If the page has not yet been updated...

You really should leave the columns separate in the other table as well, but here's how to do the join with the combined column:

SELECT ...

FROM table1 t1

INNER JOIN table2 t2...

TomThomson (3/2/2015)

---

ScottPletcher (3/2/2015)

---

Codd was working for IBM at the time, and IBM asked him to do it. To be fair, a lot of it was not just "ill-conceived". ...

DonlSimpson (3/2/2015)

---

TomThomson (3/1/2015)

---

I'm afraid that...

To keep the optimizer's task straightforward, I would set variables to the desired and end date, patterning the code like this:

--set local variables for start and end date

DECLARE @start_date datetime

DECLARE...

Btw, trigger coding should concentrate on efficiency, not "step by step" coding, something like below. In this case, the code below is probably easier to follow as well.

ALTER TRIGGER...

Check the model db. Maybe the db is being dropped and restored, and thus maybe picking up the values from the model db.

I recommend avoiding % growth amounts anyway,...

As I noted earlier, once you have data loaded you can do:

SELECT *

FROM sys.dm_db_index_physical_stats(DB_ID(),OBJECT_ID('<your_table_name>'),NULL,NULL,'DETAILED')

And SQL will give you the average and max rows lengths for the data you have.

My script...

Jeff Moden (2/27/2015)

---

ScottPletcher (2/27/2015)

---

Jeff Moden (2/27/2015)

---

It's also a bit odd for me to have you tell me not to be so concerned with the speed of imports when you, yourself,...

Jeff Moden (2/27/2015)

---

It's also a bit odd for me to have you tell me not to be so concerned with the speed of imports when you, yourself, have posted just...

Jeff Moden (2/27/2015)

---

ScottPletcher (2/27/2015)

---

Jeff Moden (2/27/2015)

---

ScottPletcher (2/27/2015)

---

Jeff Moden (2/27/2015)

---

......

Jeff Moden (2/27/2015)

---

ScottPletcher (2/27/2015)

---

Jeff Moden (2/27/2015)

---

... at possibly quite...

Jeff Moden (2/27/2015)

---

... at possibly quite some cost if...

You can also use CROSS APPLY to do that:

select VC.COLUMN_NAME,

case when

ROW_NUMBER () OVER (

partition by C.COLUMN_NAME order by

CHARINDEX(',',VIEW_DEFINITION,CHARINDEX(C.COLUMN_NAME,VIEW_DEFINITION))-

CHARINDEX(VC.COLUMN_NAME,VIEW_DEFINITION)

) = 1

then 1

else 0 end

as lenDiff

,alias

,CHARINDEX(',',VIEW_DEFINITION,CHARINDEX(C.COLUMN_NAME,VIEW_DEFINITION)) diff1

...