"Big Win" is a term that has been overused where I work regarding our getting specific data into an expensive reporting system we purchased.

Have...

GilaMonster (5/27/2009)

---

Grant Fritchey (5/27/2009)

---

Actually, I do know of a publisher that tackles those specialized little books. They've put out one on Profiler and one on execution plans. I suspect they...

Are you talking about the "let Me Google That For You" link? Been there, do...

Paul White (5/27/2009)

---

Right then.

Given the wealth of knowledge and talent around these parts, who's up for writing the perfect collaborative-effort book on indexing?

We could all get fabulously rich!!!...

Rod Carter (5/27/2009)

---

Lynn,

I will do both and thank you for your feedback and help to this point. I truly do appreciate it and am not trying to be difficult....

Damus (5/27/2009)

---

GSquared (5/26/2009)

---

Damus (5/26/2009)

---

I agree its a management Issue.

some other things i would like to see:

- real foreach loops through table rows.

- object oriented friendly organization of stored procs and...

arun.sas (5/26/2009)

---

hi Lynn,

CAST(ABC AS DECIMAL(4,2)) AS 'VAT'is better,

but the orignal datatype is Decimal(38,20),

if the value like 99999.00000000, then again the Arithmetic...

I find the critism of a relative newbie who has taken the time to write an article showing people something they have learned a little much. It may have...

OMG, you really have to be kidding here...

Because DECIMAL(2,2) represents a decimal number with 2 positions, both to the right of the decimal.

Please take some time...

It would help if you would provide the DDL for the tables and views (including base tables for the views) involved in the query. Some sample data for the...

Try this:

CAST(IL.[VAT %] AS DECIMAL(4,2)) AS 'VAT'

First, if you haven't already spent your money on VMWare, may I suggest looking at MS Hyper-V? It is free with Windows Server 2008 and will reduce your costs....

Rod Carter (5/26/2009)

---

Does the index have to be unique? The dataset that I am working with holds time data for a whole week for all employees across the company....