Viewing 15 posts - 6,871 through 6,885 (of 22,219 total)
Move your mouse to the lower left corner of the window and you'll see an icon. Or, go to the lower or upper right corners and you'll get a charms...
"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 19, 2015 at 6:05 am
to really understand which of the queries are giving you the most pain, I strongly suggest you run the trace file through the RML Utilities (you'll have to recapture one...
"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 19, 2015 at 5:58 am
Also remember that these processes are subject to blocking and resource contention. It could just be that there were more shared locks or something causing waits on the rebuild process...
"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 19, 2015 at 5:54 am
Test, test, test, test, test.
I agree that keeping it simple and using ALTER TABLE is the right answer most of the time. I also agree that you may 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 19, 2015 at 5:52 am
Eirikur Eiriksson (1/19/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop,...
"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 19, 2015 at 5:48 am
Eirikur Eiriksson (1/19/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop,...
"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 19, 2015 at 5:45 am
WayneS (1/18/2015)
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
If you feel like...
"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 18, 2015 at 12:58 pm
Very few choices there. You'll have to clean the data. Decide which dates are supposed to be correct and modify them. No other way around that.
"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 18, 2015 at 7:08 am
For managing dates like that, I'd suggest using the UTC date functions; SYSUTCDATETIME or GETUTCDATE. You can then use the timezone offsets to show the dates as local if necessary.
"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 18, 2015 at 4:51 am
OK then. Hopefully those resources I linked to will help you out then.
"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 18, 2015 at 4:44 am
OK. You may want to filter those results and eliminate some stuff that's not telling you anything. Here's a good article on that from Paul Randal. Most of your top...
"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 17, 2015 at 7:28 am
The first thing that comes to mind is the fact that you're going to write a lot of OR statements to switch through these bit fields. That bothers me from...
"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 17, 2015 at 6:45 am
CXPacket waits are just an indication of waits on threads in SQL Server. They don't indicate a performance problem at all really. A lot of people think they mean that...
"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 17, 2015 at 6:40 am
First thing you can do is ping, and ping for the specific port that you have SQL Server configured for (default is 1433). After that, it really depends on what...
"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 17, 2015 at 6:35 am
Excellent. Thanks Lowell. I did not know that.
"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 16, 2015 at 6:42 am
Viewing 15 posts - 6,871 through 6,885 (of 22,219 total)