Viewing 15 posts - 18,856 through 18,870 (of 22,226 total)
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
Itzik Ben-Gan's books, Inside SQL Server 2005 T-SQL Querying and T-SQL Programming. Also the performance tuning one by Kalen Delaney. Joseph Sack's books are fantastic too.
"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 9:43 am
Sure, you can have two fields on the clustered index. I'm assuming the cluster is not the primary key, but you can have two fields on the key too.
"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 9:04 am
GilaMonster (1/6/2009)
Greg Edwards (1/6/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
January 6, 2009 at 9:02 am
Greg Edwards (1/6/2009)
Grant Fritchey (1/6/2009)
GilaMonster (1/6/2009)
Chris Morris (1/6/2009)
GilaMonster (1/6/2009)
I recommend a 20-sided dice.Six is sufficient...http://en.wikipedia.org/wiki/The_Dice_Man
Maybe for you. 😉 I play D&D. The 20-sided dice is the most important one.
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
January 6, 2009 at 8:59 am
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? I...
"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 8:58 am
One question, you wouldn't have an outer join to the customer table would you? You have to have a customer to have a call right?
If so, this should work just...
"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 8:37 am
From what you're saying, dynamic TSQL is probably the way to go.
In a system where anything can be queried, any way, at any time, performance is usually an issue. 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
January 6, 2009 at 8:26 am
I would run a server side trace (which can be generated through the Profiler tool, but shouldn't be run through it) to capture the calls against the database. Once I...
"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 8:21 am
Viewing 15 posts - 18,856 through 18,870 (of 22,226 total)