Viewing 15 posts - 20,956 through 20,970 (of 22,219 total)
Yeah, you should be able to employee a CASE statement, but it depends on where you mean to employee 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 4, 2008 at 9:22 am
I think, note that key word, it's because of a rounding error when doing an implicit conversion from the string to the float. The other two can do the implicit...
"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 4, 2008 at 6:20 am
Jack's right.
The table you asked about is where SQL Server tries to maintain the dependency chain between objects (although it doesn't do a great job at it). It's important...
"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 4, 2008 at 6:14 am
wtipton (3/3/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 4, 2008 at 6:12 am
I was just going to post the exact same link. Cool!
"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 4, 2008 at 6:04 am
Oh come on, it'll have an effect. You're inserts will be faster because you're not maintaining a useless index.
😀
"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 4, 2008 at 5:57 am
As everyone else has already pointed out, if you pass in brackets, you can make a table named almost anything, including [].
But, if we assume you either strip the brackets...
"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 4, 2008 at 5:49 am
I definately recommend you NOT use a function for this type of query. It's a straight select statement. It should be done within a stored procedure or a parameterized query....
"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 4, 2008 at 5:33 am
The function is probably presenting itself as (doing this from memory, so forgive me if I'm slightly off) a table scan or an external operation, but I think if you...
"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 4, 2008 at 5:30 am
What does the execution plan look like?
I suspect, but this is a guess, you're getting an index scan and then a bookmark lookup to get to the data and then...
"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 3, 2008 at 1:06 pm
Again? Damn!
"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 3, 2008 at 12:49 pm
Me too. I haven't a clue where to begin with SSAS. I have done some SSIS, but I'm just barely functional, not competent. SSRS is probably going to become 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 3, 2008 at 12:45 pm
A covering index is one in which all the columns needed by the query are contained within the index.
When you listed the row count and distinct value count, was that...
"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 3, 2008 at 12:27 pm
create (3/3/2008)
I didn't mention that I was working in vbscript so that was my mistake.
I must be missing something though because I am still not sure how we...
"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 3, 2008 at 10:37 am
Sorry, I wasn't clear. I showed how to build the SQL string in TSQL. You're correct. To build an execution string in VB, you'd use the &.
However, as Roy mentioned...
"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 3, 2008 at 9:09 am
Viewing 15 posts - 20,956 through 20,970 (of 22,219 total)