Before actually start using partitions, you really need to read technical docs about it !!

If you don't keep the guidelines in mind, you may end up with bad performing objects,...

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