Viewing 15 posts - 8,191 through 8,205 (of 22,224 total)
John Mitchell-245523 (5/12/2014)
Indeed. Hence the warning about performance.John
I do occasionally have reading problems. And this was one of them. Apologies.
"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
May 12, 2014 at 10:00 am
Of course, the function on that column will preclude index seeks.
"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
May 12, 2014 at 9:54 am
I'm with Gail. I'm just guessing without an execution plan.
And joining millions of rows is more costly than simply selecting millions of rows. That's just how it works. Joining 2...
"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
May 12, 2014 at 9:48 am
Without seeing the execution plan we're just guessing, but this index:
pk_ss_pLevelID clustered, unique, primary keylocated on PRIMARY pLevel, pLevelID
Strikes me as potentially problematic. What does the data in pLevel look...
"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
May 12, 2014 at 8:58 am
You can just go and look at it. Here's a blog post from Microsoft that shows how.
Even if the database hasn't been touched for weeks, if it was in use,...
"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
May 12, 2014 at 8:11 am
I'd say, test it out and see how it works. The inserted table is available from a trigger. As long as you designate it as an AFTER trigger... test 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
May 12, 2014 at 7:51 am
SQL Server will just fill the memory on a machine right up to the limit you give it, or, to the point where it contends with the OS for memory....
"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
May 12, 2014 at 7:31 am
For the test to past, both records have to be there, so you can't really automate it from the database end since either record could be missing at the moment...
"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
May 12, 2014 at 7:24 am
I think I would probably do this programmatically. I mean, if you tried using a trigger that stopped inserts of an A type row unless there was already a B...
"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
May 12, 2014 at 6:13 am
Back to an area that I'm not sure about. I don't 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
May 12, 2014 at 5:17 am
Eirikur Eiriksson (5/12/2014)
Grant Fritchey (5/12/2014)
madhukars 32911 (5/12/2014)
Yes,I want to use JOINS, but this relationship is to be generated automatically on selection of the tables by the user.
Right. No way 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
May 12, 2014 at 5:15 am
madhukars 32911 (5/12/2014)
Hi,I want to use the existing relationship to be populated in a text box in vb.net
Thanks
Madhukar
That's different. You can look at the foreign key constraints on a table...
"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
May 12, 2014 at 4:47 am
madhukars 32911 (5/12/2014)
Yes,I want to use JOINS, but this relationship is to be generated automatically on selection of the tables by the user.
Right. No way to do this automatically through...
"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
May 12, 2014 at 4:46 am
Yeah, it's going to try to backup SQL Server files in that case.
"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
May 12, 2014 at 4:45 am
I don't know the Windows tools you're referencing and couldn't offer a suggestion there. I would assume you could, but I don't 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
May 12, 2014 at 3:51 am
Viewing 15 posts - 8,191 through 8,205 (of 22,224 total)