Viewing 15 posts - 11,536 through 11,550 (of 22,219 total)
GilaMonster (12/8/2011)
Grant Fritchey (12/8/2011)
With a permanent table, I have to make clean up a part of some explicit transaction at some point.
And have a process to handle cases where...
"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
December 8, 2011 at 5:04 am
Excellent write up. 5 Stars. Useful information for anyone that has to deal with this stuff.
I'm not an nHibernate expert, nor do I play one, anywhere, but I'm pretty sure...
"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
December 8, 2011 at 4:44 am
julian.fletcher (12/8/2011)
Thanks for your comments. When I said "real table", I meant a permanent one, not one created as and when required in the way that you would with 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
December 8, 2011 at 4:27 am
It almost sounds like there might a view involved. You sure they're all tables? If you eliminated the TOP, but you're still getting it in the plans, even with RECOMPILE......
"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
December 7, 2011 at 1:43 pm
hawg (12/7/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
December 7, 2011 at 1:34 pm
Dev (12/7/2011)
Cadavre (12/7/2011)
Dev (12/7/2011)
Welcome to the discussion!But that statement is for a table with 2 rows. 😀
The number of rows is irrelevant, the statement is...
"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
December 7, 2011 at 7:36 am
Dev (12/7/2011)
Ninja's_RGR'us (12/7/2011)
Dev (12/7/2011)
Ninja's_RGR'us (12/7/2011)
Dev (12/7/2011)
Ninja's_RGR'us (12/7/2011)
WHERE Items.ItemCategoryCode IN (SELECT CategoryCode FROM @Cats)Convert to #tbl with PK to help the stats, search and replace...
"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
December 7, 2011 at 6:17 am
Is is possible you have enabled 'optimize for ad hoc workload' on the server? It will store plan stubs the first time a query is executed instead of storing 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
December 7, 2011 at 5:19 am
DoubleEx (12/6/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
December 7, 2011 at 5:09 am
Test the restore. Don't assume it's OK. Test 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
December 7, 2011 at 5:06 am
durai nagarajan (12/7/2011)
hope both gives better performanace than cursors.
It depends on what you're doing with them.
"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
December 7, 2011 at 5:04 am
Another option to pursue, and a good plan for your long term skill set development, is to use Extended Events to capture all user activity. It works a lot like...
"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
December 7, 2011 at 5:03 am
GilaMonster (12/6/2011)
Grant Fritchey (12/6/2011)
GilaMonster (12/6/2011)
Grant Fritchey (12/6/2011)
LutzM (12/6/2011)
Ninja's_RGR'us (12/6/2011)
Would have been such a slam dunk of either of Jeff, Gail or I had been the single finalist from ssc! ...
"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
December 6, 2011 at 3:36 pm
GilaMonster (12/6/2011)
Grant Fritchey (12/6/2011)
LutzM (12/6/2011)
Ninja's_RGR'us (12/6/2011)
...Would have been such a slam dunk of either of Jeff, Gail or I had been the single finalist from ssc! 😉
I guess 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
December 6, 2011 at 1:29 pm
I'd say minimum, all projects go through Dev, Staging & Prod. Formal QA might be a luxury, but validating deployments sure isn't.
I listed a number of possible environments and what...
"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
December 6, 2011 at 11:40 am
Viewing 15 posts - 11,536 through 11,550 (of 22,219 total)