Viewing 15 posts - 14,461 through 14,475 (of 22,232 total)
Alvin Ramard (8/25/2010)
[vent]Worst performance for any web site I've ever been to: https://www.technicalcommunity.com
Guess which big company name is in the upper left hand corner.
Something has to be done about this!!
[/vent]
Ha!...
"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
August 25, 2010 at 1:25 pm
And, to a large degree, it depends on the other data that is being retrieved by the query. Do you need INCLUDE columns? Should the SSN be part of 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
August 25, 2010 at 1:20 pm
Yeah, this might be worth a blog post, there's not much out there.
In a nutshell, I'm using XML as the data source. So the type of data source is xml...
"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
August 25, 2010 at 12:15 pm
fairyuseless (8/24/2010)
First the "outside" i said means not only through the internet but anywhere except executing the sql code like...
"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
August 25, 2010 at 5:41 am
Jeff Moden (8/24/2010)
Grant Fritchey (8/24/2010)
I need the XML query within Reporting Services, not a regular XML XQuery, the one that is part of defining a data set.
Sorry to bug 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
August 25, 2010 at 5:31 am
Jeff Moden (8/24/2010)
Grant Fritchey (8/24/2010)
This won't be a popular answer, but, you're an MVP. You have access to a full license. You just have to register and turn it on.
It's...
"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
August 25, 2010 at 5:22 am
Sorry guys, I guess I wasn't clear enough. I need the XML query within Reporting Services, not a regular XML XQuery, the one that is part of defining a data...
"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
August 24, 2010 at 7:21 pm
That's a pretty big topic. In fact, books have been written on it...
Basically, you need to start with identifying what is "normal" on your system. Gather metrics on CPU, disk,...
"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
August 24, 2010 at 8:15 am
To really drill down on specific solutions, yeah, a copy of the query (or queries) you're running, sample structure, sample data, and, most importantly, actual (not estimated) execution plans.
But, in...
"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
August 24, 2010 at 8:08 am
I've never had the system time reset on a server before. In most enterprise systems I've worked, we have a system clock that sets the time for the servers. 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
August 24, 2010 at 8:05 am
This is a duplicate of this question. Please don't do that. I just confuses the conversation and makes it harder for people to read and understand what's going on. Please...
"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
August 24, 2010 at 8:03 am
Yes & no. I've worked in places that had ZERO process and I was only able to survive for about 9 months before I started looking for work. But I've...
"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
August 24, 2010 at 7:54 am
Steve's right, check the ANSI settings on the connections. There could be something there.
It's also possible that you're seeing parameter sniffing. The way you describe it, you have "outside" connections...
"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
August 24, 2010 at 7:52 am
Jeff Moden (8/23/2010)
Grant Fritchey (8/17/2010)
Jeff Moden (8/17/2010)
Alvin Ramard (8/17/2010)
"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
August 24, 2010 at 5:32 am
The one thing that I see missing from this process is any hint that you're using some type of source control. As a matter of fact, I think a lot...
"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
August 23, 2010 at 6:12 am
Viewing 15 posts - 14,461 through 14,475 (of 22,232 total)