Viewing 15 posts - 11,956 through 11,970 (of 22,224 total)
A heap doesn't have statistics, so I'm not sure what you're looking at there.
Clustered indexes should show the last update date. How are you looking at the statistics information?
"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
August 26, 2011 at 5:35 am
Christi Wilson (8/25/2011)
I didn't want to start a whole new thread as...
"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
August 26, 2011 at 5:22 am
A CTE is a derived table. So, saying which one is faster or not, is not really possible per se. It depends on how they're put together, how they're called,...
"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
August 25, 2011 at 12:33 pm
Brandie Tarvin (8/25/2011)
Space Tramps is going to be available for order through your local bookstore when it comes out next month.
I HAVE ARRIVED!!!! Finally, a book I've written for 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
August 25, 2011 at 12:17 pm
GilaMonster (8/25/2011)
Kiara (8/25/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
August 25, 2011 at 12:14 pm
SQLRNNR (8/25/2011)
GilaMonster (8/25/2011)
SQLRNNR (8/25/2011)
Grant Fritchey (8/25/2011)
... and Sharepoint and the business, and some PowerShell, and search engines, and a little NoSQL and...
Really, this is a public forum... We should...
"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
August 25, 2011 at 10:30 am
Sean Lange (8/25/2011)
Saga... (8/25/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
August 25, 2011 at 9:12 am
Ninja's_RGR'us (8/25/2011)
It depends.That's pretty much the only thing left to say atm!
:hehe:
+1
"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
August 25, 2011 at 9:10 am
GilaMonster (8/25/2011)
Tom.Thomson (8/25/2011)
I saw this in an SS Central topic, and responded appropriately - I hope. If anyone thionks I was inappropriately heavy, let me know.
Grrr. What a narrow-minded...
"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
August 25, 2011 at 9:06 am
Ninja's_RGR'us (8/25/2011)
sp_updatestats or update with fullscan IIRC they don't do the same thing?
100% accurate, they don't do the same thing. For most stats in most cases, the sampled scan, sp_updatestats...
"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
August 25, 2011 at 7:38 am
LutzM (8/25/2011)
do you really refer to the number of rows being returned?
Example: a query returning 100K rows should benefit from parallelism but the very same query expanded by a TOP...
"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
August 25, 2011 at 7:36 am
Ninja's_RGR'us (8/25/2011)
Grant Fritchey (8/25/2011)
Rajo (8/25/2011)
thanks for your replies.yes , i executed sys.dm_os_wait_stats and found the following has high wait time
CXPACKET
LAZYWRITER_SLEEP
SQLTRACE_BUFFER_FLUSH
SOS_SCHEDULER_YIELD
how to clear these wait types
thanks
CXPACKET waits are usually an indication...
"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
August 25, 2011 at 7:18 am
For every key press? Whoa! You might want to explore one of the NoSQL options to see if they can support you better. SQL Server is likely to barf 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
August 25, 2011 at 7:13 am
Ninja's_RGR'us (8/25/2011)
How did yo come up with that 10K suggestion?
Basically, wet my finger, stick it in the air, see which direction the wind is blowing...
I've seen benefits with larger data...
"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
August 25, 2011 at 7:12 am
Rajo (8/25/2011)
thanks for your replies.yes , i executed sys.dm_os_wait_stats and found the following has high wait time
CXPACKET
LAZYWRITER_SLEEP
SQLTRACE_BUFFER_FLUSH
SOS_SCHEDULER_YIELD
how to clear these wait types
thanks
CXPACKET waits are usually an indication of parallelism 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
August 25, 2011 at 7:09 am
Viewing 15 posts - 11,956 through 11,970 (of 22,224 total)