Viewing 15 posts - 46 through 60 (of 219 total)
It sometimes keep on showing this.Main thing is to make sure that you have that index and that index has improved your query performance. Also, before creating index make sure...
July 5, 2012 at 2:54 am
What is the reason to keep the select in the transaction? This might be causing the issue.It should be outside of the transaction. What is the isolation level?
Can you post...
July 5, 2012 at 2:51 am
I want to know if it is possible to group by XXX XXX:XXX XXX: so the first two values ending in :
I am not sure I got it. Are you...
July 5, 2012 at 1:17 am
if i get it right ( from your other post).. you want to monitor few procs. Then I would suggest that try extended events ( or even traces) and cpature...
July 4, 2012 at 9:12 am
Try DMV's to see the plan and stats of these procedures,if it is still in cache.. Then that might give you idea on how to proceed. Trace will collect too...
July 4, 2012 at 8:57 am
hello fellas,i need some code or logic that will always provide the last day of any year.i know its a vague question but any help is appreaciated. thanks
Last day...
July 4, 2012 at 8:47 am
I assume that these SP's are running only during the batch and are not used during say daytime or like that as these drop and recreate indexes.
Try to capture the...
July 4, 2012 at 8:35 am
Not all DMV's cause performance issue as this data is collected by the sqlserver only overhead is to query them.
Some DMV's data is not collected by sql server but...
July 4, 2012 at 8:26 am
You have two join conditions and these columns doesnt have the any statistics defined and thus uses default stats and which are causing the issue.
AND ( TPTRJO1.STATUS NOT IN (...
July 4, 2012 at 7:18 am
In Sybase people use the ANSI standrad but still there are people who use old style. For left join almost everyone uses the ansi standard as the old syntax *=...
July 4, 2012 at 6:04 am
First of all thank you for the information..
sys.dm_db_index_physical_stats table returns 2026 no of columns and the reason we have nvarchar data type is we need to support characters other than...
July 4, 2012 at 5:28 am
I can not see the graphical plan but i could see the xml in text pad. It is using parallelism and in number of cases only one thread is bringing...
July 4, 2012 at 4:51 am
I am not sure why you have so many column defined as nvarchar(64) which could be defined either as float,datetime, int,and normal varchar.
This is the second instance on this forum...
July 4, 2012 at 4:33 am
Anthony,
I need to add one of these link in my signature.
July 4, 2012 at 4:09 am
Can you please post the ddl of tables and the graphical sqlplan?
July 4, 2012 at 4:06 am
Viewing 15 posts - 46 through 60 (of 219 total)