Viewing 15 posts - 13,141 through 13,155 (of 22,219 total)
The log file grew that large while you weren't backing it up. Just because you're now backing it up doesn't mean it will shrink. Instead, you'll have to do 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
February 24, 2011 at 8:22 am
Do not pile on to this one, please. I just thought I'd point out where I was bad. That one really yakked me off. Again, no need for a pig...
"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
February 24, 2011 at 7:06 am
Excellent catch.
Seriously? You want us to do your homework for you? Can I walk you home from school if I do?
If you're stuck on some aspect of this, please ask...
"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
February 24, 2011 at 7:04 am
Bungholio (2/24/2011)
Grant Fritchey (2/24/2011)
sql_butterfly (2/23/2011)
Thanks Grant. What should be the generalized fillfactor for indexes on OLTP tables ?
I agree with Mr. Holio, or can I call you Bung? It depends....
"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
February 24, 2011 at 7:00 am
Whoa, that's a lot of information. To reliably gather the statistics, you need to write the queries that put those statistics together carefully so that it uses indexes and...
"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
February 24, 2011 at 6:48 am
sql_butterfly (2/23/2011)
Thanks Grant. What should be the generalized fillfactor for indexes on OLTP tables ?
I agree with Mr. Holio, or can I call you Bung? It depends. In general, I...
"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
February 24, 2011 at 6:24 am
You'll get a lot more responses if you put up a post like this as a seperate question rather than posting it on top of a different question. Technically this...
"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
February 24, 2011 at 6:20 am
In addition to all that excellent informatoin, don't forget that you may also have deal with resource contention, assuming this is a production system.
"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
February 23, 2011 at 12:09 pm
If you are seeing a consistent disparity between SSMS and the app, check the connections settings to validate that the ANSI settings are the same between both. These can affect...
"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
February 23, 2011 at 12:06 pm
glennhill (2/23/2011)
Thanks for the reply. I was using term "deadlock" loosely. There was no internal deadlock detected by SQL Server but we did indeed have a blocking chain and...
"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
February 23, 2011 at 9:21 am
When you say deadlock situation, do you mean that you hit a deadlock error with one process chosen as a deadlock victim?
Or do you mean that you had a blocking...
"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
February 23, 2011 at 8:27 am
When you say reindex, is that an index defrag or an index rebuild? You'll get less de-fragmentation from the defrag than you do from the rebuild. But also, as was...
"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
February 23, 2011 at 8:14 am
You might want to take a look at this blog entry[/url]. It addresses exactly what you're talking about.
"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
February 23, 2011 at 6:17 am
The first thing that comes to mind is merge replication. Have you looked into that? It's hard to set up and administer, but I think it does what you need.
Other...
"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
February 23, 2011 at 6:15 am
sql_butterfly (2/22/2011)
Hello Friends, Can anyone help me with the strategy to make indexes on OLTP tables ?
That is a gigantic topic and really completely depends on the tables in questions...
"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
February 23, 2011 at 6:12 am
Viewing 15 posts - 13,141 through 13,155 (of 22,219 total)