Viewing 15 posts - 10,876 through 10,890 (of 22,224 total)
The ANSI settings change how the optimizer creates execution plans. So one connection with "concat null yields null" turned on can create a different execution plan from one that has...
"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 22, 2012 at 4:46 am
The only way to be 100% sure is to restore the database. I wrote this short article [/url]laying out the various things you can do and what they do 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
May 22, 2012 at 4:18 am
In theory, the same stored proc called from any connection should run roughly the same speed, regardless of who called it. But... there are connection settings that will cause different...
"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 22, 2012 at 4:12 am
By the way, if you're getting RID lookups it means that you're dealing with hash tables, tables without a clustered index. Unless you have a very thorough set of tests...
"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 22, 2012 at 4:09 am
From the sounds of things, you could just leave stuff as is. It doesn't sound like the data is so volatile that your stats are getting updated.
I don't think doing...
"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 22, 2012 at 4:07 am
Nope. I've done multiple installs with no issues like this. It sounds like you had a problem during the installation or you found a bug.
"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 21, 2012 at 8:49 am
Gullimeel (5/21/2012)
"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 21, 2012 at 6:30 am
SQLRNNR (5/18/2012)
In Boston now getting ready for SQL Sat 142.If you are close by, come check us out.
How did it go? I had a great, if tiring, weekend with 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
May 21, 2012 at 5:30 am
Gullimeel (5/19/2012)
I know who these guys are (I am reading one of Grant's book) and they are in this area much longer than I am but thats not the point...
"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 21, 2012 at 5:19 am
You can have SSMS installed on a different machine within the same network and connect to the machine you're interested in. Most of the servers I used to administer did...
"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 18, 2012 at 11:34 am
Gullimeel (5/18/2012)
Do not worry I will not create my own sort.
However, the people who queries dm_exec_query_stats to find the costly queries misses this sort cost. Like if you see this...
"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 18, 2012 at 8:04 am
You'd need to show the actual execution plan in order to make any guesses at what's needed to tune the query. One suggestion, see if there are ways to limit...
"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 18, 2012 at 5:49 am
sukhoi971 (5/18/2012)
there are 100s of tables
if i take backup and then delete the database will it improve perfomance?
since...
"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 18, 2012 at 5:42 am
john.p.lantz (5/17/2012)
"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 18, 2012 at 5:20 am
Lynn Pettis (5/17/2012)
Jeff Moden (5/17/2012)
Thomas Stringer (5/16/2012)
"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 18, 2012 at 4:34 am
Viewing 15 posts - 10,876 through 10,890 (of 22,224 total)