Viewing 15 posts - 9,721 through 9,735 (of 22,219 total)
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
Brandie Tarvin (7/15/2013)
Jan Van der Eecken (7/15/2013)
Grant Fritchey (7/15/2013)
... I didn't even have to show the card to join the Navy....
I hope Lynn doesn't see this before he gets 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 15, 2013 at 11:32 am
Stefan Krzywicki (7/15/2013)
Grant Fritchey (7/15/2013)
Brandie Tarvin (7/15/2013)
hvermaak (7/15/2013)
Brandie Tarvin (7/15/2013)
GilaMonster (7/15/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 15, 2013 at 10:44 am
Brandie Tarvin (7/15/2013)
Grant Fritchey (7/15/2013)
Brandie Tarvin (7/15/2013)
Though American social security cards don't have chips. They're just little paper cards.
Little paper cards that no one has. I lost mine before 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
July 15, 2013 at 5:26 am
Lynn Pettis (7/14/2013)
How would I directly query Redgate Backup data tables to extract 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
July 15, 2013 at 5:03 am
Brandie Tarvin (7/15/2013)
hvermaak (7/15/2013)
Brandie Tarvin (7/15/2013)
GilaMonster (7/15/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 15, 2013 at 4:56 am
Viewing 15 posts - 9,721 through 9,735 (of 22,219 total)