Viewing 15 posts - 16,921 through 16,935 (of 22,221 total)
If I understand the question, you do need to make sure that the statistics are updated on the second database. usually just leaving the auto update statistics set to on,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2009 at 8:09 am
I agree with Jeff. In a small shop, you have to cross the lines, a lot, but the fact is, it's your job to work together. That's it. End of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2009 at 8:03 am
Hey Gail,
Being completely clueless as to facts on the ground, I have to ask.
There was a report on the radio of very severe rioting in SA. You OK?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2009 at 7:58 am
I'm sure they occupy a little, but not anything to worry about.... unless you're declaring thousands of them or something.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2009 at 7:45 am
sqlrumble (7/23/2009)
I've looked around but was unable to find recent comparisson reviews off SQL Monitoring Software.
I've been asked to review SQL Server Monitoring software. Our instances are a mixture...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2009 at 7:37 am
CodePlex is where Microsoft publishes the databases. If you get it from any other source... it might not be what they say it is. I'd stick to CodePlex.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2009 at 7:31 am
Could you post the actual execution plan?
I suspect you're missing an index,but it's also possible that, without any thing to filter that table, you're getting a scan.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2009 at 7:15 am
You may be able to see it in the Schema Changes History standard report.It only shows changes since the last time the service started.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2009 at 7:12 am
Locking is a natural and important part of updating data in SQL Server. Intent locks, and others, should be reduced as much as possible, but they can't be prevented or...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2009 at 6:29 am
The code is almost always relevant to the problem when we're talking about TSQL.
As several people have pointed out, depending on what was referenced or how things were referenced in...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2009 at 5:35 am
The overviews will barely get your feet wet. It's a hard thing to learn, or least I've found it to be so far.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 22, 2009 at 12:12 pm
Not a problem.
Another option, and it might not work for you, is to pass these values in a comma delimited format and then join against that single variable using a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 22, 2009 at 9:49 am
. (7/22/2009)
Steve, if you would prefer I didn't go forward with...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 22, 2009 at 9:46 am
It could work, but you're going to run into a lot of issues, possibly. Do you have source control available? If not, get something like Microsoft's Team Foundation Server or...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 22, 2009 at 9:44 am
Are there functions in the WHERE clause?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 22, 2009 at 9:39 am
Viewing 15 posts - 16,921 through 16,935 (of 22,221 total)