Viewing 15 posts - 9,271 through 9,285 (of 22,232 total)
And I agree with Sean and Jeff too. I didn't look at their answers first. I was just excited by the questions. These are pretty classic types of issues 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
December 14, 2013 at 5:20 pm
hmbtx (12/13/2013)
Question #1:What are the reasons, if any, for this company to seriously consider a SQL Server upgrade from SQL Server 2000?
Media. Make darn sure you have several copies 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
December 14, 2013 at 5:18 pm
tmlink99 (12/13/2013)
It's odd that nodoby here could just say what you do. Grant said to just rely on the integrity of the publication. Is that it?
I did say...
"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
December 14, 2013 at 12:44 pm
I would if I remembered it. It might have been a conversation I had at SQL Saturday DC. I just don't recall, sorry.
"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
December 13, 2013 at 11:05 am
Not a problem. I just like to be clear when I'm posting for one of our products.
It really is one I used to use all the time for the databases...
"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
December 13, 2013 at 8:47 am
Steve Thompson-454462 (12/13/2013)
joe.eager (12/13/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
December 13, 2013 at 8:36 am
Great opportunity for a third party product. Red Gate SQL Doc[/url] does this extremely well.
And, disclaimer, I work for Red Gate.
"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
December 13, 2013 at 8:25 am
In addition to what Lowell said, how about identifying where the slow down is from the ASP side of things. I'd suggest looking at a tool like this[/url] to identify...
"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
December 13, 2013 at 7:36 am
Hmmmm... Well, it's almost a materialized view, but that's a view with a clustered index which makes it effectively a table. This is different. I guess I'd go with denormalized...
"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
December 13, 2013 at 6:19 am
Yep. Almost definitely disk space.
"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
December 13, 2013 at 6:18 am
So what you're looking for is a SELECT statement. You'll need to especially focus on the column list and the WHERE clause. Read all about it here. If you are...
"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
December 13, 2013 at 3:59 am
I'm with Elliot. I've done lots of programming in and around XML on SQL Server. It's functional. But it's not terribly fast. If you're just talking, writing and reading this...
"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
December 13, 2013 at 3:56 am
I'm not an Oracle person, so my understanding here may be grossly inadequate, but the short answer is No.
The longer answer is, I think, that you're doing lots and lots...
"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
December 13, 2013 at 3:51 am
It's pretty standard to not have domain admin and sometimes not even machine admin. But, you have to have enough privileges to set up the things you need to set...
"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
December 13, 2013 at 3:43 am
But if you're hitting slow performance on inserts/updates, adding a log table to the whole thing is going to slow it down further.
I'd suggest capturing statement level events with extended...
"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
December 13, 2013 at 3:37 am
Viewing 15 posts - 9,271 through 9,285 (of 22,232 total)