Nice article. I like Ryan's elegant solution - unfortunately many of our clients are still sticking with SQL 2k (even though they could get by with Express) so I...

Possibly a silly question, but are you sure you are both connecting to the same server? I had a phone call just the other day where someone was connecting...

Could you please post the

* SQL query

* Table definitions

* Examples of some data in the tables

?

Sergiy's correct though, SQL might be creating a temporary workspace to perform the joining of...

Sounds like an assignment question to me If it is, don't be afraid of saying so because then we won't bother...

When you restore with standby, according to Books Online...

---------------------------------

Specifies the undo file name so the recovery effects can be undone. The size required for the undo file depends on the...

That URL link just shows up as HTML (ie, I see the HTML code) to me rather than what I think you expect it to be which is a nicely...

Are you sending this from an application as a SQL query string? If so, you can modify the SQL code to add as many products and locations as needed...

select x, y, z

from (select hos_id, x, y, z from myTable where isNumeric(hos_id)=1)

where cast(hos_id AS int) between @lowValue and @hiValue

To make this quick you could have a calculated field that is equal...

Have you tried the detailed steps here http://support.microsoft.com/kb/934164 ?

Which version of Vista are you running?

The coalesce function will do exactly that.

select coalesce(col1, col2, col3, co4)

from myTable

Although the result will be

abc

xyz

pqr

mno

in 4 records rather than 1 record with 4 fields.

Would that do?

If not, then...

How about

select *

from myTable

order by case when myCol is null then 1 else 0 end, myCol

?

This will order by a function that is 0 when your column is non-null and...

Is it actually the sqlserver.exe process?

Does the activity regardless of the type of queries being sent? Some indices on your tables may help - I would check the statements...

Look at dbcc chekcb in the SQL Server manual (called "Books Online")

OpenQuery does not accept parameters/variables.  You'll need to do something ugly with dynamic SQL for it to work.

EG

set @query = 'select * from myTable where myColumn=''xyz'' '   ...

For more info visit http://technet2.microsoft.com/windowsserver/en/library/86026b03-18b0-4c42-9884-5af83226e2bd1033.mspx?mfr=true

There's a command you can run at the command-line to install all IIS components.