Forum Replies Created

Viewing 15 posts - 31 through 45 (of 148 total)

  • RE: Computed columns: max from other column for the same ID

    No sure to understand

    I want to create a computed column in my table

    So the query should be something like

    "ALTER TABLE myTable ADD computed_Max AS (max(col1,col2)"

    but the command...

  • RE: Cast in Varchar with different options

    davoscollective (7/17/2012)


    Toreador (7/16/2012)


    I was expecting to see a 100% correct rate given that the same thing has appear a lot in QOTDs over the last few months - but currently...

  • RE: Full Backups

    I just focussed on the last three lines and counted the 'begins' and 'commits': 4 begin, 3 commit and only the transaction 4 had been commit after the backup reading...

  • RE: Snapshots

    Chad Crawford (7/19/2012)


    I, like Luis, assumed that the reason the additional snapshots were part of the question was to direct the reader to the correct answer. That being...

  • RE: Snapshots

    I got it right, but only because of my ignorance: for me, a snapshot is a picture of the DB at a precise time, and was not suppose to be...

  • RE: Independence Day 2012

    I would say that it was a very good movie in 1996, but from then, we have the plaisur to see better 🙂

  • RE: Restricting updates?

    Understanding the query was the key here

    Thanks Hugo for the explanation.

  • RE: SSIS 2012 - Versioning

    Koen Verbeeck (6/4/2012)


    Imran Ashraf-452633 (6/4/2012)


    On your link provided it is stating something different.

    http://msdn.microsoft.com/en-us/library/hh479588.aspx

    The objects that are stored in the SSISDB catalog include projects, packages, parameters, environments, and operational...

  • RE: Database downgrade: 64 bits to 32

    I don't want to argue too much on that because I am no expert. I found this site that explains why a 32 bit OS would not run a...

  • RE: Database downgrade: 64 bits to 32

    GilaMonster (5/31/2012)


    tilew-948340 (5/30/2012)


    I guess that today there is a converter by default on Window7 ...

    No converters. Most data files are identical between 32 bit and 64 bit (an app dev...

  • RE: Database downgrade: 64 bits to 32

    GilaMonster (5/30/2012)


    tilew-948340 (5/29/2012)


    I would have bet that it was because a 32 bit operating system can't read a 64 bit file coming from a 64 bit operating system...

    32 bit vs...

  • RE: Database downgrade: 64 bits to 32

    When I tried to read the SLQserver 2008 R2 DB with the SQL server 2008 and it did not work, I would have bet that it was because a 32...

  • RE: Select Statement

    I am a little disapointed that SQL does not convert, in any standard division, the numbers in decimal just in case that the division might be a decimal answer (4/2...

  • RE: MDS

    Koen Verbeeck (4/4/2012)


    ... Surprised this QotD didn't hit 100% correct answer, with the answer so carefully hidden in the title and category 😀

    I thought the title was a typo. ...

  • RE: VIEWS 3

    I knew about non indexed view, but I would have bet fifty box that an indexed view would not take space...

    Good thing you don't take bets :laugh:

    Thanks for the question,...

Viewing 15 posts - 31 through 45 (of 148 total)