#include

#include

#include /* Microsoft Network Connectivity library */

#include /* For the court of law */

#define say(x) lie(x)

#define computeruser ALL_WANT_TO_BUY_OUR_BUGWARE

#define next_year soon

#define the_product_is_ready_to_ship   another_beta_version

void main()

{

  if (latest_window_version>one_month_old)

  {

   ...

ad 1: SQL Server surely has internally a mechanism to access a row by its physical location. You have to distinguish between two possible cases. A table with only nonclustered indexex...

I find this links very helpful as a starter:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_0m5g.asp

http://www.pcguide.com/ref/hdd/perf/raid/index.htm

http://www.acnc.com/04_00.html

I think your network admin should be able to answer some of your questions, too.

Fixed length --not nullable

--Fixed length nullable

Variable length not nullable

Variable length nullable

IIRC the storage engine will rearrange this for you anyway if you didn't specify it this way. At a cost...

If you don't want to specify the owner of a UDF, the only way around this, is to make it a system function.

How to do this? Read here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01l1.asp

Should...

Sure things, this can hurt performance. Just put this

isnull(rtrim(last_name),'') + ', ' + isnull(rtrim(first_name),'')

in the WHERE clause of a query that runs against a table with millions of rows. I'll...

Shouldn't be too difficult to find out if SQL Server is installed on your machine. Do you have a Start -> Programs -> Microsoft SQL Server menu entry? If so,...

Hm, yes, sure, there might be such valid reasons. However, I guess most of the time it is just laziness or something like that.

Another one would be

http://support.microsoft.com/default.aspx?scid=kb;en-us;186133

Typically real world situations are far more complex. If that is the case see if this helps: http://www.sommarskog.se/dyn-search.html

Charles,

you *can* create indexes on BIT columns. At least with Query analyzer.

create table showme

(

 c1 bit

)

create unique clustered index ci_prettyuseless on showme(c1)

select

 objectproperty(object_id('showme'), 'TableHasClustIndex')

drop table showme

-----------

1

(1 row(s) affected)

,...but...

Wow, thanks, I'm impressed! Think I should take a closer look at this scripting things

Hm, is this for administrational one-time purposes?

If yes, I would say, use a cursor, if no, what's wrong with separated statements?

May I ask why you store numbers in a CHAR(5) column anyway?

Please don't multi-post. Keep this thread in one place. Either here or http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=163847