Viewing 15 posts - 20,941 through 20,955 (of 22,224 total)
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
Matt Miller (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:03 am
Nope. Can't do it.
There are a lot of third party tools for this, free, cheap & expensive. Personally, I use Red Gate SQL Prompt & SQL Refactor. Between the two,...
"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 8:29 am
If the emailaddress is the primary means of accessing this table, then yeah, I'd make it the clustered index. If you have it as a unique non-clustered index, you'll 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
March 5, 2008 at 8:24 am
FWIW, I put two people through phone screens yesterday. Both had more than 8 years experience in SQL Server. Both were listed as senior level consultants. Neither could describe 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
March 5, 2008 at 7:49 am
select right('testfolder/test.aspx',len('testfolder/test.aspx') - charindex('/','testfolder/test.aspx'))
"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 7:44 am
It's not hard & fast or black & white. In general terms, using a temp table is not bad. It depends on what you're doing with it and how it's...
"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 7:12 am
allenrlewis (3/4/2008)
Could you give me a little example that would work on like a Northwind or something.Likethe tsql statement so I can test the theroy.
I'd have to experiment a bit...
"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 6:25 am
I'm not questioning you, per se, but surely there's a DBA "it depends" on the end of a statement that says maintaining extra indexes makes no difference at all. 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
March 5, 2008 at 6:09 am
abd (3/5/2008)
In fact Andras, yes, this is a short example of my sp
but the problem here i can not use the IF statement,...
"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 5:54 am
This may come as a bit of a shock, but the usual method of performance tuning is not to try to eliminate the use of an index, but rather 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 5, 2008 at 5:32 am
Viewing 15 posts - 20,941 through 20,955 (of 22,224 total)