Viewing 15 posts - 9,841 through 9,855 (of 22,224 total)
You sure there's not something else at work here? I just tested your code and it's working fine. There's no intervening code of any kind?
"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
May 9, 2013 at 3:48 am
Yeah, no real way to tell you how to improve a query without seeing that query. Imagine I said my car wasn't running well and asked you to fix 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
May 8, 2013 at 8:54 am
For error number one, it sounds like you're trying to cast something from a varchar to a date that can't be converted. For example '3 March 2013' can be, 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
May 8, 2013 at 8:52 am
I'm nominating ChrisM@Work for saint hood.
And, he should be charging for the amount of work he's doing for one company in India. 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
May 8, 2013 at 7:38 am
tony28 (5/8/2013)
select ORDER_DATE from TB_INSPECTION_DETAIL WHERE ORDER_DATE='20130507' and COMMIT_NO='0085'
subtree cost
IX 0,0032838...
"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
May 8, 2013 at 6:48 am
For an immediate snapshot for what's going on, INPUT_BUFFER is very SQL Server 2000. Switch to the Dynamic Management Objects such as sys.dm_exec_requests and sys.dm_exec_query_stats as the previous poster said....
"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
May 8, 2013 at 5:52 am
Without the plan itself (saved & posted as XML as the previous poster said) it's hard to make serious suggestions to you. But, the one thing I can tell 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
May 8, 2013 at 5:49 am
All the enhancements around extended events are pretty excellent. I'm also enamored of the distributed replay mechanism (although I wish it worked with extended events too). Availability Groups are extremely...
"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
May 8, 2013 at 5:46 am
todd.ayers (5/7/2013)
ok...
minimal Access experience / No SQL experience and I am going to assume no app dev skills either...correct?
you talk about existing databases...what platform are these currently on...who currently manages...
"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
May 7, 2013 at 11:57 am
todd.ayers (5/7/2013)
OK... so in lieu of access what could I use to act as a GUI for the users?
Well, there's the rub. There isn't both an easy and effective way...
"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
May 7, 2013 at 11:01 am
Sean Lange (5/7/2013)
Grant Fritchey (5/7/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
May 7, 2013 at 9:39 am
Funny you should ask this because the newest version of Access is running SQL Server. The Jet engine is gone. It's just a really fancy GUI on top of SQL...
"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
May 7, 2013 at 8:52 am
rodjkidd (5/7/2013)
Some pictures of a couple of people you may know of from the Medieval evening as SQLbits...Cheers,
Rodders...
Ah, Templar photo-bombing at it's best. WHOOP!
"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
May 7, 2013 at 4:48 am
Still back to mine and Lynn's original answer. The view has fewer columns than the base tables and that alone can make the difference. Also, it's possible that the statistics...
"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
May 7, 2013 at 3:48 am
Yeah, pretty much. The execution time and the resources used are reasonably accurate measures. The estimated costs are just that, estimates. They are the only numbers we have within execution...
"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
May 7, 2013 at 3:43 am
Viewing 15 posts - 9,841 through 9,855 (of 22,224 total)