Viewing 15 posts - 16,921 through 16,935 (of 22,219 total)
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
If you want to view the cause of a lock, query sys.dm__tran_locks.
"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:36 am
BTW, This is a cross-post. I answered the same question over here:
http://www.sqlservercentral.com/Forums/Topic757335-145-1.aspx
Please don't post the same question in multiple locations. It really diffuses the conversation and duplicates effort.
"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:35 am
Viewing 15 posts - 16,921 through 16,935 (of 22,219 total)