Viewing 15 posts - 18,271 through 18,285 (of 22,226 total)
Steve Jones - Editor (2/20/2009)
Thanks, grass....That always gets me a chuckle. I think you might need a dual rotor chopper for that mission!
It should give you a chuckle, Champion. Tunnel...
"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
February 20, 2009 at 12:06 pm
Putts (2/20/2009)
The view is a source to a report. The application works in this manner....
1. User selects report...
"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
February 20, 2009 at 12:05 pm
Lynn Pettis (2/20/2009)
Newbie alert!Think we should try mounting a rescue mission for bvaljalo?
No, I'm enjoying the show. I'll dive back in a bit, maybe. Also, it's possible my bozo bit...
"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
February 20, 2009 at 12:02 pm
Hmmm. I've never run 32 bit SQL Server on a 64 bit machine. Seems to kind of defeat the purpose. But anyway, I don't know the answer to the problem....
"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
February 20, 2009 at 11:59 am
Lisa Phillip (2/20/2009)
Sparse columns REDUCE the space needed not negates: Sparse columns reduce the space requirements for null values at the cost of more overhead to retrieve nonnull values.
Yep. 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
February 20, 2009 at 11:18 am
More information please. Performance counters do work. Are missing all of them or one specific one?
"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
February 20, 2009 at 11:09 am
Robert Davis (2/20/2009)
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
February 20, 2009 at 10:42 am
Bob Hovious (2/20/2009)
I'll drag in another alternate universe and say deploy the thopters to fetch him back before he is devoured by the shai-hulud.
Huh, really? I would have thought 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
February 20, 2009 at 9:34 am
I'm with Bruce. We drop & recreate the indexes when there are massive inserts every night. It usually speeds up the process and you don't get fragmentation.
"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
February 20, 2009 at 8:22 am
Nothing. Sleeping & dormant processes are ones that are still working. The real thing to look for is blocked or blocking processes. If none of those, then you need 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
February 20, 2009 at 7:42 am
Bob Hovious (2/20/2009)
"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
February 20, 2009 at 7:40 am
Jeff Moden (2/20/2009)
"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
February 20, 2009 at 7:37 am
I'm pretty sure they'd be absolutely identical, but run them with profiler or look at the STATISTICS IO output to verify.
"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
February 20, 2009 at 7:12 am
I haven't run into it either. Have you run the Upgrade Advisor? There are things that you must change prior to upgrading the database. If you haven't run the Advisor,...
"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
February 20, 2009 at 7:10 am
You can only update one table at a time, yes, but you can wrap all the updates within a transaction. That will make them all "occur" at the same time.
Probably...
"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
February 20, 2009 at 6:21 am
Viewing 15 posts - 18,271 through 18,285 (of 22,226 total)