just a short list:

- Gut feeling is not to install any datafiles in program file folders

- stay away from the boot drive or paging file drive with any datafiles

- What's...

in many cases the [not] exists with a correlated query will outperform a

left join with the where rightpart-table-column is null because

a [not] exists is performed using the (fast)...

no.

If you install a default instance, its name will be the servername

(servername\mssqlserver)

You can install a named instance without having a default instance.

BOL states:

Scanning Modes

The mode in which the function is executed determines the level of scanning performed to obtain the statistical data that is used by the function. mode is specified...

- Can you post the ddl (sql2000 and sql2005) ? (tables/indexes/views)

- What's the reason the result sets are different ?

- Can you rewrite the query to a :

SELECT HWID1, HWID2,...

In that case, no doubt about it. use the guidance Vijaya Krishna has given.

And as said, restrict it's values with a constraint !

I'd go with Jeff's reply !

Also make sure the sqlserver service account has the needed rights to

the new drives and folders !

Many developers use nulls because the don't know what data is needed.

The simple question "does it matter if there are spaces or a zero if you didn't get the value...

- did you check with sql2005 upgrade advisor ?

Should be your starting point for any preparation towards SQL2005.

- In BI-dev studio (vs2005) if you create a new bi-integration server project,

there...

percentages, seems you're going to calculate with them, so _must_ be a numerical datatype.

I would store it as decimal (3,2). This way you can avoid the division by 100 .

If...

did you move database files ?

If you don't specify fillfactor, sqlserver just rebuilds using the formar fillfacor.

To view the fill factor value of indexes, use the sys.indexes catalog view.

I strongly suggest NOT using hints in views !

That may prevent optimal paths when used with other queries !

Rewrite your query to e.g.:

SELECT SiteIdx

FROM v_Network N

WHERE exists (Select...

So is your #tenuot being altered by s_tenuot_base_r in some cases ?

maybe even a sp_updatestats and dbcc updateusage(0) with count_rows will correct the figures you get from the query.