<P mce_keep="true"> </P><P>@<STRONG>Luis Martin: </STRONG>Thanks... yes I am 26 right now</P><P><STRONG>@<IMG style="BORDER-RIGHT-WIDTH:...
these are the columns due to which the duplicates are occuring. --sys.partitions (partition id,hobt_id) --sys.allocation_units...
yes, that confuses me even more. i need the details to check which indexes can be elimnated, but it has become even more confusing now [:(]
HI, I mixed and matched many queries to give all details of index needed for analysis. However, the query returns duplicate values. how do i remove...
I am a 5 years experienced SQL Server DBA. As soon as I was out of college, I was trained on SQL Server 2000 and pushed into Database...
Thank you. We cheked but though the RID look up decreased by 1%, the sort which is taking 182% CPU, still remains the same.
We are using a query and in its execution plan it utilizes 182% CPU cost while performing a sort. Please advice on how to reduce it. query structure:...
Hi, We have a report which run 15 store procedures to fetch the data. This report takes 1 hours to process during non buisness hours and about 4...
Separate names with a comma.
