Forum Replies Created

Viewing 15 posts - 31 through 45 (of 643 total)

  • RE: Understanding In memory OLTP

    Thanks Gail for taking time to explain it. Helpfull indeed. Everything is clear now 🙂

    Sujeet Singh

    October 10, 2014 at 5:22 am

    #1751559

  • RE: Understanding In memory OLTP

    GilaMonster (10/10/2014)

    Divine Flame (10/9/2014)

    My assumption regarding the in-memory tables is that we create the tables & we configure which tables we want to make as in-memory tables. These tables use...

    Sujeet Singh

    October 10, 2014 at 2:59 am

    #1751520

  • RE: Supported spatial data formats

    Vimal Lohani (9/23/2014)

    uff, what a question, so concentration required.

    my (70-461) preparation, helped me to solve this.

    Really, you needed that much concentration & the help of 70-461 preparation?

    When the question...

    Sujeet Singh

    September 24, 2014 at 4:47 am

    #1747770

  • RE: Supported spatial data formats

    Nice question. I am amused 12% chose option 6 as the correct answer:hehe:.

    Sujeet Singh

    September 24, 2014 at 4:43 am

    #1747769

  • RE: How many rows will be returned?

    Mighty (9/23/2014)

    Carlo Romagnano (9/23/2014)

    Triggers on tables execute only if at least ONE row is affected. So, explanation is wrong.

    Hi Carlo,

    you are wrong in your assumption. And I guess the idea...

    Sujeet Singh

    September 23, 2014 at 5:36 am

    #1747372

  • RE: Which book should one read first?

    Grant Fritchey (9/17/2014)

    The second one is a little more specialized than the first. They both cover some of the same material, but if I had to pick, I'd go with...

    Sujeet Singh

    September 17, 2014 at 8:18 am

    #1746080

  • RE: Which book should one read first?

    Talib123 (9/17/2014)

    1 It will make more sense to start with.

    Thanks for your response Talib. Thats what I thought too.

    Have you read these books?

    Sujeet Singh

    September 17, 2014 at 7:24 am

    #1746051

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/11/2014)

    TomThomson (8/11/2014)

    I would go for something like not allowing more than two new threads in two minutes, not more than 3 in 4 minutes, not more than 4...

    Sujeet Singh

    August 11, 2014 at 7:34 am

    #1736858

  • RE: Database is in Recovery Pending Status

    GilaMonster (7/25/2014)

    Since he didn't post anything useful (error messages, status), no idea. Maybe he freed up space on the wrong drive, maybe there was a secondary problem....

    Point is, a suspect...

    Sujeet Singh

    July 25, 2014 at 4:04 am

    #1732303

  • RE: Database is in Recovery Pending Status

    GilaMonster (7/24/2014)

    Divine Flame (7/24/2014)

    You should see somthing like "Recovering the database ...." & along the line it will also tell you the % of recovery completed. Wait for it to...

    Sujeet Singh

    July 25, 2014 at 3:32 am

    #1732295

  • RE: Database is in Recovery Pending Status

    Draconian (7/24/2014)

    Hi,

    My Production database is in Recovery pending status. I checked and found due to Hard disk space it went into suspect mode.

    My DBSize is around 70GB. I made around...

    Sujeet Singh

    July 24, 2014 at 8:22 am

    #1732105

  • RE: Is it possible to alter the table definitions of the secondary database, like adding constraints or fields to tables in the secondary database?

    sujainarayanan (7/14/2014)

    So the only wise option from would be to avoid implementing CDC on the source for the above two reasons. Instead we are looking at somehow replicating the source...

    Sujeet Singh

    July 14, 2014 at 10:15 am

    #1729191

  • RE: Instant File Initialization

    Thomas Keller (7/11/2014)

    4 stars! You should mention how to confirm that it took effect, by looking at the errorlog after creating a database, to see if it no longer says...

    Sujeet Singh

    July 11, 2014 at 3:12 am

    #1728642

  • RE: Database Mirroring

    bala2 (7/10/2014)

    Hi,

    Can anyone tell me how the Application users will recognize or connect to the Mirroring database once the failover had happened from primary server.

    Do we need to change...

    Sujeet Singh

    July 10, 2014 at 9:49 am

    #1728439

  • RE: Instant File Initialization

    Alan.B (7/10/2014)

    Great article, 5 stars. I new nothing about this. Learned something new today already!

    Thanks for your kind words Alan. Glad you find it useful.

    Sujeet Singh

    July 10, 2014 at 8:33 am

    #1728412

Viewing 15 posts - 31 through 45 (of 643 total)