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 04, 2013 2:08 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:47 PM
Points: 1,298, Visits: 1,306
Comments posted to this topic are about the item Timestamps



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


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 3:59 AM
Points: 929, Visits: 380
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 05, 2013 11:08 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:47 PM
Points: 1,298, Visits: 1,306
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 05, 2013 6:12 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:24 PM
Points: 5,471, Visits: 23,523
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 05, 2013 10:58 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 06, 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 05, 2013 11:59 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:47 PM
Points: 1,298, Visits: 1,306
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 06, 2013 12:06 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 14, 2014 11:50 PM
Points: 1,867, Visits: 2,275
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 06, 2013 12:22 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 12:54 AM
Points: 606, Visits: 812
I didn't read question carefully...so lose the question.
Post #1449591
Posted Monday, May 06, 2013 12:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:46 AM
Points: 1,371, Visits: 1,547
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