Forum Replies Created

Viewing 15 posts - 16 through 30 (of 66 total)

  • RE: Lock Issue Advice

    Forgot to include this: Messages in the Error Log

    Time out occurred while waiting for buffer latch -- type 4, bp 000000009FFC4D00, page 4:244606, stat 0x4c00009, database id: 2, allocation unit...

  • RE: IIF or SWITCH Condition to use and how

    sanju2t (9/27/2012)


    Hi,

    I have a report where countrycode is a paramater and i need to show the date format as dd/MM/yyyy on basis of countrycode. Can someone help me know...

  • RE: Replication

    you are quite welcome

  • RE: Replication

    take a read on what you plan to do:

  • RE: Replication

    erics44 (9/5/2012)


    crashdan (9/5/2012)


    erics44 (9/5/2012)


    what do you think about my moving data to a reporting database issue?

    It sounds like you are looking for 2 different things. one to move data to...

  • RE: Replication

    erics44 (9/5/2012)


    what do you think about my moving data to a reporting database issue?

    It sounds like you are looking for 2 different things. one to move data to another database...

  • RE: Replication

    MysteryJimbo (9/5/2012)


    crashdan (9/5/2012)


    SqlServer will prevent you from updating replicated data.

    Sorry. That is incorrect. It will not.

    I stand corrected. I looked into my permissions and only allow selects. Thank...

  • RE: Replication

    erics44 (9/5/2012)


    ok perhaps replication isnt what i need

    it seems like more of a dev / back up / disaster recovery method

    I am looking into ways of moving data into...

  • RE: Replication

    erics44 (9/5/2012)


    ahh i see

    so you mean its good to prevent someone being able to go into the reporting server and changing data where as the data should be changed in...

  • RE: Restarting One Database Not Entire Server

    how long has it been in rollback?

  • RE: Transparent Data Encryption

    Good Question. Learned something new.

  • RE: Can we set up separate network card for Backups and Log shipping?

    What I would try (not that its exactly correct) is writing the backup locally (I know its huge) and use Backup Compression. Then have a separate step move the file...

  • RE: Better option than using Stored procedures

    GSquared (2/27/2012)


    MyDoggieJessie (2/27/2012)


    But fact that the execution plans for the procs are often cached and more likely to be reused isn't though. This isn't an option when running ad...

  • RE: Table Value Constructor 1

    OzYbOi d(-_-)b (2/27/2012)


    great question. had to read more into this as I hadn't used VALUES in this way before.

    same here, excellent question

  • RE: Model Database

    lbrigham (2/22/2012)


    So the correct answer isn't "No and No" nor is it "Yes and No" but rather "Yes and It Depends" - I think everyone who got a point should...

Viewing 15 posts - 16 through 30 (of 66 total)