santhoshkumar.boregowda (12/2/2008)

---

Thanks Gila,

Actually these types of result are affecting the production in one or other way.

some batches will be having a query like

WHERE col = '0'...

You're not getting a junk value, you're getting a value very close to 0. -2.7465348468E-13 is scientific notation. Expanded out it's 0.000000000000227373675443232

Float's aren't accurate data types. They're approximate and rounding...

As I said, firstly, the growth should not be 10%. That's a bad default and it gets out of hand on larger databases. Change it to a fixed size (depending...

jeffkretz (12/2/2008)

---

I think a lot of people do that or do a full technical interview before the...

Grant Fritchey (12/2/2008)

---

, OK, changing data can change statistics, so where the statistics are maintained can be changed, and if you have indexes on the columns that you modified or...

Two things.

Autogrow should not be left on a percentage (the default) as that causes massive grows for larger databases, with the resulting time problems and poor performance during the grow.

You...

You could. I had this nasty mess on my hands once on SQL 2000.

SELECT SomeColumn, CONVERT(varchar(20),SomeDate,107) AS SomeDate

FRom SomeTable

Order By SomeDate

The ordering came out with April first.

Paul Randal (12/2/2008)

---

Hmm - I don't think the corruption was in the nonclustered indexes - I think the corruption was (and still is) in the base table itself.

Of course,...

Could you post the complete output of checkDB please, with all of its errors and recomendations.

Was this DB upgraded from SQL 2000 and how long ago was it upgraded?

Grant Fritchey (12/2/2008)

---

Clarification: "Column aliases in ORDER BY clause cannot be prefixed by table alias"

Sorry. What I said earlier was misleading. Also, on rereading, I'm not shocked that this doesn't...

scb (12/2/2008)

---

Say for instance that you have one particular table that is huge and filling that drive. Say it's referenced by 5 stored procedures. Assuming there are minimal...

I have no idea...

I just have him as my cell phone ring tone...

No. 3gb and AWE are for 32 bit only.

A separate one. Backups onto the same array as data is firstly an eggs...

The query I posted runs fine on 2005 SP2 and 2008 RTM.