This is not original query. It's more complicated than this. But in a subquery I use TOP 100 PERCENT. How can I copy the execution plan here. I...
Hi, I have a query like the following statement. My Problem with TOP 100 PERCENT takes this query 12 Seconds time, but if I remove TOP 100 PERCENT I...
Thanks a lot for the information.
Hello, Suppose I have a huge table with 10 Columns. I create a unique constraint on the columns (col1, col2 col3) If I use theese columns in a...
Hi Adrian,<br /><br />I'am trying to run following Procedure, but I am getting the message below.<br />I'am working within master database. For...
Hi, I'am looking for an alternative function of object_name(objid) with a second parameter database_id, because I'am working in master database and...
Hi, How can I get the right object_name of rsj_objid column in SELECT statement using master database. Is there any another function like...
Hi Satya,<br /><br />Thanks for your reply. When I trace SP<img src='/community/emoticons/emotion-7.gif' alt=':S' />tmtStarting or SP<img...
Hi, Is there any possibility to measure start/endtime of a subquery in the procedure like in the following example. I can see start/endtime, if a...
Separate names with a comma.