You would think there would be.. I just try and avoid it altogether..

CEWII

Thats ok, I've done this in a lot of different ways, I just didn't want to get stuck on a single solution..

I like parent package variables except they are a...

I don't think I agree about testing. Trying to manipulate a command line to pass to another seems to be pretty problematic..

I understand the stand-alone aspect, you could certainly...

It is a start. You might want to screen print the output from a "Include Actual Query Plan". I'm interested in the access method of the LIKE operation,...

I am not sure how to get around this the way you've done it. However, I have an alternate way, why don't you write the command into a table...

Space is not valid for that datatype. you could replace it with a NULL, or you could change the datatype to a character type. But space isn't going...

What is the desired datatype of the end-result? Also what is the datasource?

CEWII

Per the query plan how is the LIKE operator being accomplished? What operation is it saying?

CEWII

I am absolutely on-board with getting technical metrics. Without them there is really no way to diagnose what the problem here is.

I did get to thinking about foreign key...

As far as C. there have been a number of posts here previously explicity asking how to limit a login to an application. I make a bit of an...

GSquared (2/23/2010)

By derivation, a "geek" is...

I think RBarryYoung is on the right track, what you are describing isn't so much as blocking or locking but that other queries are fighting to just complete. That...

First thoughts were related to indexes, have they been re-indexed lately? Also was the server "cold" in that it had been recently restarted? Also does the SQL Server...

Yes, nerds NO!

I have a shirt that proclaims "GEEK" accross the front, just so there is no question..

CEWII

Basic troubleshooting..

Can you reach the server ip address and port from that machine?

If not then there are a multitude of possible causes:

1. Local Windows firewall dropping traffic.

2. Your companies firewall...