Forum Replies Created

Viewing 15 posts - 4,366 through 4,380 (of 6,041 total)

  • RE: Fun Data Analysis

    From what I've seen, restraunts with multiple TV sets (ie: sports bars) tend to have a higher calorie fried menu, and even folks who normally eat healthy will occasionally go...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Fun Data Analysis

    BWFC (10/10/2014)


    ...

    But it's in the Daily Mail, it must be true. Are you suggesting that what they publish may not be entirely accurate. My whole belief system and...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Fun Data Analysis

    Speaking of research studies with questionable cause and effect, I see this type of thing all the time on the morning news shows. Below is a good example.

    How where you...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Continuous Delivery for Windows?

    If you want no-fuss upgrades to the latest service pack and bug fixes, then perhaps SQL Azure is the way to go.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: tempdb log 75GB

    -- query allocated temp tables with record count and size.

    use tempdb;

    select o.type_desc

    , substring(o.name,1,charindex('__',o.name)+1)+right(o.name,12) table_shortname

    , si.name index_name

    , case si.index_id when 0 then 'HEAP' when 1 then 'CLUSTERED' else 'NONCLUSTERED' end index_type

    ,...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Continuous Delivery for Windows?

    We've already seen SQL Server move to a pace that releases new versions every two years and bimonthly patches to fix issues. Imagine that we could get patches even more...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Help avoiding temp table with string of IDs passed into stored procedure

    TheSQLGuru (10/7/2014)


    Try your XML method under stress and see how it holds up. Or with lots of rows.

    There are some very nice threads here on SSC.com about...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Why do they not listen?

    😉

    Evil Kraig F (10/7/2014)


    djj (10/7/2014)


    Finally someone listened. We had a meeting today and we are looking to revamp the entire phone number storage.

    Not because I suggested it, but a...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Help avoiding temp table with string of IDs passed into stored procedure

    The following approach assumes the same list of IDs as a comma seperated set. It does not involve a temp table or dynamic sql, and should keep a fixed execution...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Next Five Years

    I've got the genious DNA... right here! :kiss:

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Next Five Years

    Luis Cazares (10/7/2014)


    Eric M Russell (10/7/2014)


    Yes, a genious should be able to create their own job, but a high IQ doesn't guarantee that the person is also a self-starter; it...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Linked server & Remote login Password

    ramana3327 (10/7/2014)


    Hi,

    Is there any way to find out the password for the remote login of the Linked server

    The system table sys.sql_logins contains a column called [password_hash] and sys.sysoledbusers contains a...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Next Five Years

    Gary Varga (10/7/2014)


    Eric M Russell (10/7/2014)


    Luis Cazares (10/6/2014)


    Miles Neale (10/6/2014)


    There will be no need for school. We will alter the DNA prebirth so that no one is born without the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Next Five Years

    Luis Cazares (10/6/2014)


    Miles Neale (10/6/2014)


    There will be no need for school. We will alter the DNA prebirth so that no one is born without the initial abilities of Albert E....

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Same Query, Different Server, Different Plan

    Do they have the exact same SQL Server version and service pack level?

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 4,366 through 4,380 (of 6,041 total)