Forum Replies Created

Viewing 15 posts - 13,921 through 13,935 (of 39,919 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/9/2012)


    Okay, I know that there was a recent forum thread about upper and lower case keywords. The last post had a link to a site that could...

  • RE: SQL Server on RDS

    sku370870 (5/9/2012)


    On the one hand it's silly but, on the other, you're sure it happens. Obviously all those sites you've mentioned have a lot more to them than just some...

  • RE: what does 'type' in syscolumns correspond to ?

    sys.columns - http://msdn.microsoft.com/en-us/library/ms176106.aspx

    sys.types - http://msdn.microsoft.com/en-us/library/ms188021.aspx

    SELECT TOP 10

    'column' = c.name

    , 'datatype' = t.name

    , *

    FROM sys.columns c

    INNER JOIN sys.types t

    ON c.default_object_id =...

  • RE: tlog backup way bigger than .ldf, not bulk-logged...

    NJ-DBA (5/8/2012)


    actually, dont even need to take a full... can change to simple recovery, back to full the do a diff, then start tlog backups, as described by Mr. Randall...

  • RE: Mobile Password Protection

    Eric M Russell (5/9/2012)


    Personally, I don't own an iPhone, Android device, or whatever. If I did, I'd keep my Hotmail or Gmail account stuff in the cloud and not have...

  • RE: Table Trigger works for one user but not the other

    Excellent catch, Eugene. (Doh, should have seen that myself)

    Glad you figured it out, joshd1807.

  • RE: Are the posted questions getting worse?

    WayneS (5/9/2012)


    First of all, congrats to both of you for working together for this goal.

    But secondly.... seriously? fun working in the barn? mucking it out?

    LOL, she's actually cleaning it...

  • RE: SQL Server on RDS

    CriticalStatus (5/9/2012)


    other than that, production should be served internally or your own managed DMZ server and maintained properly where you KNOW it will be backed up, updated, etc.

    ???

    Served internally is...

  • RE: SQL Server on RDS

    Aaron N. Cutshall (5/9/2012)


    Does it have the same physical limitations as SQL Azure? If so, then what's the advantage of their approach?

    I don't have an exact comparison, but...

  • RE: SQL Server on RDS

    hakim.ali (5/9/2012)


    Which brings me to my point: any word on how the two compare? Amazon RDS vs SQL Azure.

    Not yet, and I haven't done much probing in Azure. It's worth...

  • RE: SQL Server on RDS

    sturner (5/9/2012)


    "...And they'll even handle the backups automatically for your new database. "

    making backups is only 1 tenth of the infrastructure involved with hot standby-failover or DR procedures which typically...

  • RE: SQL Server on RDS

    george 86905 (5/9/2012)


    First of all, I love this site, and therefore, by extension, I love Steve Jones, I suppose. You guys have saved me many hours of deadends and the...

  • RE: Setup SQL Server on Amazon RDS

    Adrian Sims-154382 (5/9/2012)


    Yesterday I was 'handed' 2 Amazon SQL servers that was set up by someone else ( not a DBA ) , and I hope you have a very...

  • RE: SQL Server on RDS

    Markus (5/9/2012)


    Do you control the backups/restores? Is SQL Server patched automatically if a service pack or security patch comes out? If so, and it causes issues with your...

  • RE: SQL Server on RDS

    sku370870 (5/9/2012)


    You've spend hundreds of hours developing. A lot of your business logic is in your stored procedures and functions. You can't afford SQL Server hosting of your own. You...

Viewing 15 posts - 13,921 through 13,935 (of 39,919 total)