Roy

The concept of using an upsert is interesting. What if the update failed and the insert was executed instead? Then you would have the same read profile whether...

This will get the maximum possible rowsize for the employees table in the pubs database:

select sum(sc.length)

from sysobjects so

 join syscolumns sc on so.id = sc.id

where so.name = 'employee'

 and...

You guys all have it wrong.  The answer, option D, is abolutely correct.  What is wrong is the question.  The question should have read:

What does this return?

SELECT sin(1.5575191894826692)

and if...

I know, people who complain about the QOD need to get a life, but...

This would likely have returned a mask of 0x4000 since a DBA ran it and would have...

Datalength(expression) will work to determine the size of the data in a row.

Datatype is stored in 2 bytes, but only once for each column.

For var* and nvar* data types, actual...

As always, to each his own.  The code in the view does have to change, and it often has to be different from environment to environment (an often dangerous practice...

I prefer to use a linked server.  This method is the most flexible and supports multiple environments (dev,test,prod).

You imply in your article that the linked server name must be the actual...

Very poor question.  Undocumented useless join option.

By process of elimination, I thought the cross join would have been an answer, only the author left off the where clause.  The following...

None of the answers were axectly correct.  sp_who actually execs this sql when loginname param is null:

select  @spidlow =     0

  ,@spidhigh = 32767

/* loginame arg is null */

select spid,

    ecid,

    status,

       loginame=rtrim(loginame),

    hostname,

   ...

Depends on what you are after.

select datalength(col1) from document

Will return the actual length in bytes of each individual row.

select sum(datalength(col1)) from document

Will return the total bytes used by that column...

What if you aren't developing in Java?  Another poor question without enough information to come to the correct answer.  "You are a UNIX developer.." certainly doesn't imply you are using Java! ...