Forum Replies Created

Viewing 15 posts - 12,811 through 12,825 (of 39,963 total)

  • RE: Primary or Unique Key on table accepting bulk load

    The key prevents duplicates. As to what fails in the load, the transaction with the dup fails. If that's the entire load, the entire load fails. You can commit in...

  • RE: Service Broker doubt

    It depends what you mean by activate. Just turn it on, no. If you enable queues and something puts data in them, then it could affect performance if the queues...

  • RE: A Computer Goes to College

    I think some of the idea here is to see if we can do, or the DeepQA stuff can do, what Eric suggests. I thought I'd read the the medical...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/7/2013)


    Now that's funny because I'd say exactly the opposite. Degrees really, really matter but MOST of them are probably useless (saying that with no degrees and still employed...

  • RE: Updating Views

    alex.d.garland (2/7/2013)


    Hugo Kornelis (2/7/2013)


    paul s-306273 (2/7/2013)


    Steve - 0 points to you for creating a view using 'select *'...

    😛

    So how should Steve have made a QotD about the dangers of select...

  • RE: Discourse.org

    Brandie Tarvin (2/7/2013)


    Discourse apparently does not like me. I can't seem to get it loaded.

    I'll try again later.

    They reimage the system regularly, and I've had some flakiness. My guess is...

  • RE: A Computer Goes to College

    Miles Neale (2/7/2013)


    Back in 1975 IBM or one of it's team unofficially stated it would take a two story computer the size of the state of Texas to replicate the...

  • RE: Discourse.org

    I think they've moved to tags instead of categories, which I like. That's one thing I'd liket o have here.

  • RE: Are the posted questions getting worse?

    I sent this to a few people, but anyone with comments on this platform, please feel free to post them. I've set up a forum here for feedback, comments, discussion,...

  • RE: Data Journalism

    Miles Neale (2/6/2013)


    It has been said that every picture tells a story. Well every picture can tell many stories depending on the perspective of the viewer/teller. Our data...

  • RE: SQL Server 2012 licensing

    AFAIK, every physical core/CPU in a server has to be licensed if SQL Server can use it, even potentially. The affinity mask doesn't count here. I assume that for VMs,...

  • RE: Avamar Transaction Log Backup Issue

    SQLRNNR (2/5/2013)


    Expanding on Steve's script a little, here is one that I did:

    Show off

  • RE: SQL Server 2012 licensing

    A couple things: AlwaysOn is Enterprise only. I forgot about that, so your read only replica is going to be core licensed if you go that route.

    For replication, it doesn't...

  • RE: Avamar Transaction Log Backup Issue

    This should help:

    SELECT T1.Name AS DatabaseName,

    Isnull(Max(T2.recovery_model), 'No Backup Taken') AS recovery_model,

    'Log' AS BackupType,

    Isnull(CONVERT(VARCHAR(23), CONVERT(DATETIME, Max(T2.backup_finish_date), 131)), '') AS LastBackUpTaken

    FROM sys.sysdatabases T1

    LEFT...

  • RE: The Cloud in Large IT Shops

    Miles Neale (2/5/2013)


    Remember how things work. Bleeding edge -> cutting edge -> early adopters -> the norm -> late bloomers and never made its. There is a cycle....

Viewing 15 posts - 12,811 through 12,825 (of 39,963 total)