Forum Replies Created

Viewing 15 posts - 2,431 through 2,445 (of 7,164 total)

  • RE: memory sql 2008

    Oracle_91 (1/10/2013)

    Hi All,

    Recently, i am going through the memory concepts of sql server 2008 and i need some clarifications from expericenced folks to get better clarity on below terms and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 11, 2013 at 5:19 am

    #1576206

  • RE: Heavy waits on PAGEIOLATCH_SH got cleared after restarting web application

    42443 occurrence(s) of I/O requests taking longer than 15 seconds to complete

    :w00t:

    praveen_vejandla (1/11/2013)

    One thing that I don't understand is error got logged only after restarting the web application and then...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 11, 2013 at 5:03 am

    #1576198

  • RE: Script to list columnnames

    You're quite welcome.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 11, 2013 at 4:53 am

    #1576196

  • RE: Importing column header data using bulk insert

    You're quite welcome.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 11, 2013 at 4:50 am

    #1576193

  • RE: Reorg indexes on a replicated DB(transactional)

    jfogel (1/10/2013)

    Thanks for the info. One thing I want to make clear is that there is no index rebuilding, just reorg. This is why the update stats is the next...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 10, 2013 at 5:22 pm

    #1576020

  • RE: Reorg indexes on a replicated DB(transactional)

    jfogel (1/10/2013)

    Greetings,

    I have a server that is replicating four databases using transactional replication and I have a task on the publisher that reorgs the indexes on the published database. I...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 10, 2013 at 2:48 pm

    #1575978

  • RE: blocking LCK_M_SCH_S, LCK_M_SCH_M

    rocks (1/10/2013)

    so how do i determine what is best for me. as mine is heavy data changing application in terms of insert , delete and update.

    Test on representative hardware with...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 10, 2013 at 1:14 pm

    #1575952

  • RE: DMV for capturing all SQL Statements instead of just the last

    Good to know. Thanks for posting back.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 10, 2013 at 10:26 am

    #1575890

  • RE: DMV for capturing all SQL Statements instead of just the last

    DanielP (1/10/2013)

    We had to set up Management Data Warehouse (MDW) to monitor. I was able to trace the SQL Code that was causing the blocking by drilling down the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 10, 2013 at 10:07 am

    #1575881

  • RE: what type of database to use ?

    The intent of the question is clearly to exercise the test-takers knowledge of what role the model database plays in the creation of new databases. The sad part is that...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 10, 2013 at 9:58 am

    #1575878

  • RE: DMV for capturing all SQL Statements instead of just the last

    Nice. Thanks for posting back. Do you know if that was part of the default collection set, or a custom one you setup?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 10, 2013 at 9:30 am

    #1575867

  • RE: Access Excel Hyperlinks from SQL

    Greg Snidow (1/10/2013)

    Philip-1144230 (1/10/2013)the other two would require me to manually go through roughly 12000 excel files with a average of 15 worksheets each to extract the hyperlinks

    Philip, it sounds...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 10, 2013 at 9:24 am

    #1575864

  • RE: normalization vs de-normalization ?

    No, please share. Nothing like a good witch hunt on a Thursday morning.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 10, 2013 at 9:11 am

    #1575860

  • RE: normalization vs de-normalization ?

    Agreed, not about shooting the test writer but about the nonsensical options. You literally have to rule out all the real choices based on how ambiguous they are. "Compare and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 10, 2013 at 8:35 am

    #1575842

  • RE: blocking LCK_M_SCH_S, LCK_M_SCH_M

    GilaMonster (1/10/2013)

    opc.three (1/10/2013)

    . Online index rebuilds do not block anything regardless of the isolation level.

    Kinda...

    Online index rebuilds are mostly online. They take a short-lived IX lock at the beginning (which...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 10, 2013 at 8:31 am

    #1575839

Viewing 15 posts - 2,431 through 2,445 (of 7,164 total)