I'd be more worried about your server shutting down unexpectedly than this message, which is (I've found, anyway) largely nothing to be worried about. It occurs when a calling...

Sorry but you need to give the table definitions and a wider description of what you're trying to do. We don't know from what you've posted what each variable's...

Righto. Thanks for the reply. Trace is going to stop in about half an hour so I'll probably find the file populated with data after that. I...

Heard of a similar issue from one of our BI team, in the end it was to do with a corrupted GUID in the ReportServerTempDB database. Have you considered...

Another link for you using a different method from Grant Fritchley:

http://blogs.msdn.com/b/mvpawardprogram/archive/2012/06/04/using-sys-dm-os-ring-buffers-to-diagnose-memory-issues-in-sql-server.aspx

There's definitely VARCHAR to INT conversion going on somewhere but I can't see it.

And you're definitely doing this in SSMS?

Why would the scope of the SELECT command matter...

OP, please could you actually read the replies to your original post, high memory use with SQL Server is not a problem most of the time, if you want to...

Can you post the structure of the table and the view please.

Sounds like the view is doing an implicit conversion of the VARCHAR column to INT.

Please post structure of both...

Ah well, that's me out of ideas. I thought the problem might be with the way the query results were being passed to the reporting engine.

Are you using a SELECT * in the stored procedure or are you SELECTing each column in a specific order?

I.e.

SELECT col1, col2, col3 ... colN FROM myTable

vs.

SELECT * FROM...

The query you've given doesn't give any detail on the 'empty space' you mention.

How are you determining that the pages in the buffer are empty?

The query given simply gives an...

Smells like spam. Reported.

Check out sys.dm_io_virtual_file_stats (use parameters NULL,NULL) to get an idea of your current I/O performance since the last restart of SQL Server. If you can identify any bottlenecks here,...

I'm b), I'm leaving my current employment in two weeks for a new role. Job stability is really important to me, and like Steve I like to have a...

I like your thinking but would argue that unlike restoring a VM snapshot, replacing large chunks of the binaries, the physical data files, the registry poses more of a risk...