Viewing 15 posts - 8,716 through 8,730 (of 22,219 total)
While index defrags are quick, easy and make you feel like you're doing something, they're very, very seldom of any real use when it comes to performance unless you're seeing...
"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
March 11, 2014 at 7:19 am
yuvipoy (3/11/2014)
So if i move to Big int data type then will there be performance improvement?here i am mainly concern about data reading(Select).
Performance improvement over what? If you need to...
"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
March 11, 2014 at 4:56 am
Could it be replication? Sure, it could be. But we don't know what's running slow from what you've told us. You need to capture the general wait statistics to understand...
"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
March 11, 2014 at 4:43 am
The best approach is to take the backup locally on the server with the SQL Server instance, and then copy that backup across the network. The reason is that network...
"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
March 11, 2014 at 4:40 am
sp_updatestats uses the defaults which is for SQL Server to make a calculation for which sample rate to use. If you need to take more direct control, you have to...
"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
March 11, 2014 at 4:39 am
But that's only the "most used" since the last time those values were reset. If the server was restarted last week, a completely different set of indexes might be listed...
"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
March 10, 2014 at 10:56 am
"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
March 10, 2014 at 10:30 am
There's a minimal number of columns that you must have for the replay mechanism to work. And yeah, it collects a lot of data. Only way to deal with 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
March 10, 2014 at 10:05 am
Stuart Davies (3/10/2014)
jaminbw (3/9/2014)
Thanks for this article. I relate to this so much.
I do want to be responsive to needs of operations but, I hate how often I am...
"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
March 10, 2014 at 8:55 am
Ha! Thanks.
Been accused of being pompous lately and not sure I should be using words like sclerotic. But as long as people know what they mean and they do...
"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
March 10, 2014 at 8:26 am
I don't think that's a mirroring or replication error, so it's likely that it's coming from the client application. If so, yeah, it's likely that you need to do some...
"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
March 10, 2014 at 5:49 am
Koen Verbeeck (3/10/2014)
Grant Fritchey (3/10/2014)
You should just be able to attach the database file directly to SQL Server. Is that what you're trying to do?
Earlier versions of AdventureWorks had some...
"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
March 10, 2014 at 3:43 am
I would also suggest you build your databases such that the columns that are meant to be numbers are stored as numbers, not strings.
"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
March 10, 2014 at 3:41 am
You should just be able to attach the database file directly to SQL Server. Is that what you're trying to do?
"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
March 10, 2014 at 3:39 am
If you are moving into very large sets of data, you might want to consider using bigint out of the box. That will be wider on your indexes, but 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
March 10, 2014 at 3:38 am
Viewing 15 posts - 8,716 through 8,730 (of 22,219 total)