Only in SS2K5 can you use the TOP keyword with DELETE.  Wouldn't this work for any version (and still use TOP)?:

DELETE customers FROM (SELECT TOP 10 * FROM customers ORDER...

I've actually been implementing this technique for quite a while in certain situations where the flexibility is necessary to create dynamic SQL.  You also have the ability to create temporary...

I'm confused; is this question about the "Processor" counter in Profiler or the data columns available in a trace?  if the former, the answer is "A", although a little weirdly-phrased...

Hi!  I guess my comments are:

- Named instances listen on 1434 (default on 1433)

- The question was almost misleading, because it sorta inferred that Named Pipes listened on a port...