Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 6,041 total)

  • RE: Securing Your Instances

    GeorgeCopeland - Saturday, January 14, 2017 3:21 PM

    Eric M Russell - Saturday, January 14, 2017 8:18 AM

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

  • RE: Is Azure a good decision for a major production application deployment?

    WebTechie - Wednesday, January 18, 2017 9:23 AM

    Eric M Russell - Wednesday, January 18, 2017 9:16 AM

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

  • RE: what happens internally when you execute same query in multiple times

    Grant Fritchey - Wednesday, January 18, 2017 7:56 AM

    Eric M Russell - Wednesday, January 18, 2017 7:11 AM

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

  • RE: Is Azure a good decision for a major production application deployment?

    Yes, SQL Azure's contained database model will take some getting used to, but the issue isn't just about security, there are technical reasons why this is done. In a cloud...

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

  • RE: Writing the Correct Query is Important

    billm 56127 - Wednesday, January 18, 2017 8:19 AM

    Eric M Russell - Wednesday, January 18, 2017 7:46 AM

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

  • RE: Writing the Correct Query is Important

    I once inadvertently coded an update script that looked something like this:

    SET @User = 1234;

    UPDATE VeryBigTable
    SET Status = 0
    WHERE User = User;

    From...

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

  • RE: what happens internally when you execute same query in multiple times

    Assuming each query has the same parameters and the data was static between executions, I would expect the number of page reads and the execution plan to be the same....

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

  • RE: Database Diagram of Information_Schema.

    Hi Ben,
    Using the following Google search expression, I was able to find the diagram you're looking for or at least something similar. It looks like there may be several...

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

  • RE: Prevent Mass Updates With RowCount 1

    Joe Torre - Tuesday, January 17, 2017 9:55 AM

    mary.clemons 79057 - Saturday, January 14, 2017 6:18 AM

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

  • RE: TDE and Stretch Databases

    OK, I now see this was entered under 'Articles Requested'. I thought it was a general question. Offhand, I don't know of any limitations that TDE would place on other...

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

  • RE: Data Archive

    Generally speaking, there is no good reason to repeatedly shrink a database on a schedule. What this does is reduce the physical size of the data file on disk. The...

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

  • RE: Datawarehouse for 2 different CRM systems

    zouhair.ouichdani - Tuesday, January 17, 2017 7:33 AM

    Hi guys,

    I am currently working on design phase of an integration of a new CRM system...

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

  • RE: Writing the Correct Query is Important

    In the case of a distributed database environment, like retail point of sale, I'd use a composite key like StoreID + TransactionID before I would resort to using GUIDs. So...

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

  • RE: How can i recover corrupted database file( .mdf .ldf).

    This is an old thread, but 
    1.  So the files do not become further corrupt, make a backup copy of the .mdf data and .ldf log files. This files should...

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

  • RE: TDE and Stretch Databases

    I'm not seeing a link the original article, so I'm not sure about the question. However, regarding the question of using TDE with database Stretching, I don't see why it...

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

Viewing 15 posts - 1,816 through 1,830 (of 6,041 total)