Viewing 15 posts - 14,446 through 14,460 (of 22,224 total)
You're just going to have to do the work. You will be able to code & automate some of it, assuming your db & schema names map reasonably well. But...
"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 26, 2010 at 4:59 pm
GilaMonster (8/26/2010)
The deadline has been set for about 3 weeks.
The requirements were finished...
"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 26, 2010 at 4:55 pm
WayneS (8/26/2010)
Stefan Krzywicki (8/26/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 26, 2010 at 1:25 pm
Yeah, that setting could certainly result in different execution plans.
To see the plan, try querying the DMV sys.dm_exec_query_plans. You'll need to get a plan handle, probably from sys.dm_exec_query_stats and 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 26, 2010 at 11:37 am
On a guess, check the ANSI settings for the connections. I'll bet you one of them is different.
"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 26, 2010 at 7:03 am
Sounds like the owner of the database was deleted. You just need to set the owner to a valid login
"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 26, 2010 at 6:32 am
WayneS (8/25/2010)
Alvin Ramard (8/25/2010)
GilaMonster (8/25/2010)
Anyone want to help an apparent newbie to create a critical, large database?http://www.sqlservercentral.com/Forums/Topic975128-1292-1.aspx
If he's doing this for my bank, then I'm changing bank! :w00t:
Hah! Read my...
"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 4:44 pm
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
Viewing 15 posts - 14,446 through 14,460 (of 22,224 total)