You'll need to set your advanced options for sp_configure to ON for your max server memory values to display.

Also, what version of SQL Server 2000 are you running?

Either way you look at it, SQL Server will perform a table scan because of the %value% search. Here's a way to work it w/o dynamic SQL:

declare @table table...

How much memory is in your server?

What is your max server memory set at (sp_configure)?

What version of SQL Server are you on?

What Server OS version are you on?

What else are...

There are a few performance metrics to watch for that may signify signs of memory pressure and the need for more memory.

1. Buffer Cache Hit Ratio - by far the...

Duplicate thread....please continue here:http://www.sqlservercentral.com/Forums/Topic709419-149-1.aspx

The views won't save you from performing the joins either. They'll just hide the fact that there are so many joins to produce that recordset. Joins aren't a...

I have a package that does the exact same thing. Here's how it is set up:

1. Package does some import stuff.

2. Execute SQL Task checks table row count:

...

Ah, my bad. I thought the problem was your precedence constraint. You are saying that:

What does the...

Try just expression instead of expression and constraint.

I'm not sure what 'best practices' are out there for this, but I agree with your line of thought. I personally would handle this by modeling out the data...

Edit the precedence constraint and set the Evaluation operation setting to 'Expression'. Then use the Expression text box to check your variable value as such: @[User::CheckData] > 0.

You'll...

It sounds like a data problem to me. If the same SP works in 2 of the 3 environments, but not in the 3rd, it's usually data and nothing...

If you don't care which colors are returned, something as simple as this will work:

DECLARE @Colors TABLE (ID int, Color varchar(12))

INSERT INTO @Colors

SELECT 1, 'red' UNION ALL

SELECT 1, 'blue' UNION...

Thanks Phil. I had read through that article as well, but I was hoping there was an easier way to do it through the expression builder.

I had...

I understand the super/sub type modeling technique and I know that it is a valid method for modeling data and that it is used all over the place. I...