I'd recommend reading the BOL article on this DMV first:

http://msdn.microsoft.com/en-us/library/ms175019(v=sql.105).aspx

single_pages_kb is one specific type of memory allocation that's actually part of the buffer pool anyway, so you won't see any...

Well, we've both tried to do so, but your question isn't clear. You've stated you're trying to alter a column, but you've...

There are foreign keys referenced in the below script, SSMS just scripts them as ALTERS rather than in-line with the table definition. For e.g. this is a Foreign Key definition:

ALTER...

Also, those two queries don't appear to give identical results. Look at the affected rows and even the number of columns returned from each. What happens in each query if...

Didn't expect NOLOCK would change the plan, it's just inadvisable for other reasons.

What about using ANSI...

It does sound like stats one way or another, but as your non-ANSI joins are not simple equality checks, you could easily end up with a more stable plan by...

Why don't you just set the SSIS package to redirect the error rows in the data flow and dump them back out to a table or file to determine which...

I did a bit of playing around and couldn't get it to work reliably with LIKE, but this worked ok with CHARINDEX:

SELECT acolumn FROM #atable WHERE CHARINDEX(NCHAR(0),acolumn)!=0

While this is technically possible, you'd make life a lot easier by displaying the results from the data source in a Tablix as individual cells then using a basic expression...

Is there enough disk space where the csv file is getting created? That would be the obvious cause of this error message...

tilew-948340 (7/25/2012)

If I understand well, you propose that, not only I would create a function to replace the "max" function but also to replace the computed column? I am...

tilew-948340 (7/25/2012)

If there is no built in...

There's no built in function that gives you the maximum values from a list of column inputs (it's called GREATEST in some languages), you'd have to do it manually with...

I'm pretty sure they're internal use only system procedures that can't be called outside of the context of MS shipped code.

So, no, you can't use them directly AFAIK.

I believe it's because sp_stop_job calls an extended procedure and it can't catch the error to return it to the catch block.

There's a connect bug for it, which lists a...