Good Job !

Nice article, well documented, good refs.

As documented, the general attitude for FK-indexes sould be : always implement FK-indexes, unless one can prove a particular index hurts, and then...

Sander A. (11/9/2009)

---

.. simply suggesting I should think more carefully about designing my tables is easy to say: The table already existed before i started working here, so i'm just...

please post in SQL2000 forums for SQL2000 related questions.

@@version info does matter !! Please provide it.

- Did you perform any maintenance after the restore ?

- did you update statistics ?

-...

altering float to decimal(n,m) will cause your full table to be rewritten !

Best you can do to take control is - as Gail advised - create a new column (decimal)...

Having installed only the client tools ??

Did you already have a sqlinstance on your pc ?

Having only the client tools, just provide e.g. enterprise manager to be able to...

first of all, comfort the kid ! "Next time, no more luck, perseverance in the sports for the team will do the trick" 😉

I would take the 64-bit offer...

three options:

1) enable that logging into the errorlog (using sqlserver properties in SSMS), import it and filter it. That will nolonger be your first choice !

2) start a trace for...

and with Coalesce you can evaluate n replacement values.

Select coalesce(T.col1, O.colx, T.col2, 'I just don''t know')

from mytable T

inner join myothertable O

on O.fk1 = T.pk

So there must be some truth in it :w00t:

As always in fora, it's nice to get something confirmed, if possible even more than once.

32-bit always behaves like 32-bit... even on 64-bit.

So, the same rules apply for every 32-bit software.

If you can, install 64-bit software to overcome all 32-bit related problems.

32-bit uses WOW (windows...

- "exec sp_configure " will show all available configuration parameters.

Keep in mind you may need to activate "show advanced options" to get to see all parameters !

- Check books...

Very nice example, Dave !

Straight forward and very to the point !

Also have a look at one of the previous headlines of the daily newsletter:

"T-SQL Best Practices – Don’t Use Scalar Value Functions in Column List or WHERE Clauses"

http://www.sqlservercentral.com/redirect/articles/68642/

I've attached a little primitive example that may get you started.

Run this using SQLCMD or using SSMS in SQLCMD mode;

I did put my scripts at c:\SQLCMD

-- write the output to...

No that is not an issue at all !

Create a script for each...