Viewing 15 posts - 796 through 810 (of 2,463 total)
Robert Davis (8/7/2012)
Read my tempdb whitepaper: http://www.idera.com/Action/RegisterWP.aspx?WPID=37
its not working
November 20, 2012 at 2:33 am
Brian-444611 (11/15/2012)
November 20, 2012 at 1:13 am
sqlnaive (11/20/2012)
Secondly, when once again I removed the clustered index and ran the query, it...
November 20, 2012 at 12:56 am
ch.omkarreddy (11/20/2012)
in the above i mentioned,the requirement of client is that he need transaction_id starting with 6 digit number and auti-incrementing.......
that is what i explained plus link i...
November 20, 2012 at 12:20 am
tonyarp05 61903 (11/19/2012)
Can you give the script how to search
see this http://gallery.technet.microsoft.com/scriptcenter/c0c57332-8624-48c0-b4c3-5b31fe641c58
November 20, 2012 at 12:20 am
ch.omkarreddy (11/19/2012)
the above table i created should have its transactio_id auto-incremented begining with 6 digit number
your requirement is not clear here but what i can assume here is you...
November 19, 2012 at 11:46 pm
a script can be used where you can dynamically pass the table and column names. but this will be time consuming task . as it needs to scan EVERY COLUMN...
November 19, 2012 at 11:43 pm
charit0819 (11/19/2012)
Can any one plz tell me how to delete records from minimum 3 tables using inner join on the basis of a condition
this link will give you couple...
November 19, 2012 at 11:01 pm
hi2u (11/19/2012)
Does the trigger keep the initial (TABLOCK, XLOCK) or the lock is released and another one is made for the trigger?Thanks
Yes to maintain the atomicity there will be...
November 19, 2012 at 10:59 pm
durai nagarajan (11/19/2012)
only some of them got in to wrong data.
There has to be some thing in query itself ..you are overlooking somethng
November 19, 2012 at 10:27 pm
durai nagarajan (11/19/2012)
No, for some empcode and date combination the output is right for some it is wrong.
have you try to check or verify the data with the direct...
November 19, 2012 at 4:36 am
Kristian Ask (11/19/2012)
If the included columns is not creating a covering index, will the included columns still be read or is it then only using the table?
yes they will...
November 19, 2012 at 4:35 am
durai nagarajan (11/19/2012)
thanks, will checkjust a doubt this will have to slow down my query why my output has to vary?
your parameter to this sp is @date /...
November 19, 2012 at 3:34 am
durai nagarajan (11/19/2012)
WHERE CONVERT(DATETIME, CONVERT(VARCHAR, @date, 101)) BETWEEN FromDate AND ToDate
this is the code which is creating problem as its not using the index for search (if...
November 19, 2012 at 3:00 am
Viewing 15 posts - 796 through 810 (of 2,463 total)