Forum Replies Created

Viewing 15 posts - 91 through 105 (of 588 total)

  • RE: Need List of DTS packages in MSSQL2005

    Been a while since I did this on a new 2005 server, but I believe you need to download a legacy thing from MS website to see DTS packages inside...

  • RE: Take the Plunge

    Security and all technical details can be overcome. What I think can not be overcome is relationships. What happens if you and the vendor holding your data has...

  • RE: Can the logbackup file size be more than the full backup file size?

    Not unusual at all, especially if you are backing up a database that is part of a lot of overnight batch operations. Fairly normal for me that the first...

  • RE: Monitoring Changes in Your Database Using DDL Triggers

    The enrcypted items are Create Statistics done by the server, and create function and stored procedure that are done by the system....

    I include the EventType from the XML, which makes...

  • RE: CSI -are they for real?

    I think, as with most shows, if you are a professional in the field, you can find shows frustrating. Don't get me going on shows/movies that have anything to...

  • RE: deleting 22 million records

    True. It can, it can also happen a lot sooner than that. Point is to break it up into chunks that would not impact business. Which is...

  • RE: deleting 22 million records

    Could break it up into smaller chunks using top(x) with a loop around it until no more records are deleted. I've used this with some success archiving data, had...

  • RE: PCI Audit Secure Delete Requirements

    That makes no sense. If you do backups of the database that data would be all over anyhow....

    If you need to remove it from disk only to the point...

  • RE: Excess space in a database data file

    If I remember right the space usage grows by 1.1 times the size of the index when reindexing. I never shrank files that grew from reidenxing as they will...

  • RE: CTE Usage

    use tempdb

    go

    create table #ids (id int not null );

    with MyCTE(id) as

    (

    select id from sysobjects

    )

    insert into #ids(id)

    select id from MyCTE

  • RE: Snooping

    Michael Valentine Jones (8/14/2008)


    In the big scheme of things, the potential for abuse by a DBA is probably less than many other jobs, because the ability to turn the abuse...

  • RE: The Active DBA

    GilaMonster (8/8/2008)


    Someguy (8/8/2008)


    skjoldtc (8/8/2008)


    Woodchopping with a nice sharp axe.

    Axes, martial arts practitioners-

    You forgot the archers.

    And competiton shooters! =)

    I try to go to the gym 3-4 days a week. BUt...

  • RE: The Daily Commute

    You have a SuperHawk and an RC51? As a previous SH owner I am jealous 🙂 It is incredible how much better of a mood I am in...

  • RE: Generate Insert script

    I'm lazy, I use ApexSQL Edit.... =)

  • RE: Ho i see XML data OUT PUT in SQL server 2005

    Assuming you just mean you want to see the data in a logical manner......

    If you select the column with the XML data (assuming it is in an XML data type...

Viewing 15 posts - 91 through 105 (of 588 total)