Good old reboot for the win.  How long had it been since your last server reboot?

Heh.  I guess I wasn't too clear, I was just sayign that I like the format to have the "table1" from the left join on the left side of the...

Yes, the procedure cache holds compiled plans, exec plans, algebrizer trees and extended procedures.  You can use DBCC PROCCACHE to see more info about what is there.

Number of pages in the procedure cache that currently are allocated to this process. A negative number indicates that the process is freeing memory allocated by another process.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/60a36d36-54b3-4bd6-9cac-702205a21b16.htm

I believe you can do something to this effect using that same query, but adding a PIVOT.

I don't have the time to get the query working, but you can find a...

Congradulations!  How long did it take you to study/complete the exams?  I am thinking about starting the track.

Ben,

On your table joining formatting, I find that I do it just the opposite. Mine usually look like

SELECT

      *

FROM

      TableA

      INNER JOIN TableB ON TableA.Key = TableB.Key

I like doing it this way,...

If you are getting the 2000 IDs that you want deleted from some sort of query, you would use:

DELETE FROM Table_Name WHERE ID IN (*Query you used to pull the...

I got the same error the first time I tried to deploy my RDLs to my local instance of SSRS.  The problem was indeed under my Project properties, I did...

I am glad someone knew.  I have been racking my brain, google and BOL for some sort of answer.  The only thing I found was a description of the fields...

It is definately hard to tell if your needs will be supported at 512MB of memory since we do not know how the application/load will impact the server.  Running performance monitor...

@kevin

I see what you are saying about the multiple names in the table, I feel like we are not seeing the entire extent of the data/design, or the...

Well, first you would need a key in both tables to link those peices of information together.  From what I can gather, these would have foreign keys from a table...