Viewing 15 posts - 13,096 through 13,110 (of 22,219 total)
Honestly, that's a bad approach and will lead to problems. Best to let SQL Server handle locking for you. It will absolutely handle it well. If you have to, set...
"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
March 7, 2011 at 2:30 pm
Absolutely sounds like parameter sniffing gone wrong.
"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
March 7, 2011 at 2:23 pm
1) it really depends on what you're looking for. Basically it seems OK. I'm not sure I'd have the outer BEGIN...END wrapper because it's not really doing anything 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
March 7, 2011 at 2:23 pm
It's hard to know exactly what it might be based on the information at hand. Have you looked at the DMV sys.dm_os_waiting_tasks? You can combine this with other DMVs such...
"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
March 7, 2011 at 2:17 pm
"Unreachable" is a pretty vague message. It could mean that the DB is offline or it could mean that it's running slow and the connection timed out or it could...
"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
March 7, 2011 at 2:07 pm
vinod.saraswat (3/6/2011)
Hi,Thanks for your reply. Can you plz. give the step by step guide.
You absolutely must run DBCC on databases if you care at all about the data. How 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
March 7, 2011 at 6:15 am
SQLkiwi (3/4/2011)
Exciting day - just had my first Simple Talk article published:http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
Well done and congratulations!
Good article 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
March 6, 2011 at 5:20 am
There just isn't a single right answer. In general terms, I'd say less than 1000 rows is something to shoot for, depending on how you're using the variable. However, 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
March 6, 2011 at 5:14 am
You'll have to have been observing consistent disparity between the actual data and the statistics. The most frequent place you'll catch this is in execution plans. But it's possible 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
March 6, 2011 at 5:08 am
One alternative is to use a third party product to enable you to move the VLDB database to a different location for consistency checks. There are a number of ways...
"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
March 6, 2011 at 5:06 am
Alvin Ramard (3/4/2011)
"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
March 4, 2011 at 12:39 pm
Ninja's_RGR'us (3/3/2011)
Grant Fritchey (3/3/2011)
"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
March 3, 2011 at 12:20 pm
I'm still at the MVP summit so I have no time to play. I'll see if I can experiment a little when I get back next week. I agree. Call...
"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
March 3, 2011 at 8:52 am
OK. What about setting up a Plan Guide?
"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
March 2, 2011 at 5:20 pm
Well, a hash key can work. In fact, if you're dealing with really big fields, it's probably a good idea since you can't go beyond 600 bytes in an index...
"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
March 2, 2011 at 3:18 pm
Viewing 15 posts - 13,096 through 13,110 (of 22,219 total)