So, you're looking for the number of commands SQL Server has processed between StartTime and EndTime? How does this help you?

It may not be a length issue at all. Have you checked that the design of the report doesn't exceed your normal page width? A little wide can produce an...

Thanks, Lowell!

I was too lazy to test it out myself. Just wondered if anyone knew off the top of their head.. lol

At this current position we use SSMS mostly, though some of the developers use SQuirreL for query design etc.. The application itself is written in java using hibernate.

lol.. That's why I asked, Lowell. If it's done in memory I was wondering if the internal mechanics of string comparison using LIKE would out-perform the substring-string comparison or are...

See if this helps you at all. It's a white page for SQL Server 2008 comparison between Standard and Enterprise featuresets.

http://www.google.com/url?sa=t&rct=j&q=compare%20sql%20server%202008%20enterprise%20vs.%20standard&source=web&cd=1&ved=0CF0QFjAA&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F2%2FD%2FF%2F2DF66C0C-FFF2-4F2E-B739-BF4581CEE533%2FSQLServer2008EnterpriseandStandardFeature%2520Compare.pdf&ei=ILciUL39DaTL2QWzn4GADg&usg=AFQjCNEKWvM9ENvIXf9_cahdywmOgv11HA

is there a significant performance difference between the above snippet and something like

Warranty1...

Just a thought: could you make DB1 and DB2 part of a cluster and then replicate merge outward from there?

The easiest, though probably most annoying, solution would be to shut down SSMS, if that's what you're using to implement your query tests, and restart it. Changes to databases don't...

I was going to add that when I run into import errors from files of that type I generally load them up in Notepad++ and bring all the codes out...

I'm using the loop container now. The process takes a variable time between 10 and 20 minutes per iteration and I'm looking to minimize the time between iterations with a...

Thank you, everyone, that was the solution I was looking for.

Donalith

Thanks, Steve, I'll take a look.

The variables are at the package level so that shouldn't be an issue.

Donalith

Thank you, I will take a look.

Yeah, that's what I've been getting into lately.

Thanks folks.

Donalith