Viewing 15 posts - 17,386 through 17,400 (of 22,226 total)
AShehzad (5/26/2009)
Statistics will be updated automatically after index rebuild. There is no requirement to separately configure this task.
Are you sure? 😉
But since you shouldn't automatically rebuild all indexes 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
May 27, 2009 at 7:08 am
If people are posting code on the net, it has to be with the expectation that it will be used by others. I know that's the assumption that I have...
"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 27, 2009 at 6:49 am
Tell them not to drop tables. In 2000 we couldn't revoke their privileges to create indexes. We had to tell them not to do it. Although, since we built our...
"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 27, 2009 at 5:33 am
Create a role that you're going to add your developers to. Then add ddl_admin and security_admin roles that role. Then deny CREATE TABLE to the role. That about does 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
May 26, 2009 at 1:28 pm
David Burrows (5/26/2009)
...You could really mess with people's heads with this.
Well it obviously did with yours 😛
Yeah, but I'm a head case on the best days. I'm talking about...
"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 26, 2009 at 6:37 am
Good to know. Thanks for trying it out.
"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 26, 2009 at 6:02 am
RBarryYoung (5/22/2009)
Grant Fritchey (5/22/2009)
"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 23, 2009 at 2:13 pm
The queries look identical.
Post the execution plans.
Depending on the complexity of the query, the table order in the JOINs doesn't matter because SQL Server can rearrange them as needed, based...
"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, 2009 at 11:47 am
Just to deviate a bit from what everyone else is saying, if I were going to put any indexes on the system at all, because of how SQL Server stores...
"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, 2009 at 11:26 am
Yep, in the Navy on Subs. Hated it, but I'm glad I did 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
May 22, 2009 at 11:21 am
Oh, and my wife runs a Girl Scout troop and I pitch in there occasionally. That's one strange organization, especially after dealing with the BSA so much.
We're considering getting involved...
"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, 2009 at 11:19 am
Congratulations on achieving the rank of Eagle. That's an accomplishment I can only stand in awe of.
I'm currently an Assistant Scout Master for my local troop. I've only been directly...
"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, 2009 at 11:14 am
Steve Jones - Editor (5/22/2009)
Grant Fritchey (5/22/2009)
"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, 2009 at 10:22 am
Now I'm second guessing what we're doing. If we're storing files directly in the DB, I'd expect it to be fairly large since we've got a pretty extensive Sharepoint installation,...
"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, 2009 at 8:50 am
I suspect it's the temp table in the query, but you know what, instead of both of us guess, run the query with a Profiler trace going and look 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, 2009 at 7:36 am
Viewing 15 posts - 17,386 through 17,400 (of 22,226 total)