Yeah, I'm with Gail on this. I spotted the one issue, but I'm pretty sure you have others. But working off this vague set of descriptions the best I can...

Hmmm... Not crazy about that approach in the script. Allen White has a script he uses to do the same thing. You might search his blog. I'll bet it's more...

All the memory is not too much. SQL Server has limits to the amount of memory it can use. You can see that here in the documentation. You'll want to...

You don't have b.Rank as one of the columns defined in the SELECT list that you're selecting from.

This is not a good practice, for some of the reasons you're hitting...

george.auckland 44813 (3/13/2014)

---

I did that. Here is the full function (Thanks for your help by the way):

USE [CTM_Reporting]

GO

/****** Object: UserDefinedFunction [dbo].[ufn_Banner_Orion_Employee_Comparison_parser_v2] Script Date: 3/13/2014 11:57:36 AM...

You have to build the string. Just referencing the parameters won't work.

I'd suggest trying some indexes on the table and using a JOIN to do the UPDATE.

You have parameters that you're passing values to and then those parameters are used in your SELECT statement to return the values passed. That's how parameters work. What you're...

It's a security error that's basically preventing you from making a series of calls to the OS. To run it, you have to do what it's asking for.

This is a VM running on Azure, which means, technically, the HyperV hypervisor although things are a little different...

Fine, but where is it coming from? It's not a part of the query as outlined, so is that thing...

Text plans... blech!

Anyway, like I said, you're getting a scan because of the function:

[SCM].[MEAS_VALUE]<>-1 AND [SCM].[COL3]&239=0

The other two scans are not as obvious. For example, this one:

[M].[COL4]>=0 OR [M].[COL4]=-2.01019e+009

It's...

I'd love to see the execution plans, but this little critter is going to prevent index use:

and ((c.col6 & 0XOEF) =0)

That's going to lead to scans, all the time every...

If you have an account that has access to all the file shares that your backups are going to, you could use that account to run a powershell or batch...

Never heard of it. But my response to one these is always the same, "Cool. Awesome. Can you show me a recovery to a point in time?"

If they can do...