Viewing 15 posts - 8,716 through 8,730 (of 22,224 total)
By the gods, people get hung up on the weirdest darned things. They can focus like a laser on stuff that's just a waste of time. It's weird.
"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:45 am
yuvipoy (3/11/2014)
GilaMonster (3/11/2014)
yuvipoy (3/11/2014)
I am just asking will there be inprovement if there the data type is IntImprovement over what?
Improvement over Float.
Don't worry about that.
Are you storing integer style...
"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:42 am
While I'm honestly not crazy about this approach in general, it's not an end of the world scenario and, SEQUENCE can absolutely do what you're asking for. Personally, I'd 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 11, 2014 at 7:38 am
jaminbw (3/11/2014)
Gary Varga (3/10/2014)
"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:36 am
Sure. If you're using that you can even have it do the copy across the network for you. Step 3 of the Wizard when you're setting up backups includes "Copy...
"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:21 am
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
Viewing 15 posts - 8,716 through 8,730 (of 22,224 total)