Francis Yee-483501 (11/13/2009)

---

I learn from a site to get the row count of table(s) by NOT using count(*) but instead of using

" SELECT rows FROM sysindexes WHERE...

Haven't seen any performance problems.

GDI Lord (11/13/2009)

---

Thanks Gail, thanks Lynn.

Lynn Pettis (11/12/2009)

---

If X5 only has the values 'A' and 'B' why are you testing for these values in the WHERE clause of your query?...

GilaMonster (11/13/2009)

---

Bulk insert, bcp and SELECT INTO are all minimally logged if the database's recovery model is something other than FULL. There are other limitations, check Books Online for the...

Any way you do it it has to be logged, there is no way to turn it off. The best thing you can do is to perform the insert...

No idea. It is your data, you have decide if the data can be modified or not. If not, then you will have to go with a larger...

Here is the problem, you are going from this:

123456789.01

to this:

12345.678901

Unless you are absolutely sure that no values in this column is greater than 99999.99, then what you may need to...

Try changing it to DECIMAL(15,6) instead of DECIMAL(11,6).

Double post, please reply here.

Jeff uses it when creating his million row test tables.

Please show your code. A little hard to help when we can't see what you've done.

Alvin Ramard (11/12/2009)

---

CirquedeSQLeil (11/12/2009)

---

Alvin Ramard (11/12/2009)

---

At first I thought...

I wouldn't. Seems like a general observation that I would actually agree with. 😉

Two things.

First, based on the data provided, what is the expected output from the update?

Second, could you please show us what you have done so far to solve your problem?

Funny, but when I compare the execution plan of...