ScottPletcher (2/9/2016)

---

I've never seen a shop that was afraid to ALTER a table to add/modify a column before, but always preferred to drop the table. Far more chances for...

That would be a great...

ScottPletcher (2/9/2016)

---

Absurd to make a blanket claim about "every page". Increasing from a smallint to a full int requires only 4 extra bytes per row (as I understand it,...

Indianrock (2/9/2016)

---

At this point I think Igor and Sergiy are tired and quoting me sometimes when they think they're quoting eachother. 🙂

RedGate's smart rename function came up with this...

Indianrock (2/9/2016)

---

Thanks for all of the feedback.. I'll check with development to see how large they expect line numbers to get ( I guess the @cap variable was just...

Select @day = max(day1)

FROM table1

WHERE date1 = ISNULL( @date, (SELECT max(date1) from table1))

Igor Micev (2/9/2016)

---

Increasing capacity of a column in table means a split on every page occupied by the table.

Which means effectively doubling the space needed to accommodate the table.

With corresponding...

I must add - after applying those tricks any existing code relying on the current RowNumber becomes irrelevant and needs to be revised.

Hi Indianrock,

I see you liked the horizons opening in front of you. :hehe:

How far numbers of rows for those odd files go over the limit of 32768 the ?

If you...

Igor Micev (2/5/2016)

---

This is not a good thinking. What if you have many schema bound objects with that table?

The advise from ScottPletcher is just fine. Changing from smallint to int...

Hugo Kornelis (1/21/2016)

---

Not true. Without a clustered index (i.e., in a heap), SQL Server needs...

Luis Cazares (2/4/2016)

---

What's wrong with LIKE operator if it does exactly what you're asking for?

SELECT *

FROM #Source s

JOIN #result r ON ' ' + r.column_result + ' ' LIKE '%...

Ed Wagner (2/1/2016)

---

If you implement this is a trigger, which is what it looks like, you'll also want to make sure the trigger performs well enough that if you insert...

I don't think you can change a data type on a column.

It may look like changing a data type from you visual tool (SSMS, I guess), but what is actually...

ScottPletcher (2/2/2016)

---

Give this query a try: I couldn't test it as I don't have data:

SELECT team,sum(ats) as W,sum(atsloss) as L,sum(O) as Ov, sum(U) as Un,

...