Viewing 15 posts - 1,456 through 1,470 (of 3,232 total)
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...
May 4, 2009 at 1:56 pm
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...
May 4, 2009 at 1:38 pm
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...
May 4, 2009 at 12:50 pm
Duplicate thread....please continue here:http://www.sqlservercentral.com/Forums/Topic709419-149-1.aspx
May 4, 2009 at 9:01 am
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...
May 4, 2009 at 8:59 am
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:
...
May 1, 2009 at 1:54 pm
Ah, my bad. I thought the problem was your precedence constraint. You are saying that:
The issue is however, that my variable is never increasing past 0.
What does the...
May 1, 2009 at 1:43 pm
Try just expression instead of expression and constraint.
May 1, 2009 at 1:34 pm
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...
May 1, 2009 at 1:33 pm
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...
May 1, 2009 at 1:08 pm
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...
May 1, 2009 at 1:04 pm
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...
May 1, 2009 at 12:56 pm
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...
April 30, 2009 at 7:59 am
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...
April 27, 2009 at 2:58 pm
Why do you think you need to put common attributes in one table? If I had 2 different entities Person and Building and both entities had an address associated...
April 22, 2009 at 12:39 pm
Viewing 15 posts - 1,456 through 1,470 (of 3,232 total)