Viewing 15 posts - 20,926 through 20,940 (of 22,219 total)
A seek is when a particular value (or values) is pulled out of an index. Think of it like looking up a particular index card (OK, people may not know...
"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
March 6, 2008 at 10:38 am
That's called RBAR (reebar) processing and means Row-By-Agonizing-Row. It's definately not the way to go in most cases.
Instead, you need to focus on the results that you want as 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
March 6, 2008 at 10:28 am
ODAA caught by the coworkers, still not noticed by the boss or any one else in management.
"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
March 6, 2008 at 9:18 am
Oh great, I'm not schizophrenic enough. Now I have to figure out the order in which to read posts.
:w00t::w00t::w00t::crazy::sick:
"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
March 6, 2008 at 9:15 am
It's behaving pretty strangely over all. I'm seeing multiple alerts for discussions that don't appear to have any new posts at all.
"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
March 6, 2008 at 9:09 am
First, NOT IN usually doesn't perform as well as an OUTER JOIN, so I'd change that right away. Second, you can check to see that values are a number by...
"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
March 6, 2008 at 9:06 am
Only because he wanted to return the values and lock them down from other users. So I did the SELECT with the update lock first, then udpate the table 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
March 6, 2008 at 6:22 am
Also, on the SELECT...INTO vs. CREATE TABLE & SELECT question. That one depends too. It depends on whether or not you are going to create indexes or in any other...
"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
March 6, 2008 at 6:11 am
Now you're being mean.
😎
"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
March 5, 2008 at 12:30 pm
Matt Miller (3/5/2008)
Jack Corbett (3/5/2008)
Matt Miller (3/5/2008)
It looked something like:
Matthew Miller
Senior Software Architect, O.D.A.A.
After I had been using it 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
March 5, 2008 at 11:31 am
Or in this case, six months experience repeated 16 times.
Sorry, I'm frustrated. I've got stacks & stacks of interview sheets with little x's next to questions that people with more...
"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
March 5, 2008 at 9:38 am
If it's one more, then you've got extra stuff in there. Try using DATALENGTH in the query instead & see how that works.
"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
March 5, 2008 at 9:30 am
Jeff Moden (3/5/2008)
Grant Fritchey (3/5/2008)
"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
March 5, 2008 at 9:23 am
Yeah, I was thinking about posting the same thing. Accurate statistics are way too important for getting good execution plans.
"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
March 5, 2008 at 9:13 am
Hmmm, maybe non-printing characters.
See if this returns different values than the LEN statement.
SELECT DATALENGTH('testfolder/test.aspx')
That might be the issue.
"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
March 5, 2008 at 9:11 am
Viewing 15 posts - 20,926 through 20,940 (of 22,219 total)