Viewing 15 posts - 13,396 through 13,410 (of 22,227 total)
I agree. Don't argue with them (naming convention arguments are such a waste of time). But do ask to document the standard, just so you can better comply with...
"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
February 3, 2011 at 8:21 am
If they can at least explain their naming convention, follow it. Have you done it in a way that is clear and at least reasonably accurate? Yes. But that doesn't...
"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
February 3, 2011 at 7:40 am
Also, while it might appear to help performance, that NOLOCK hint is potentially problematic.
"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
February 3, 2011 at 7:19 am
Brandie Tarvin (2/3/2011)
Grant Fritchey (2/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
February 3, 2011 at 6:03 am
I have to say, it's entertaining as hell. You guys should keep poking him/her (most likely him). I'm so glad that's the exception, not the rule, for youngsters posting 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
February 3, 2011 at 5:46 am
jcrawf02 (2/2/2011)
Anybody using non-iPad tablets? If so, which one(s)?
I've only used the iPad. But the Toshiba that's due out in the spring looks fantastic. It's a Droid and I'd go...
"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
February 2, 2011 at 3:08 pm
A query similar to this will show what you need:
SELECT deqp.query_plan
FROM sys.dm_exec_requests AS der
CROSS APPLY sys.dm_exec_query_plan(der.plan_handle) AS deqp
CROSS APPLY sys.dm_exec_sql_text(der.sql_handle) AS dest
WHERE ...
In the WHERE clause, not sure what 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
February 2, 2011 at 11:11 am
Something like this:
BEGIN TRANSACTION MyTran1
EXEC dbo.MyProcA
BEGIN TRY
BEGIN TRANSACTION MyTran2
EXEC dbo.MyProcB
COMMIT TRANSACTION MyTran2
END TRY
BEGIN CATCH
ROLLBACK...
"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
February 2, 2011 at 8:54 am
Yes, you can query the DMV, sys.dm_exec_query_plan. You just have to combine it with sys.dm_exec_requests to get the plan_handle while it's running.
"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
February 2, 2011 at 8:49 am
Check the execution plans. See if they're different. Both tests are against the same server? If not, look for differences there. Look for blocking... Not being there, it's hard 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
February 2, 2011 at 8:25 am
If you can't shrink those files it's because SQL Server is retaining the transaction information. That usually means replication, log shipping, or mirroring is active. That's where I'd focus 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
February 2, 2011 at 8:19 am
Are you passing it the same parameters? Are the ANSI settings the same between the app and SSMS?
"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
February 2, 2011 at 8:10 am
Try adding a file on a different drive to the database as a log file. That should give you enough space so that you can then truncate it.
Also, if 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
February 2, 2011 at 8:05 am
If you nest the transactions, start one that wraps both procedures and start a second that only wraps the second procedure, you can rollback the second transaction without rolling back...
"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
February 2, 2011 at 7:59 am
Raghavender (2/2/2011)
Grant Fritchey (2/1/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
February 2, 2011 at 7:42 am
Viewing 15 posts - 13,396 through 13,410 (of 22,227 total)