Viewing 15 posts - 9,541 through 9,555 (of 22,219 total)
gary1 (9/17/2013)
I want to update stats that are staled not...
"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
September 17, 2013 at 12:29 pm
There's no direct way to know for sure. You can run DBCC show_statistics and see the date the stats were updated, but that doesn't mean much. Maybe the table hasn't...
"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
September 17, 2013 at 4:06 am
First, stop using sp_who2. It gives you some information, but not enough. Instead, start using the Dynamic Management Objects (DMO). Start with sys.dm_exec_requests. That will basically show the same thing...
"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
September 17, 2013 at 4:04 am
Since the data is critical to the business, I'd suggest two things. First, ensure that the backups are meeting the business requirements. Talk to someone from the business side 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
September 17, 2013 at 4:00 am
L' Eomot Inversé (9/16/2013)
Great editorial, Grant. Five stars from me, because the system won't let me give you six.EDIT: spelling! !! !!! In something this short :doze:
Thanks!
"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
September 16, 2013 at 3:41 pm
carpainter69 (9/16/2013)
This is the only job in the computer industry I've had...
"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
September 16, 2013 at 12:49 pm
Beatrix Kiddo (9/16/2013)
When I run that I get 7 rows back. Is that the sort of thing you suspected?Thanks
Yep. It's as Gail says.
"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
September 16, 2013 at 10:14 am
carpainter69 (9/16/2013)
I have a couple years experience with SQL, SSRS, and vb.net.
But I don't feel I have enough knowledge to get 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
September 16, 2013 at 10:12 am
The most important thing I would suggest is monitoring how the statistics are maintained. Likely it's just the automatic update. Depending on the type of data, how it's stored 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
September 16, 2013 at 8:58 am
Try running this:
RESTORE HEADERONLY FROM DISK = 'd:\bu\mm.bak' ;
But on your log backup. I'll bet you you're stacking the files.
"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
September 16, 2013 at 8:55 am
Yeah, I'd absolutely go with the tables too. It's the single easiest, most direct, most efficient way to maintain data integrity. It's the very reason you're using a relational engine...
"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
September 16, 2013 at 8:51 am
If the purpose of each SELECT is to be used as the source for an UPDATE, probably you'll be better off doing each SELECT/UPDATE pair together. You'll need to careful...
"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
September 16, 2013 at 3:50 am
And, there's a free tool from Red Gate Software called SQL Search[/url] that can help with this kind of thing.
"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
September 14, 2013 at 3:55 am
I would not recommend disabling parallelism. It's a good thing. I would suggest that you bump up the default value for the cost threshold for parallelism. The default value 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
September 14, 2013 at 3:54 am
Cause in the microsecond from you finishing killing all the sessions and then setting the database to single_user, another connection came in and took it over.
"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
September 13, 2013 at 10:01 am
Viewing 15 posts - 9,541 through 9,555 (of 22,219 total)