Viewing 15 posts - 18,601 through 18,615 (of 22,226 total)
Sorry, I meant the example code. The explanation clearly mentioned two tables.
"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 28, 2009 at 6:43 am
Yeah, I would have been curious to hear his side of the story too.
But I wouldn't throw rocks because he had few points when he posted an article. I posted...
"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 28, 2009 at 5:42 am
Oops. Right. Forgot the N in front of the strings... sorry.
"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 28, 2009 at 4:58 am
You can't pass parameters as column names, that's the error you're no doubt getting. To do something like this, you need to build the string and execute it:
DECLARE @y nvarchar(50)...
"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 28, 2009 at 4:57 am
kiman_keren (1/28/2009)
i have some questions:
1. what's the different between clustered and non clustered? i've got a lot of answer in google, but i wanna know from this forum.
2. how...
"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 28, 2009 at 4:51 am
KB (1/27/2009)
INSERT INTO TableA
(
ColA1,
...
"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 28, 2009 at 4:46 am
The unique constraint will keep duplicates from getting in. I'd suggest, in order to reduce contention, that you perform the INSERT statement without the pre-check and then check that 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
January 28, 2009 at 4:38 am
It looks like you're trying to return a list and a set of counts. You can do this without a cursor:
SELECT [name]
,COUNT([name])
FROM #DISTINCTC
GROUP BY [name]
You might want to pick up...
"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 28, 2009 at 4:31 am
mbrady5 (1/27/2009)
I would like to join cwm_cust table to cwm_cut_upload in the following query.. That part I am good with. What I cannot figure...
"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 28, 2009 at 4:27 am
It's a pretty low act. I know that when I'm writing I'm scared to death I might string three or four words together in exactly the same way as someone...
"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 28, 2009 at 4:11 am
Lynn Pettis (1/27/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 27, 2009 at 1:26 pm
Uh... Wow... Over-achieve much?
I feel a bit stupid to be commenting on this. I don't have much experience with partitioning beyond reading up on the theory and a few discussions....
"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 27, 2009 at 12:54 pm
The single thread on the user app is because the tool using Profiler for the playback. Profiler isn't smart enough to spawn a different process for each SPID as 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 27, 2009 at 12:39 pm
Marios Philippopoulos (1/27/2009)
What does that entail? Is it done transparently by the tool or is there anything manual that needs to be done?
When I read about 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
January 27, 2009 at 11:48 am
Yeah, I used it at a lab at the Microsoft Technology Center to test the upgrade of one of our databases. I blogged about it here[/url].
"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 27, 2009 at 11:29 am
Viewing 15 posts - 18,601 through 18,615 (of 22,226 total)