Viewing 15 posts - 14,806 through 14,820 (of 22,219 total)
Ah, different information. I would check the ANSI settings first, see if they're the same.
"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
June 18, 2010 at 12:01 pm
david.c.holley (6/18/2010)
"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
June 18, 2010 at 11:50 am
GilaMonster (6/18/2010)
If you just want to view the proc, you can grant view definition rights on it.
Oh right, I was thinking about looking at the data... misread it. Good catch,...
"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
June 18, 2010 at 8:52 am
You can't. You'd need to have execute privs on the procedure in order to execute it and get the data back from 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
June 18, 2010 at 8:34 am
A server side trace is the best method. Just limit the number of events and columns you're capturing and you won't even see the effects of it running, even on...
"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
June 18, 2010 at 8:02 am
Another option that we use pretty frequently is to create a role within the database. Grant all permissions through the role, and then add users or AD groups to 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
June 18, 2010 at 7:37 am
First off, you didn't state whether or not the hardware was different. Unless the memory, cpu and disks are identical, you'll see fundamental differences in behavior between machines.
Second, index fragementation,...
"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
June 18, 2010 at 7:35 am
And in addition to all that, I'd like to recommend a good book... look down.
"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
June 18, 2010 at 7:19 am
Gail may have already spotted the problem. If you're just running the SELECT and there's no filter on the data, it's doing a scan of all data across all 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
June 18, 2010 at 7:19 am
That is honestly a huge topic. It's not one that you're going to get good guidance on from responses on a blog. As a starting point you could 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
June 18, 2010 at 7:08 am
It's possible that if you're running REINDEX or other defrag routines that the new indexes could be affecting the log size. Other than that, no, I can't think of 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
June 18, 2010 at 7:03 am
GilaMonster (6/18/2010)
Lynn Pettis (6/17/2010)
"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
June 18, 2010 at 5:54 am
PradeepVallabh (6/16/2010)
"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
June 16, 2010 at 9:14 am
PradeepVallabh (6/16/2010)
Thanks for the info.....So in short the queries with estimated execution plans in the cache run faster
Well, that really depends on a lot of factors. I'll say this, queries...
"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
June 16, 2010 at 9:07 am
Gianluca Sartori (6/16/2010)
Grant Fritchey (6/16/2010)
I swear, about a third of our IT staff could fall into a bottomless pit and we wouldn't notice for a week.
Do we work for 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
June 16, 2010 at 6:36 am
Viewing 15 posts - 14,806 through 14,820 (of 22,219 total)