Forum Replies Created

Viewing 14 posts - 1 through 14 (of 14 total)

  • Reply To: Goodbye to PASS

    One of the main things that will be lost is almost the 5.000 videos that are uploaded on PASS website...

    There's any way to archive them for the future? There's to...

  • RE: process to check sysprocesses without server state

    Thanks Kenneth

    There's any other way to do this ? Don't want to use the thrustworthy

  • RE: Move extents between files

    Thanks GILA πŸ™‚

    About a query to check if a file is marked as empty or not you have any ?

  • RE: Move extents between files

    About the EMPTYFILE operation on same filegroup:

    i have file A1 with 100GB occupied

    file A2 with 20GB (autogrowth disabled)

    file A3 with 30GB (autogrowth disabled)

    if i make EMPTYFILE on A1 it will...

  • RE: Move extents between files

    GilaMonster (9/8/2012)


    No, you don't want to shrink in 1 MB chunks...

    Create 2 new files in the filegroup, then shrink the full one with EMPTYFILE and remove it. Result - data...

  • RE: Move extents between files

    about the move of extents ( data ) between the datafiles in same filegroup, theres any best practice or tutorial or tips i should follow ?

    since all extents are used...

  • RE: Move extents between files

    GilaMonster (9/8/2012)


    biohug (9/8/2012)


    i tried "DBCC SHRINKFILE (N'A1', 211689)" but took so long and gave a strange error:

    Msg 0, Level 11, State 0, Line 0

    A severe error occurred on the current...

  • RE: Move extents between files

    I have enough space on tlog and DB is in simple mode

    Log Size (MB) Log Space Used (%) Status

    9993,992 ...

  • RE: Move extents between files

    Brent πŸ™‚ thanks for all the help,

    i checked all that pdf tips and everything is ok with the instance and databases, theres no errors on SQL Error log πŸ™‚

    that error...

  • RE: Move extents between files

    Brent you mean, execute the DBCC SHRINKFILE command to remove 1MB to the datafile each time, since all extents are used ?

  • RE: Move extents between files

    DBCC CHECKDB gave no errors πŸ™‚

  • RE: sp_msforeachtable

    Robert THANKS πŸ™‚

  • RE: sp_msforeachtable

    Thanks for the answer Robert.

    About the 1ΒΊst advice, im not allowed to change it :/

    2ΒΊnd advice, yeah πŸ˜‰

    but tell me, using the current syntax, theres any expression or anything i...

  • RE: User DB permissions

    there's any program that can show me this info visually ( GUI ) ?

Viewing 14 posts - 1 through 14 (of 14 total)