We use the Enterprise Translation Server from SDL in Real Time which might be helpful to you....
quote:Originally posted by satya First of all why you're using EM to accomplish this task, as you can take help of query analyzer by running SP_HELP...
I have a situation where there are about 400 sps for a database. It has been so much pain everytime to find out a particular SP ( I wish it works for...
Perhaps this is one of the best methods of deleting duplicates Thanks Mr. bradmcgehee Chandra Paladugu
I uploaded the image to my site at tripod, please see the execution plan at http://cpaladugu.tripod.com/
quote:Originally posted by mmarovic What index is used for both queries? You group by column that is not part of select list, but you don't have...
Yes sir, I am using aggregate functions. Following is the exact query I am using, of course I replaced original names with fictitious values. SELECT...
quote:Originally posted by mmarovic quote:--I am trying to get the records for year 2003 SELECT ID, DATE_ADDED FROM SAMPLE_TABLE WHERE DATE_ADDED...
quote:Originally posted by saleyoun You may want to try partinioned views, so whenever you're looking for 2003 data, you'll be accessing 2003 table....
Thanks for your replies Adriaan.<br /><br />I work in a Search Engine realted filed, where we measure response time in milli/nano seconds, Obeviously...
We already have a Clustered Index on other field which is the ID. I don't know what the design ideas means? I think the issue here is the number of...
Its a situation where we have about 120M records from a view (extracted from 2-3 tables) one of the filed is DATE_ADDED (smalldatetime). We have data...
Separate names with a comma.
