Forum Replies Created

Viewing 15 posts - 1 through 15 (of 78 total)

  • RE: Difference between varchar(max) and varchar(8000)

    John Mitchell-245523 - Thursday, April 12, 2018 4:51 AM

    Saurabh Dwivedy - Thursday, April 12, 2018 4:40 AM

    April 12, 2018 at 10:56 am

    #1986636

  • RE: Difference between varchar(max) and varchar(8000)

    Here are two pieces of code I ran today to check the maximum number of characters that a VARCHAR(MAX) can accommodate.
    --===== Query 1
    DECLARE @val...

    April 12, 2018 at 4:40 am

    #1986538

  • RE: Wide Data Frames

    Even though I selected the right choice (option a) - it says wrong answer. Not sure what’s the matter?

    February 14, 2018 at 9:31 am

    #1979766

  • RE: TRUNCATE in TRANSACTION

    Tom.Thomson (1/6/2011)

    Saurabh Dwivedy (1/5/2011)

    Tom I wanted to ask you...what does your signature mean? I am referring to these words below

    Na tog mi gun tuit mi ach ma thuiteas tog!

    OK, here...

    January 7, 2011 at 3:36 am

    #1270531

  • RE: TRUNCATE in TRANSACTION

    Tom.Thomson (1/5/2011)

    sjimmo (1/5/2011)

    UMG

    But have you used 8" floppy disks?

    They flew so much better across the data center. How about the 5MB platters used to make the disk packs?:-P

    5MB...

    January 5, 2011 at 10:57 pm

    #1269866

  • RE: TRUNCATE in TRANSACTION

    Speaking of craftiness I just realized that the title of the question is TRUNCATE IN TRANSACTION and if you notice - the question tests every word of it --- TRUNACATE,...

    January 5, 2011 at 12:57 am

    #1269320

  • RE: TRUNCATE in TRANSACTION

    Fantastic question ... but just 1 point for this? I am a bit surprised 🙂

    As some of you have noted - I missed the Union All too. But where I...

    January 5, 2011 at 12:53 am

    #1269317

  • RE: Merry Christmas

    Good fun! Thanks Steve for the points-harvest 😀

    December 30, 2010 at 5:43 am

    #1267626

  • RE: Predict the outcome of the SQL statements

    Thanks for explaining it clearly. I had missed this point.

    September 2, 2010 at 12:11 am

    #1215420

  • RE: What will happen?

    ziangij (8/31/2010)

    DECLARE @a INT

    DECLARE @b-2 DATETIME

    SET @b-2 = @a

    implicit conversion from int to datetime works fine 🙂

    Is this dependent on the sql...

    September 1, 2010 at 2:58 am

    #1214790

  • RE: HAVING without GROUP BY

    Thanks Hugo - this is an awesome question! Tests fundamentals and has appropriate choices as well... Pls keep posting such gems!

    August 30, 2010 at 11:59 pm

    #1214045

  • RE: SSIS Precedence

    Michael Riemer (8/19/2010)

    Interesting question!

    I don't quite see how the first answer doesn't also qualify if the group is within the sequence container? Depending on the nesting you have in...

    August 23, 2010 at 12:59 am

    #1210262

  • RE: INDEX ON TABLES

    satya.sakamuri (5/12/2010)

    its a homework assignment,thanx for the BOL link.

    This is one of the most amazing threads I have read on SQL Server Central forums in a while. A fresher...

    May 12, 2010 at 7:08 am

    #1166166

  • RE: Full Text Search

    I suggest you refer to the following link on BOL http://msdn.microsoft.com/en-us/library/ms142591.aspx

    This should hopefully shed more insight into the nature of full-text queries. Every feature comes with a set...

    March 11, 2010 at 7:44 am

    #1132045

  • RE: Full Text Search

    Kindly make sure that you (or the authorized DBA in your organization) have created the full-text index on the column(s) you intend to search.

    March 7, 2010 at 11:36 pm

    #1129854

Viewing 15 posts - 1 through 15 (of 78 total)