Viewing 15 posts - 17,746 through 17,760 (of 22,219 total)
I used to use it for error handling back in SQL Server 6.5 & 7.0. But I came out of the VB coding camp back then, so I did lots...
"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
April 11, 2009 at 8:26 am
It sounds like you've set up the maintenance jobs or the sql agent, or both, to run under the 'sa' login and the password is not correct. Try running under...
"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
April 11, 2009 at 4:31 am
I'm afraid I don't understand the question. Are you concerned that your system is not using enough memory or too much?
One measure that will tell you if memory is 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
April 11, 2009 at 4:28 am
kim.talley (4/10/2009)
Is it more efficient to use multiple joins in 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
April 10, 2009 at 11:31 am
It really could be almost anything. Since you don't know, you need to investigate systematically. I like the recommendation to capture a trace. That's something I always do. I'd also...
"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
April 10, 2009 at 5:35 am
HVPR (4/9/2009)
and sorry for the posting twice...
But I want to know is there any local sql server feature or tool which can help to sync the
code between...
"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
April 9, 2009 at 1:23 pm
It's really hard to say based on the information provided. Are you sure that the slow response on the system is due to this table in particular? If so, do...
"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
April 9, 2009 at 12:40 pm
GilaMonster (4/9/2009)
For the records, I never beat Steve up. I was training with Kalen most of the class...
"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
April 9, 2009 at 11:52 am
Steve Jones - Editor (4/9/2009)
FYI, I also pinged MS on our boasting user.
Just out of curiousity, where do you go to ping MS on something like 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
April 9, 2009 at 11:34 am
And having seen the Gilamonster in action, I'm glad this isn't possible!
Man, I'm sorry I missed that seminar. She made a real impression.
"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
April 9, 2009 at 11:33 am
Andy Warren (4/9/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
April 9, 2009 at 6:50 am
I don't think so. Plus, I just wouldn't use @@IDENTITY. It's too prone to error. SCOPE_IDENTITY is much more consistent and I'm not aware of anyone having errors with 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
April 9, 2009 at 6:46 am
dastagirid (4/9/2009)
but what I need suppose I inserted 1 to 10 values in a table
and deleted 5 to 10 ..next i will insert record 11 is the id values..
I want...
"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
April 9, 2009 at 6:04 am
You use a second instance in order to manage different security for a system, to isolate an application from others, to have a SQL Server with different configurations, but still...
"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
April 9, 2009 at 5:58 am
During the insert you have a couple of options. You can use SCOPE_IDENTITY if you are inserting a single row at a time. You can use the OUTPUT clause if...
"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
April 9, 2009 at 5:52 am
Viewing 15 posts - 17,746 through 17,760 (of 22,219 total)