Viewing 15 posts - 7,621 through 7,635 (of 22,226 total)
You might just be seeing high PLE, but it could also be related to running on a NUMA architecture[/url]. Instead of just reading the average, get the specific values for...
"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
August 4, 2014 at 11:59 am
Same query, but different data sets right? Which means radically different statistics? It helps explain why you might see differences in the plans selected. But, it all comes back 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
August 4, 2014 at 10:56 am
jcrawf02 (8/4/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
August 4, 2014 at 8:19 am
MuhammadShafiq (8/4/2014)
Grant Fritchey (8/4/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
August 4, 2014 at 8:15 am
You're describing the WHERE clause of a query. You can combine different criteria in the WHERE clause using AND/OR logic to arrive at filtered record sets. There's nothing you must...
"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
August 4, 2014 at 6:30 am
raj.prabhu001 (8/3/2014)
I have a fact table which has six field now and I have created non clustered index on all fields.
It will also have more fields later with millions 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
August 4, 2014 at 4:58 am
Better still, don't use trace and start using extended events. You're running 2012, so the excuse of not having a GUI has been eliminated.
"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
August 4, 2014 at 4:47 am
As has been stated, SQL Server will use all the memory you make available to it. In order to understand if you have enough memory, I'd suggest using some 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
August 4, 2014 at 4:45 am
There's no magic. The creation of the index requires locks placed on the table that are going to prevent inserts. You'll have to finish the creation of the index prior...
"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
August 4, 2014 at 4:43 am
Completely guessing, your database is in FULL recovery and you don't run log backups? Is the drive where the log files live full?
"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
August 1, 2014 at 11:25 am
2gb is a very small environment. 2012 has a lot more functionality built in than 2000 does. It's entirely possible that 2000 runs faster in such a tiny environment as...
"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
August 1, 2014 at 8:45 am
jarupan (7/18/2014)
This is the first time I see about infinity switch. Does it mean unlimited growth in TempDB? If not, would you pleasee explain and how can I...
"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
August 1, 2014 at 5:55 am
cdm33.com (7/31/2014)
After poking around and reading what you had to say about what I wanted to do, I think I'm off to a good start. It's...
"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
August 1, 2014 at 5:32 am
William J. Fellows (7/31/2014)
To qualify my statement, Steve stares at my legs a lot. 😛
Me too! Va-va-va-voom!
"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
July 31, 2014 at 1:03 pm
Another vote for the side-by-side upgrade. In place upgrades burn sometimes. I'm just not a fan.
And yes, your boss is wrong. That's not the right way to go about 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
July 31, 2014 at 12:14 pm
Viewing 15 posts - 7,621 through 7,635 (of 22,226 total)