Forum Replies Created

Viewing 15 posts - 2,476 through 2,490 (of 6,041 total)

  • RE: Assistance with new nework design

    Short answer: Yes

    Longer answer:

    https://technet.microsoft.com/en-us/library/ms345392(v=sql.105).aspx

    Scalable Shared Databases Overview

    The scalable shared database feature allows you to scale out a read-only database built exclusively for reporting purposes (a reporting...

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

  • RE: Unable to delete from the table, takes forever

    null

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

  • RE: Unable to delete from the table, takes forever

    Chitown (7/14/2016)


    When I run the select * from the table, it returns 100K records in 6 minutes. I deleted top 10 records and it took almost 50 seconds (5 seconds...

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

  • RE: Byte Me: Behind Times

    Guess how many 360 K floppies it would take to backup a 1 TB database. Also try to guess how much time it would take if you had one guy...

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

  • RE: Byte Me: Behind Times

    SQLRNNR (7/13/2016)


    How many floppies are required for the SQL Server 2016 install?

    Fortunately nowhere near the number required to backup the database.

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

  • RE: Losing Rows

    What was originally coined "NoSQL" should really have been NoACID, since they have since discovered that in order for their database platform to be marketable outside the realms of academia...

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

  • RE: Not a DBA admin - How do i optimize/tune my queries, check on missing index?

    Jeff Moden (7/12/2016)


    HappyGeek (7/11/2016)


    quentin.harris (7/8/2016)


    True. It is a difficult place to be as a developer not sitting within the DBA/BI team but interfacing with their DW.

    It seems to be...

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

  • RE: A problem of concurrency on a small table

    It could be that the sessions performing updates on this table as part of a larger batch transaction. Often times programming will begin a transaction, update, and then do some...

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

  • RE: A problem of concurrency on a small table

    What you're dealing with is probably blocking of some time. To get to the bottom of this issue, during these occasions where query latency is extremely long, you need to...

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

  • RE: Going On-Prem?

    djackson 22568 (7/11/2016)


    Japie Botma (7/11/2016)


    djackson 22568 (7/11/2016)


    Eric M Russell (7/11/2016)


    I know how you feel. Here in America, we're coping with our own recent political embarrassments.

    What could possibly be embarrassing about...

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

  • RE: Not a DBA admin - How do i optimize/tune my queries, check on missing index?

    quentin.harris (7/8/2016)


    Awesome. Though i will be seeing flying pigs before i think i will be allowed to do this as it seems it can show sensitive information such as passwords....

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

  • RE: Going On-Prem?

    David.Poole (7/11/2016)


    Japie Botma (7/11/2016)


    What about POPI laws? (Protection of Personal Information Act). If your data is in the cloud and the whereabouts of the actual server can change with...

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

  • RE: New Mobile Attack Vectors

    I have a hanful of suggestion for making smart phones more secure.

    First, I understand why Apple and Samsung manufactore their phones in cheap overseas sweatshops; it's all about economics. However,...

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

  • RE: New Mobile Attack Vectors

    It's funny how, just within the past few years, 2 billion regular folks around the globe are burdened with the responsibility of being an accidental system administrator for a tiny...

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

  • RE: Clustered index on non-primary key columns

    SQL!$@w$0ME (7/7/2016)


    Hello Folks,

    Is it a good practice to create clustered index on non-primary key columns since the primary key column is not queried at all. Please share your thoughts or...

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

Viewing 15 posts - 2,476 through 2,490 (of 6,041 total)