Viewing 15 posts - 10,156 through 10,170 (of 22,232 total)
MasterDB (1/24/2013)
If the fragmentation is more than 35% --Rebuild all the indices.
Ask the users about any change of code..? If so, Check...
"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
January 24, 2013 at 8:09 am
runal_jagtap (1/24/2013)
Hmm i have never done Update statistics on Database yet..
Please correct my belwo plan..
Sunday no one wotks on the Database
will perfom the below activity..
1) Full Backup - Using...
"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
January 24, 2013 at 8:02 am
You're really going to need to evaluate each of the tools to see which will do what you need for the money you're willing to pay. 10 instances is 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
January 24, 2013 at 7:22 am
Not a detail I had noticed before. But yes, the shells are there. I recreated Gail's tests.
"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
January 24, 2013 at 4:49 am
SQLSACT (1/23/2013)
Grant Fritchey (1/23/2013)
"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
January 23, 2013 at 11:52 am
Can't see the plan. I'm getting encoding errors. If you save the plan as a .sqlplan file, you can attach it. Then it can be downloaded.
Just on what I can...
"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
January 23, 2013 at 7:03 am
So, instead of 5-10 machines you'll have 5-10 instances? While that makes migration of connection strings pretty straight forward, you might have performance maintenance worries. Instead of a single instance...
"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
January 23, 2013 at 5:43 am
Have you checked the execution plan to see what is being referenced from the query? It might not be using the view at all. Or, it's possible that, despite the...
"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
January 23, 2013 at 5:40 am
Depending on your level, I helped write an introductory level book on SQL Server 2012, Beginning SQL Server 2012 Administration.
"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
January 23, 2013 at 4:41 am
There's a pretty focused set of requirements for forced parameterization to work. It's a lot more expanded than simple parameterization, but it does not include ALL ad hoc queries. Microsoft...
"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
January 23, 2013 at 4:37 am
So you're not changing the basic SQL Server backup process? No worries then. Dedupe is pretty cool technology. More and more use is being made of it.
"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
January 23, 2013 at 4:35 am
Last time I reviewed some of that stuff, the laws in Germany regarding data were pretty good. But, that was several years ago. Things may have changed and the gods...
"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
January 23, 2013 at 4:32 am
This is the first time I've looked for the backup command in sys.dm_exec_query_stats, and you know what? It's not there. So no, I would not say this is a good...
"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
January 15, 2013 at 4:41 pm
Bhuvnesh (1/15/2013)
Grant Fritchey (1/15/2013)
as soon as the data changes or the inputs change, all bets are off.
yes i have also realized that for smaller set , we can see...
"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
January 15, 2013 at 5:12 am
You'll have to change the compatibility level.
"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
January 15, 2013 at 4:37 am
Viewing 15 posts - 10,156 through 10,170 (of 22,232 total)