Have you fully verified no changes were made to either server environment? (I'm assuming it's two different servers: one for SQL, one for Ingress. Correct me if that's...

Which means there's some hidden difference between the two....

You're welcome.

Have you tried a UDF instead of an SP for this? Might be easier.

Like so:

IF OBJECT_ID(N'dbo.XMLTest') IS NOT NULL

DROP FUNCTION dbo.XMLTest ;

GO

CREATE FUNCTION dbo.XMLTest...

Definitely don't copy and paste it into a script!

What you probably want to do is create an SSIS package that will use a For Each Loop to step through each...

When you call the query directly, are you using the same variable values as the values assigned to the parameters?

Kind of left guessing here because of the lack of ability...

Also, is this a one-time thing, where it was slow/failed one night, or did it start being consistently slow a few nights ago and is staying that way?

If it's running...

Have you check the database and server logs for any unusual changes between the most-recent fast-run and the first slow-run?

I'm not familiar with administering Ingress, but most data systems log...

There may be a better way to get the server name, but the way I do it is run an SQL task and query @@SERVERNAME, then store that into a...

Here's what Microsoft has to say.

Licensing by computing power - Core based licensing

With the release of SQL Server 2012, the licensing for computing power will be core-based.

Enterprise and Standard will...

I formatted it. (Or, more precisely, RedGate SQL Prompt formatted it for me.) Didn't see any problems or get any errors.

Then I had SSMS parse it. No...

anthony.green (6/7/2012)

---

GSquared (6/7/2012)

---

Again, this is just my take on the whole mess:

You might be better off on a per-processor license. 2012, if I understand the licensing correctly, has a...

Good editorial. Important point, well-expressed.

Again, this is just my take on the whole mess:

You might be better off on a per-processor license. 2012, if I understand the licensing correctly, has a per-core license...

There isn't one built in, but a date-check regex should be easy enough to build into a script component. Bing/Google/whatever, ".net date regex", and you'll find several samples pretty...