Viewing 15 posts - 14,836 through 14,850 (of 22,219 total)
I think that you ought to try letting SQL Server manage the locks for you rather than trying to control it using lock hints.
Without more details on what was being...
"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
June 14, 2010 at 9:33 am
It's the identifier for a connection. There is no relation to the connection string or to any machine connecting to the server, except for the duration of the connection. You're...
"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
June 14, 2010 at 7:43 am
Brandie Tarvin (6/14/2010)
Spiritual support is also acceptible. But when you do get back into gaming... @=)
I'll make a point of it, it'll be the first purchase.
"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
June 14, 2010 at 7:38 am
Yep, Event Viewer through the Management interface.
"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
June 14, 2010 at 7:34 am
2nd vote for SQL Server Internals. Excellent book.
A secondary choice would be Christian Bolton, et al, SQL SErver 2008 Internals and Troubleshooting. It's not as thorough as Kalen's book regarding...
"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
June 14, 2010 at 7:33 am
In most places you'll need to bracket key words to use them within structures like that. Can you do it? Yes. Should you do it? I'd say no, but at...
"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
June 14, 2010 at 7:30 am
And on top of what Paul says, are there other transactions occurring at the same time? This will further add to the overall size of the log during this operation.
"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
June 14, 2010 at 7:26 am
It really depends on the application. Yes, modifying indexes or even adding indexes, depending on the index, could negatively affect an application. Just as you would with your own apps,...
"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
June 14, 2010 at 7:14 am
Many congratulations! Publication is a wonderful thing. Well done.
Unfortunately, I'm not much of a gamer any more and don't have this system, so my support will have to be strictly...
"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
June 14, 2010 at 7:06 am
Jeff Moden (6/11/2010)
"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
June 14, 2010 at 6:18 am
You can go to the advanced tab for the given step in the Agent job and tell it to retry a set number of times.
"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
June 11, 2010 at 12:48 pm
It's not rocket science. Just script the stuff you do manually. That's how we built it. Put it together over time, save the script, you'll be up & running in...
"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
June 11, 2010 at 12:45 pm
We set up an automated process that captures the security on the target system, restores the database, cleans out the old security, cleans up any sensitive data, then applies 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
June 11, 2010 at 11:50 am
You should take a look at sqlshare.com. They have quite a lot of videos that can teach you skills in SQL Server, including performance tuning.
"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
June 11, 2010 at 11:49 am
I'd go with a TOP (1) and an ORDER BY on the value. You'll get exactly what you 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
June 11, 2010 at 11:46 am
Viewing 15 posts - 14,836 through 14,850 (of 22,219 total)