Viewing 15 posts - 20,011 through 20,025 (of 26,484 total)
You also have six correlated subqueries with select distincts. Each of those queries has to be run for each row.
It would help if you could provide use with the...
July 2, 2009 at 3:32 pm
taurus2050 (7/2/2009)
It is a stored procedure, and the input parameters are the source cod01, cod02 and cod03 and the destiny cod01, cod02 and cod03.
The table has these rows as example:
1234...
July 2, 2009 at 3:16 pm
Krasavita (7/2/2009)
July 2, 2009 at 1:25 pm
SUBRAHMANYA HEDGE (7/2/2009)
Let's say for eg., one of my job is running in a clustered instance and a failover...
July 2, 2009 at 12:26 pm
Yes, it will take additional space. This could be a vaild concern. You have to be the judge on this.
Yes, there is the overhead to maintain the index....
July 2, 2009 at 12:14 pm
David Webb (7/2/2009)
Isn't this the same problem you were working with here:('http://www.sqlservercentral.com/Forums/FindPost745975.aspx')
?
Link as coded above doesn't work. Here is a working link: http://www.sqlservercentral.com/Forums/FindPost745975.aspx
July 2, 2009 at 12:07 pm
Still clear as mud. How are you getting the parameters? Is this a store procedure you are trying to write? what is the expected output from the...
July 2, 2009 at 12:03 pm
joemai (7/1/2009)
Yes, table does have identity column.Data will always have both weight and height; otherwise, they will be null on both fields.
Maijoe
Not totally sure what questions you are answering or...
July 2, 2009 at 11:59 am
I agree as well, read BOL (Books Online). It just doesn't make sense for us to copy it here. If you have any specific questions as you are...
July 2, 2009 at 11:56 am
There are those out there that will tell you that every table should have a PK. There will even be those who may even advocate that it should be...
July 2, 2009 at 11:54 am
I realize the OP didn't really provide everything that we really need to help, but this actually answers the OP's question?? :sick:
July 2, 2009 at 11:34 am
taurus2050 (7/2/2009)
cod01 cod02 cod03 codA codB and some other stuff that is not important for this.
The information is this:
1234 0 0 02 01
5678 0...
July 2, 2009 at 11:07 am
Okay. Thank you for the feedback.
Happy Holidays!!
July 2, 2009 at 10:56 am
SpyCraft (7/2/2009)
July 2, 2009 at 10:51 am
Elliott (7/2/2009)
If it is a one shot then the best way is to generate a full backup and...
July 2, 2009 at 10:48 am
Viewing 15 posts - 20,011 through 20,025 (of 26,484 total)