Forum Replies Created

Viewing 15 posts - 1,696 through 1,710 (of 6,041 total)

  • RE: Is having a lookup table that is for multiple entities a common practice?

    When I think of a "lookup table", it's usually not something that models a complete entity, but rather just ID and Description.

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

  • RE: Good or slow? 1 min to load 600M text format into SQL

    Jeff Moden - Friday, February 17, 2017 11:27 AM

    IIRC, BULK INSERT doesn't require you to disable the clustered index to get minimal...

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

  • RE: Good or slow? 1 min to load 600M text format into SQL

    halifaxdal - Friday, February 17, 2017 9:49 AM

    Eric M Russell - Friday, February 17, 2017 8:07 AM

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

  • RE: Good or slow? 1 min to load 600M text format into SQL

    halifaxdal - Thursday, February 16, 2017 2:15 PM

    Hello,

    Just be curious on the SSIS performance, it took me 1 minute to load 600M...

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

  • RE: Is that database is used by users or no?

    The following data management view will give aggregated read / write stats at the...

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

  • RE: Store Procedure

    Nita Reddy - Thursday, February 16, 2017 9:27 AM

    ZZartin - Thursday, February 16, 2017 9:04 AM

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

  • RE: Store Procedure

    Here is literally what you've asked for.

    CREATE PROCEDURE GenerateOneRandomNumber
    AS
    SELECT RAND() RandomNumber;
    GO

    EXEC GenerateOneRandomNumber;
    GO 100

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

  • RE: Training Computer Scientists

    The culinary industry has a similar debate over the merits of a diploma. Do you need to graduate from culinary school to be a good chef? Maybe not, but if...

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

  • RE: Is having a lookup table that is for multiple entities a common practice?

    It's kind of like asking if re-using cooking oil is a common practice.

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

  • RE: What Would Do if Your Company Was Targeted?

    Things like firewall settings and locked down permissions can drift over time, even if they shouldn't. So, a threat warning is a wakeup call and a good reason to call...

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

  • RE: What Would Do if Your Company Was Targeted?

    ... This is different than responding to an attack. When you can see the attack you can take immediate steps to fight the problem - blocking an IP range...

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

  • RE: Use variable in the Identity Seed of create table

    John Mitchell-245523 - Wednesday, February 15, 2017 2:04 AM

    Eric M Russell - Tuesday, February 14, 2017 12:21...

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

  • RE: SQL Server vs SQL Server v.Next

    ... Note: The hardware is very similar, though some might argue the performance of the Toshiba is below that of the Samsung. What the SSD on the Windows...

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

  • RE: The Power of the Data Model

    Matt Miller (#4) - Tuesday, February 14, 2017 12:22 PM

    AZJim - Tuesday, February 14, 2017 7:26 AM

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

  • RE: Use variable in the Identity Seed of create table

    Welsh Corgi - Tuesday, February 14, 2017 11:29 AM

    John Mitchell-245523 - Tuesday, February 14, 2017 9:31 AM

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

Viewing 15 posts - 1,696 through 1,710 (of 6,041 total)