Forum Replies Created

Viewing 6 posts - 31 through 37 (of 37 total)

  • RE: altering huge table - your suggestions

    Thanks for the help John!

    Some more help on your terminology please

    "Depending on the number of audits you are inserting in your table, you could...



    What's this "backup strategy" everyone is on about?

  • RE: Cluster index on datetime column

    Continueing on ths subject.....

    I have just inherited 2 audit tables (tbl1 +- 3 milj rows, tbl2 +- 70 mil rows) with no indexes apart from a single clustered PK on...



    What's this "backup strategy" everyone is on about?

  • RE: UID''''s in Sysusers

    Thanks guys!



    What's this "backup strategy" everyone is on about?

  • RE: UID''''s in Sysusers

    Thanks David!

    Does this mean, If I create a standard SQL user with ID 5 in the model DB, all new databases will also have this user?



    What's this "backup strategy" everyone is on about?

  • RE: Exception_access_violation wgen refreshing jobs...

    Hi Rudy,

    The only changes I made was to the endtime of the jobschedule...

    BUT...I did some more troubleshooting, and after making the required change to my script and recreating the plan...



    What's this "backup strategy" everyone is on about?

  • RE: Exception_access_violation wgen refreshing jobs...

    Hi all,

    I recieved the same error after creating scripts for rolling out various maintenance plans (with additional steps included) to about 20 production servers.

    About a week after the successfull rollout...



    What's this "backup strategy" everyone is on about?

Viewing 6 posts - 31 through 37 (of 37 total)