Viewing 15 posts - 9,721 through 9,735 (of 22,224 total)
Sean Lange (7/19/2013)
"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
July 19, 2013 at 8:46 am
I wrote a query that solves this problem for our SQL Monitor tool. You should be able to modify it for your own uses. Here's the query.[/url]
"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
July 19, 2013 at 8:43 am
I was doing some research this morning and got sucked down a rabbit hole (it happens) and landed on a series of sites complaining about Stack Overflow and Stack Exchange....
"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
July 19, 2013 at 8:05 am
Erland Sommarskog (7/18/2013)
Query plans
SQL Server 2014 includes substantial improvements...
"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
July 18, 2013 at 8:44 pm
Koen Verbeeck (7/17/2013)
Grant Fritchey (7/17/2013)
"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
July 17, 2013 at 5:53 am
You should be able to just connect and query the database from Excel. You just use the login that lets you at the data. I've done this from Excel (and...
"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
July 17, 2013 at 5:47 am
I don't know that this will help much, but, I'd look at the properties on the SELECT operator. Is the optimizer completing optimization or is it timing out? 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
July 17, 2013 at 5:44 am
Rebuilding the index defragments the indexes and updates the statistics using a full scan against the data. Then, you're updating statistics. So, the question is, how is that second update...
"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
July 17, 2013 at 5:39 am
While I haven't been able to test it at all yet, there is supposed to be a radically improved statistics engine within 2014. That could be a compelling reason 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
July 17, 2013 at 5:23 am
GilaMonster (7/15/2013)
About bloody time too...
Third!
"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
July 17, 2013 at 5:20 am
ERLAND!
Welcome to the forums at SSC.
I think that what you're seeing is a result of Steve experimenting over time with the structures of the forums. But, I don't think he...
"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
July 17, 2013 at 5:18 am
I'm somewhat inclined to agree with the single database argument here (the issues of backup & recoverability not withstanding).
But, the bigger question for me is the development and release cycle....
"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
July 17, 2013 at 5:17 am
The shortest possible answer is, yes.
But that doesn't take into account that you're clearly not clear on what exactly the transaction log is, what it's doing and why it's doing...
"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
July 17, 2013 at 5:06 am
Brandie Tarvin (7/17/2013)
I've been getting dropped out of SystemX regularly the past week and it just keeps getting worse and is happening on a constant basis....
"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
July 17, 2013 at 4:56 am
Steve Jones - SSC Editor (7/16/2013)
Arrgggg, some days I hate software.
That's perfectly OK. Some days, software hates 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
July 16, 2013 at 3:24 pm
Viewing 15 posts - 9,721 through 9,735 (of 22,224 total)