Forum Replies Created

Viewing 15 posts - 5,431 through 5,445 (of 6,022 total)

  • RE: Have an Extra Beer!

    umailedit (7/29/2011)

    I have become skeptical of "scientific" findings regarding food and medicine. There seems to be scientific studies backing every cockeyed conclusion both for and against.

    I saw an infomercial...

    July 29, 2011 at 9:28 am

    #1360876

  • RE: Geeky Distractions

    I'd say that SQLServerCentral is a geeky distraction. 😉

    July 29, 2011 at 8:27 am

    #1360841

  • RE: Geeky Distractions

    cy-dba (7/29/2011)

    I've been watching various movies via Netflix (streaming and DVD), especially documentaries.

    Is anyone else wondering when Iron Fist will come out on the big screen??

    There are a lot of...

    July 29, 2011 at 7:32 am

    #1360796

  • RE: Geeky Distractions

    I've been reading through the Sword Of Truth series for several months. Also, from these books the TV series Legend Of Seeker was adapted.

    http://en.wikipedia.org/wiki/The_Sword_of_Truth

    July 29, 2011 at 6:38 am

    #1360722

  • RE: Time for a ROWID?

    mar10br0 (7/28/2011)

    For deduping duplicates in a heap-table, I would just delete all offending rows, then re-insert one record. Since a heap cannot have any foreign-keys pointing to it, this will...

    July 29, 2011 at 6:24 am

    #1360714

  • RE: Slow running select Queries

    Ninja's_RGR'us (7/28/2011)

    TheSQLGuru (7/28/2011)

    3) BEWARE DTA!! It does numerous bad things with indexing.

    I've actually had DTA CRUSH the server's CPU (large load) and then fill up the drive by growing...

    July 28, 2011 at 3:12 pm

    #1360471

  • RE: If exporting data to excel exceeds 65536 rows.....

    The optional Power Pivot addin (reuquires Excel 2010) can analyze millions of rows. You don't need to import millions of rows into Excel to analyze the data using Excel. Rather...

    July 28, 2011 at 11:49 am

    #1360377

  • RE: Time for a ROWID?

    Nadrek (7/28/2011)

    Eric M Russell (7/27/2011)

    How would you leverage ROWID for detecting "overlapping date ranges"; doesn't that typically involve comparing two or more date columns?

    It's the trivial case of "exclude each...

    July 28, 2011 at 10:38 am

    #1360316

  • RE: Time for a ROWID?

    Nadrek (7/27/2011)

    Eric M Russell (7/27/2011)

    Nadrek (7/27/2011)

    Actually, I'd very much like it to be exposed; for certain cases (say, overlapping date range detection), having an efficient, guaranteed unique per row value...

    July 27, 2011 at 2:03 pm

    #1359647

  • RE: Time for a ROWID?

    Nadrek (7/27/2011)

    Eric M Russell (7/27/2011)

    When a table is edited in SSMS, say to add a column or alter it's datatype, the operation will often times be scripted out in the...

    July 27, 2011 at 1:23 pm

    #1359626

  • RE: Time for a ROWID?

    Steve Jones - SSC Editor (7/27/2011)

    Eric M Russell (7/27/2011)

    The row id would have to be something both static and transferrable to the replicated instance, so it couldn't be a matter...

    July 27, 2011 at 12:04 pm

    #1359576

  • RE: Time for a ROWID?

    Steve Jones - SSC Editor (7/27/2011)

    Eric M Russell (7/27/2011)

    The row id would have to be something both static and transferrable to the replicated instance, so it couldn't be a matter...

    July 27, 2011 at 11:01 am

    #1359510

  • RE: Time for a ROWID?

    Steve Jones - SSC Editor (7/27/2011)

    mtillman-921105 (7/27/2011)

    I like the way you think Steve, but you are much more informed than I am.

    Would a ROWID save us from those dastardly heaps?...

    July 27, 2011 at 10:55 am

    #1359504

  • RE: Time for a ROWID?

    Steve Jones - SSC Editor (7/27/2011)

    Eric M Russell (7/27/2011)

    I can see how the physical row id would be useful for debugging or performance tuning purposes, like perhaps identifying which table...

    July 27, 2011 at 10:27 am

    #1359468

  • RE: Time for a ROWID?

    GilaMonster (7/27/2011)

    krowley (7/27/2011)

    Forgive a relative newbie to SQL internals but why can't the page size be variable per database or even per table? This would give the best of all...

    July 27, 2011 at 9:01 am

    #1359349

Viewing 15 posts - 5,431 through 5,445 (of 6,022 total)