Viewing 15 posts - 9,766 through 9,780 (of 22,219 total)
Except for the key lookup, nothing jumped out at me. You can try to eliminate that by including the columns needed to satisfy the query in the nonclustered index.
Nothing else...
"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
May 30, 2013 at 8:31 pm
The Dixie Flatline (5/30/2013)
Stefan Krzywicki (5/30/2013)
Lowell (5/30/2013)
The Dixie Flatline (5/30/2013)
GilaMonster (5/30/2013)
The Dixie Flatline (5/30/2013)
GilaMonster (5/30/2013)
"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
May 30, 2013 at 4:00 pm
Lynn Pettis (5/30/2013)
patricio.honore (5/30/2013)
"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
May 30, 2013 at 12:16 pm
show_statistics will display the distribution of the data on any given set of statistics on a table. It's not going to tell you what might be a good index because...
"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
May 30, 2013 at 9:16 am
Brandie Tarvin (5/30/2013)
Evil Kraig F (5/29/2013)
There is no countdown, there is only Zuul...Or weeping angels.
http://dontblinktees.com/t-shirt/keep-calm-and-dont-blink-dark/%5B/url%5D
"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
May 30, 2013 at 5:20 am
Brandie Tarvin (5/30/2013)
WayneS (5/29/2013)
"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
May 30, 2013 at 4:56 am
Michael Valentine Jones (5/29/2013)
Are there Non-Functional DBAs?
I've met a few during my time, yes.
"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
May 29, 2013 at 3:38 pm
ggoble (5/29/2013)
It's the people like you that I would trust. 🙂
Ha! I'm probably near the bottom of people to trust on that type of question. I never look at...
"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
May 29, 2013 at 12:16 pm
I would take any and all licensing questions direct to Microsoft. Never trust any type of licensing answer you get from some nameless, faceless individual on the internet.
"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
May 29, 2013 at 11:40 am
A geography type consists of both latitude and longitude. You're trying to store them seperately and you can't do 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
May 29, 2013 at 11:38 am
Getting the wait statistics gives you some idea of what is causing the server to run slow, on average. To understand what is causing the server to run slow 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
May 29, 2013 at 8:44 am
I wouldn't say there are new threats beyond what we've outlined here. SQL Server 2000 is good, as far as it goes. It's just grossly inadequate on a million levels,...
"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
May 29, 2013 at 7:24 am
To know if it's the app or the database, you need to capture performance metrics from the database as it's running. There's a lot to that. I wrote about 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
May 29, 2013 at 6:36 am
chris.dunbar (5/29/2013)
Having looked round this site (mostly) and done a bit extra reading, there are many functions that I don't think we utilise. 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
May 29, 2013 at 6:32 am
The DTA works off of statistics and the indexes you have in order to make calculations to arrive at possible improvements. But, understand, statistics are simply a mathematical sampling 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
May 29, 2013 at 5:07 am
Viewing 15 posts - 9,766 through 9,780 (of 22,219 total)