Forum Replies Created

Viewing 15 posts - 241 through 255 (of 285 total)

  • RE: Passed 70-442

    GilaMonster (7/16/2010)

    Not really. The thing was so incredibly easy I think anyone with a passing knowledge of sharepoint and logical deductions could have passed. I scored higher than I ever...

    July 16, 2010 at 12:45 pm

    #1194299

  • RE: Passed 70-442

    GilaMonster (7/16/2010)

    Duncan Pryde (7/16/2010)

    I did think it was amusing that one of the answers to each of the questions was along the lines of "I've never used SQL Server before",...

    July 16, 2010 at 12:23 pm

    #1194282

  • RE: Passed 70-442

    codebyo (7/16/2010)

    Duncan Pryde (7/16/2010)

    Anyone else had these survey questions, or know what Microsoft might be hoping to learn from the answers?

    Duncan

    Congratulations, Duncan! 🙂

    I passed the 70-433 (MCTS) recently I also...

    July 16, 2010 at 12:20 pm

    #1194281

  • RE: Passed 70-442

    GilaMonster (7/16/2010)

    I had them on one of my 2008 exams, can't remember which one. I'd guess they're trying to gauge how difficult the exams are, or something like that.

    Interesting,...

    July 16, 2010 at 7:01 am

    #1194076

  • RE: Predict the outcome

    Rune Bivrin (7/15/2010)

    I couldn't find any mention of the restriction on increment either.

    .

    I agree, there doesn't seem to be any mention in the documentation about it. And it's not just...

    July 15, 2010 at 4:54 am

    #1193361

  • RE: sysxlogin vs. syslogin

    Hi

    sysxlogins is a table, and syslogins is a view, which, looking at the definition, does a few things like convert the database id to a database name. It also converts...

    July 9, 2010 at 8:45 am

    #1190837

  • RE: Tabify Select Lines

    WayneS (7/8/2010)

    Duncan Pryde (7/8/2010)

    It only "tabifies" groups of 4 spaces starting from the left, so if you have 5 spaces at the beginning of the line, you'll get a tab...

    July 8, 2010 at 6:29 am

    #1190191

  • RE: Tabify Select Lines

    It only "tabifies" groups of 4 spaces starting from the left, so if you have 5 spaces at the beginning of the line, you'll get a tab and a space...

    July 8, 2010 at 3:13 am

    #1190082

  • RE: Table Variable :Doesn't care

    Of course, one place this behaviour comes in useful is if you want to store the values from an output clause when rolling back a transaction. Just store them in...

    July 7, 2010 at 1:24 am

    #1189463

  • RE: Table Variable :Doesn't care

    Nice question, thanks.

    According to Books Online, "Transactions involving table variables last only for the duration of an update on the table variable." - Good to know! One of those things...

    July 7, 2010 at 12:48 am

    #1189449

  • RE: More fun with ISNUMERIC()

    Kari Suresh (7/5/2010)

    [p]Thanks Duncan. You are right, master DB is in compatibility level 80 and other databases are in compatibility level 90.[/p]

    No problem. Glad to help.

    Duncan

    July 6, 2010 at 12:35 am

    #1188943

  • RE: More fun with ISNUMERIC()

    savosin_sergey (7/5/2010)

    Thank you, Duncan, you've right - my tempdb at compatibility_level=90 and the query from task returns 21, though my test database has compatibility_level=80

    And thank you for noticing the behaviour...

    July 6, 2010 at 12:34 am

    #1188942

  • RE: More fun with ISNUMERIC()

    Kari Suresh (7/5/2010)

    [p]This query returns count as 20 when executing against "master" DB (excluding '\' ASCII character number 92) and returns 21 when executing with other databases.[/p]

    As I mentioned above,...

    July 5, 2010 at 8:13 am

    #1188782

  • RE: More fun with ISNUMERIC()

    Great question by the way, thanks!

    Duncan

    July 5, 2010 at 5:22 am

    #1188736

  • RE: More fun with ISNUMERIC()

    savosin_sergey (7/5/2010)

    My Count is only 20 (while right answer is 21)! Here is text result of the query from Question:

    Count String

    ----------- -----------

    20 ...

    July 5, 2010 at 5:20 am

    #1188735

Viewing 15 posts - 241 through 255 (of 285 total)