AndrewSQLDBA (11/8/2012)

---

Update to Original post

I just saw some of the data as only 3 digits. So 499 would need to be converted to 499.00 etc.....

There may also be a...

It depends. Often it's faster just to keep the desired rows rather than delete all the undesired. That is, copy the good rows to another table, trunc the...

There could definitely be some lag.

You can issue DBCC UPDATEUSAGE to force the row count to be updated before you use it.

You're not changing the physical length of the column, so it shouldn't be too bad.

My guess is that logging the change is taking the time.

Try it again in test but...

Something else is going on there. If you...

It will increase the size of the index, but only for leaf pages. The non-leaf pages of the index will be the same size as before.

Jeff Moden (11/3/2012)

---

ScottPletcher (11/2/2012)

---

Given that a clustered index doesn't cost you much space (just for the upper/non-leaf levels of the index), I tend to cluster log tables as well. However,...

I do see one potential valid use for a heap (an unclustered table): as a bulk staging table. That is, if you just need a table to quickly bulk-load...

mmallkc (10/30/2012)

Whenever I try to insert a new record in violation of this constraint, I get an error as expected. However, when I update the table in violation of this...

capnhector (11/1/2012)

---

David92595 (11/1/2012)

---

Can Fields B, C, and D still be manually changed after the fact if need be? or are fields B,C, and D locked as computer values at that...

Haven't a clue. If you get even close, you've got a horrible table design anyway.

Who would ask such a Mickey Mouse q??

You could also use WHERE with NOT:

...

WHERE NOT (

(CARS = 'Volvo' AND Year = 2006) OR

(CARS = 'Buick' AND Year =...

scogeb (11/2/2012)

---

Michael Valentine Jones (11/2/2012)

---

scogeb (11/2/2012)

---

I like to think there is always an exception to every rule. Take for instance a table that ALWAYS has inserts and NEVER has...

I think technically this is the last time the table was accessed since SQL was last (re)started.

/* Author: ScottPletcher */

SELECT

start_date,

end_date AS end_date,

CAST(

DATEDIFF(YEAR, start_date, end_date) - CASE...