Viewing 15 posts - 20,701 through 20,715 (of 22,220 total)
You've got a list of parameters inside the query. You should run your query through sp_get_query_template which will give you the correct output and the list of parameters as 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
April 9, 2008 at 6:33 am
At least you asked a nice simple question...
Learn some relational design methods. Make sure you take the time to pick good clustered indexes for your tables. Concentrate on set based...
"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
April 9, 2008 at 6:10 am
michaela (4/9/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
April 9, 2008 at 5:41 am
Great info. If they relaunch the effort I'll definately use this stuff as a reference. Thanks.
"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
April 8, 2008 at 11:48 am
It was basically functional. The key issues, apart from deployment issues & some performance, were around how we could manage the virtual versions of AD. It apparently wasn't surmountable.
"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
April 8, 2008 at 11:17 am
Yu Yang (4/8/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
April 8, 2008 at 10:30 am
Contrarian...
Goddess bless you. You guys are so entertaining.
"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
April 8, 2008 at 6:33 am
Just for the virtualizations. We already do resets from production as a part of our QA testing. We were just hoping to incorporate a similar process into an automated development...
"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
April 8, 2008 at 5:57 am
The thing is, I think we could have made it work. But the expectations were so unrealistic that while we had functionality, we didn't have perfection. Sans perfections, they pulled...
"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
April 8, 2008 at 5:35 am
Ivanna Noh (4/7/2008)
rbarryyoung (4/7/2008)
Jeff Moden (4/7/2008)
rbarryyoung (4/6/2008)
Jeff Moden (4/6/2008)
Heh... I handed Babbage gears 😉
Good one. 🙂
I was serious about my Uncle though, he really did do all...
"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
April 8, 2008 at 5:27 am
Hopefully you can post the xml as an attachment like Gail says.
Just looking through the text plan, I see a clustered index scan on PK_MSP_WEB_RESOURCES_WRES_ID which could be a cause...
"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
April 8, 2008 at 5:25 am
Profiler output is to a text column, but if you're selecting from a text column in a TSQL Query, you might not be seeing all the data (there's a limit...
"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
April 7, 2008 at 1:24 pm
I did write a couple of articles on unit testing here at SQL Server Central. Two of them cover DBPro and one covers TSQLUnit. Do a search. There might 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
April 7, 2008 at 10:46 am
Most people just insert a row of data into the database, run a select query or a delete query and declare it successful if it finishes without error. For myself,...
"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
April 7, 2008 at 9:22 am
You must be experiencing blocking or something else on the server. This query, as you have it defined, takes 1 ms to run on my laptop (not exactly a screaming...
"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
April 7, 2008 at 8:25 am
Viewing 15 posts - 20,701 through 20,715 (of 22,220 total)