Viewing 15 posts - 18,841 through 18,855 (of 22,219 total)
Actually, looking at the data, what if you modified the solution I suggested to get the max ApplicationID instead of the max date? Just use the other columns as matching...
"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
January 7, 2009 at 9:27 am
Too much information in the Estimated execution plan? I don't understand.
You can export the plan as .sqlplan file, zip it and post it here to have someone look 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
January 7, 2009 at 6:58 am
SQL DBA (1/7/2009)
I need differences between Roles, Schemas, Users and Logins. Can anyone help me. Thanks in advance
Have you looked them up on the Books Online? If so, what did...
"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
January 7, 2009 at 6:18 am
To really get an answer, post what Gail says.
For another guess... You're moving so much data that SQL Server is just ignoring the indexes.
BTW, looking at the execution plan, 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
January 7, 2009 at 6:16 am
Probably, in this line of code:
addcount = m + 1
"m" is being treated as a string, not as an integer. That would explain how you would get "11" when 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
January 7, 2009 at 6:13 am
You are going to have to be able to identify the partitioning mechanism, the column or columns that identify where the data is stored. While your post says it doesn't...
"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
January 7, 2009 at 6:10 am
Oopsie. Thanks Noel!
"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
January 6, 2009 at 1:08 pm
I'm sure you can use a stored procedure. Just pass the parameters to one.
"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
January 6, 2009 at 1:07 pm
dave (1/6/2009)
I gave it a shot but unfortunately that didn't seem to work. The application and tracking tables are 1-to-1, so selecting the top renewal date 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
January 6, 2009 at 1:04 pm
Something along these lines will work just fine. You may need to adjust your indexes to get optimal performance.
SELECT a.application_id,
d.brandname,
...
"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
January 6, 2009 at 12:33 pm
Show what kind of SQL you've tried that hasn't worked. Lots of us will be glad to help, but we're not doing your homework for 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
January 6, 2009 at 12:29 pm
RBarryYoung (1/6/2009)
GilaMonster (1/6/2009)
Grant Fritchey (1/6/2009)
I must be old, D&D used lots (and lots and lots) of six-sided dice. Now, Traveller, there were the decimal dice at work.
Which edition 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
January 6, 2009 at 12:24 pm
You can't set variables within a statement like that. You could set the variable prior to the insert statement or, just do this:
INSERT INTO tblProject
...
"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
January 6, 2009 at 11:24 am
Based on what I heard, this?
UPDATE TABLE
SET str_val = x.str_val
FROM TABLE x
WHERE x.prop_id = 131
and TABLE.prop_id = 130
"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
January 6, 2009 at 11:20 am
I mean building queries as strings and running them. I'd suggest using sp_executesql, but it amounts to the same thing as exec. Although, you can get some parameterization, and therefore...
"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
January 6, 2009 at 10:58 am
Viewing 15 posts - 18,841 through 18,855 (of 22,219 total)