Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Timestamps Expand / Collapse
Author
Message
Posted Saturday, May 4, 2013 2:08 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 6:20 AM
Points: 1,335, Visits: 1,312
Comments posted to this topic are about the item Timestamps



See, understand, learn, try, use efficient
© Dr.Plch
Post #1449463
Posted Sunday, May 5, 2013 1:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:44 AM
Points: 1,124, Visits: 513
I think the answer is wrong as statement #7 runs succesfully and returns 0 rows & also statements #8 run succesfully and didn`t fail for any reason!!

Any explanation dear author?!!
Post #1449500
Posted Sunday, May 5, 2013 11:08 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 6:20 AM
Points: 1,335, Visits: 1,312
hany.helmy (5/5/2013)
I think the answer is wrong as statement #7 runs succesfully and returns 0 rows & also statements #8 run succesfully and didn`t fail for any reason!!

Any explanation dear author?!!

Did you run it as a batch or as separate statements? Question is written as a single batch.




See, understand, learn, try, use efficient
© Dr.Plch
Post #1449529
Posted Sunday, May 5, 2013 6:12 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:02 PM
Points: 5,563, Visits: 24,696
Nice question for a Monday ... great start to the week

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1449552
Posted Sunday, May 5, 2013 10:58 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 10:35 AM
Points: 1,104, Visits: 687
Author should emphasize that it will be one batch. It will be too many wrong answers.
Post #1449581
Posted Sunday, May 5, 2013 11:26 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
I think author did mention it clearly that execute all statement in a single batch.
Due to that i lose my points..




Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1449585
Posted Sunday, May 5, 2013 11:59 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 6:20 AM
Points: 1,335, Visits: 1,312
Evgeny (5/5/2013)
Author should emphasize that it will be one batch. It will be too many wrong answers.

The question states the batch in the very beggining, there are no batch separators, and answers contain "not run due to previous errors". I think it's enough.




See, understand, learn, try, use efficient
© Dr.Plch
Post #1449587
Posted Monday, May 6, 2013 12:06 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, July 10, 2014 11:20 AM
Points: 1,888, Visits: 2,323
Danny Ocean (5/5/2013)
I think author did mention it clearly that execute all statement in a single batch.
Due to that i lose my points..

Me too lose the points



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1449590
Posted Monday, May 6, 2013 12:22 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 654, Visits: 882
I didn't read question carefully...so lose the question.
Post #1449591
Posted Monday, May 6, 2013 12:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
I too rushed (over read "batch") and got the question wrong!

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1449592
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse