Forum Replies Created

Viewing 15 posts - 436 through 450 (of 686 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (8/2/2011)


    I used about 500-700 minutes a month, and about 350-400GB of data + who knows how much on wifi.

    Ahh... that explains the disappearing unlimited data...

  • RE: Today's Random Word!

    debtceiling (just go with it)

  • RE: what daily activities of sql dba

    Check your other post.

    All responses Here please

    p.s. please don't cross post, double post, or any other kind of multi-post.

  • RE: Adding/Removing Columns

    GilaMonster (8/2/2011)


    calvo (8/2/2011)


    ALTER TABLE test.Tmp_test SET (LOCK_ESCALATION = TABLE)

    Why? Table is the default for lock escalation.

    That's what the GUI generated as a script, and I pointed the locks out to...

  • RE: ReIndexing Questions

    That there is a beastly script. It does a whole lot more than just reorg/rebuild when needed. That script will create functions, tables, procedures and do your laundry all at...

  • RE: Adding/Removing Columns

    Oh yeah, and keep an eye out for those table locks where they popup. If you're modifying a table with millions (and millions!) of records, you might be impacting end...

  • RE: Adding/Removing Columns

    Roger Sabin (8/2/2011)


    I know that new columns can be added to the end and made NULLable which is very quick. Will adding a NULLable column between existing columns be just...

  • RE: Talking baseball

    Ed.Watson (7/27/2011)


    We could then store all the sensor data on clustered SQL Servers where we could be hired to administer said sensors and watch baseball for free....#newdreamjobdefined

    You write up the...

  • RE: Talking baseball

    Ed.Watson (7/27/2011)


    I agree, with technology there is no excuse for bad calls unless you're a purist who thinks they are part of the tradition LOL

    Well, they are part of the...

  • RE: Talking baseball

    people already complain about the pace of the game being too slow, now you want to add instant replay?

    NFL style? "Each team gets 3 challenges (not spending a challenge if...

  • RE: Talking baseball

    Oh man, 19 innings and the braves win on a blown (?) call.

    http://mlb.mlb.com/news/article.jsp?ymd=20110727&content_id=22363652&vkey=news_mlb&c_id=mlb

    It's REAL close, what do you guys think?

  • RE: Talking baseball

    Ray K (7/26/2011)


    Pity the poor Seattle Mariners.

    Although I'm happy that my Yankees won last night, I feel bad for Seattle. No team should have to endure what they're going...

  • RE: SELECT INTO

    They're not "bad". They might come with some undesired side effects when used improperly. The major one is the data types for the fields are determined by the data being...

  • RE: Home Setup

    Installing SQL Server at home is a start. A standalone will work just fine for a while but when you're ready, you could drop a few bills on a virtual...

  • RE: Enterprise to Express??

    Yes.

    keep in mind what functionality your database currently uses (enterprise features) for you might lose some by moving to express.

    backup/restore is probably the easiest way to do it.

Viewing 15 posts - 436 through 450 (of 686 total)