There's no built-in function that does that. However...

Itzik, in his PASS precon, showed a cool trick for faking one using some highschool maths.

LOG_x(a * b * c) = LOG_x(a) +...

Paul Randal (12/2/2008)

---

Without backups, this is going to be hard to get rid of - repair cannot fix this so your only options without backups are to migrate all schema...

Jeff Moden (12/2/2008)

---

I had several folks say they were Ninja's in SQL Server and one even claimed to be a "9 out of 10" right on his resume......

Study for the SQL certifications.

Note, I did not say write and pass them. I said...

No way to ensure that with a float.

Change the data type to one that is precise and accurate.

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...