Viewing 15 posts - 12,061 through 12,075 (of 22,219 total)
What level are you looking for? Low level, this is how indexes are stored kind of stuff, or high level, this is what SSRS is for which is different than...
"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 17, 2011 at 5:24 am
BrainDonor (8/16/2011)
Grant Fritchey (8/12/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 16, 2011 at 5:26 am
Have you had a radical increase in the size of the database? If it's exactly the same size (or near enough to it), then I'd guess some form of contention....
"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 15, 2011 at 12:18 pm
Kiara (8/15/2011)
Grant Fritchey (8/15/2011)
Anyone you need to check with to say nice things about Red Gate? Nope!
However, pass the word on how the presentation went, how many people attended, if...
"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 15, 2011 at 11:35 am
Kiara (8/15/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 15, 2011 at 10:21 am
Steve Jones - SSC Editor (8/15/2011)
Grant Fritchey (8/15/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 15, 2011 at 10:18 am
Kiara (8/15/2011)
Grant Fritchey (8/15/2011)
Kiara (8/15/2011)
GilaMonster (8/14/2011)
Anyone want to add anything here: http://www.sqlservercentral.com/Forums/Topic1158751-10-1.aspx. Looks like the guy's making decisions for all the wrong reasons, lot of arrogance of youth there too
*sigh*...
"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 15, 2011 at 6:19 am
GilaMonster (8/15/2011)
Grant Fritchey (8/15/2011)
He's young and male. Therefore, he's a moron.
My take too, and why I mostly ignored that comment. Plus for the last year I've been working 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
August 15, 2011 at 6:18 am
There's no easy way to move a sub-set of the data. You have to take into account that there are so many relationships to maintain between all the tables, 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
August 15, 2011 at 6:10 am
Kiara (8/15/2011)
GilaMonster (8/14/2011)
Anyone want to add anything here: http://www.sqlservercentral.com/Forums/Topic1158751-10-1.aspx. Looks like the guy's making decisions for all the wrong reasons, lot of arrogance of youth there too
*sigh* I wish 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
August 15, 2011 at 6:03 am
If you loathe technology, don't do it. It's not worth it. I love technology and sometimes hate this job. If I didn't absolutely love the problems I was dealing 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
August 15, 2011 at 6:00 am
Also, if your servers are getting that out of sync, you might want to reexamine your development and deployment processes. Tools like SQL Compare will help a lot, but having...
"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 15, 2011 at 5:40 am
Some DDL operations are also available in the default trace, but not all.
Otherwise, you need to set up a system for monitoring this ahead of time.
"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 15, 2011 at 5:39 am
You're scanning almost 11 million rows. That's just going to be slow. No way to add some WHERE clauses to the query to limit the result set? Add in 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
August 14, 2011 at 6:12 am
I concur. You need to address the root causes, not simply try to limit the size of tempdb. In fact, as you're finding, you won't be able to. If whatever...
"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 14, 2011 at 5:18 am
Viewing 15 posts - 12,061 through 12,075 (of 22,219 total)