Viewing 15 posts - 20,866 through 20,880 (of 22,232 total)
Certain To Perish?:hehe:
"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
March 14, 2008 at 5:38 am
Sunspots, seismic activity, who knows. If a page gets written over in some manner, you're probably only going to see it in two calls, the one that wants the page...
"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
March 14, 2008 at 5:35 am
I don't know if I'd call poking holes in water the "front lines" but from what I saw of the AF, you guys had it pretty sweet.
And Jeff, don't be...
"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
March 14, 2008 at 5:32 am
Sounds like you might have a corrupt database. Can you try running DBCC checkdb() against 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
March 13, 2008 at 7:55 pm
Jeff Moden (3/13/2008)
Grant Fritchey (3/13/2008)
That's why they call us glowy bubble-heads....
Heh... I knew I liked you for some reason... I was the Sr. Ping Jockey forward of frame...
"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
March 13, 2008 at 7:51 pm
Matt Miller (3/13/2008)
Grant Fritchey (3/13/2008)
"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
March 13, 2008 at 7:48 pm
That's why they call us glowy bubble-heads....
I was working Engine Room Lower Level one day when the Upper Level guy was starting up one of the electrical generators. It's 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
March 13, 2008 at 12:42 pm
Brandie Tarvin (3/13/2008)
At least your "current" employer was looking out for you, though. Still, it would have been...
"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
March 13, 2008 at 10:50 am
Based on the description I still don't understand what the temporary view was doing for the query in question.
"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
March 13, 2008 at 8:56 am
I got hired once because I'd been in the Navy... that's as close as I've got to an "outside" talent getting me hired story... Jeez, that sounds pathetic.
"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
March 13, 2008 at 8:29 am
What would a "temporary" view do that a query doesn't?
"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
March 13, 2008 at 8:03 am
You ought to go and read up on these topics in the Books Online(BOL) (the SQL Server documentation that gets installed with the product). Then, if you have specific questions...
"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
March 13, 2008 at 7:59 am
Course not. I wasn't worried about that. But I was being lazy & you caught me on 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
March 13, 2008 at 7:35 am
Yeah but when you run two queries each shows a relative cost to the execution as a whole. Usually the speedier, lower cost, process shows as a smaller percentage of...
"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
March 13, 2008 at 7:14 am
Can you show the execution plan for this query? Output it as XML and attach it to a post.
You may want to look at SSIS as a mechanism for moving...
"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
March 13, 2008 at 7:03 am
Viewing 15 posts - 20,866 through 20,880 (of 22,232 total)