Forum Replies Created

Viewing 15 posts - 9,541 through 9,555 (of 9,725 total)

  • RE: Transaction Log backup size

    Naqaraj, you should really open up a new thread about this error instead of piggy-backing on a thread with a different subject. 

    People who read this thread are expecting to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Transaction Log backup size

    You can't do a log backup and a full backup of the same database at the same time.  One will be held up until the other finishes and they may...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Cross Joins

    Here's an example.  TableTime has two columns, TimeID and a datetime column.  It is updated every month with the most recent month-end date (for accounting).  You want to pull all...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Move DB from 2005 to 2000??

    As others have said, and I have heard personally from the lips of Kimberly Tripp (works for Microsoft on the SQL Server team), you can NOT downgrade from SQL Server...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: How to skip the first row in an excel workbook

    Bad news.  There is no good way to do what you want to do save editing the excel workbook itself and deleting that first line.  Now if the first row were...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Transaction Log backup size

    Check your database options.  AutoShrink on?  AutoClose on?  Auto Create Stats on?  What about your Transaction log checkpoint stuff?

    Chances are the reason the first 3 logs were so huge was...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Auto backup Increasing Size Constantly

    What tool are you using to do an Autobackup?  A job scripted out in T-SQL or the DB Maintenance Plan backup stuff?  Or a third party tool like Litespeed?

    This makes...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Access is denied when authentication is set to "enable anonymous access"

    If you can't add a non-admin user to the app server and the web server, you may be stuck.  That's the best solution I can think of, is using a...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Order Database Design

    I'm glad I could help you out, Cathy.  And Chris actually has some good ideas (the best come from personal experience) that you might want to consider also.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: The Work Perks You wish to have

    Hear, hear, James!  Having to explain why you want a wrist pad for your keyboard or monitor risers so you don't strain your neck ("Why didn't you need this before?" they...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Dilema

    I am also a beginner at this, so someone correct me if I'm wrong, but here's what I've gotten from the articles I've read.

    Once you've determined where all your source...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Order Database Design

    Cathy,

    There are a couple of things you should note about Paul's comment.  First, he suggests using a combo primary key for your OrderDetails table which you said you wanted to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: DBA''''s more scarce in 2007

    Steve,

    I completely agree with the giving out people's names thing.  It's just funny that I don't have any to give out even if I wanted to. @=)

    As far as the...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: DBA''''s more scarce in 2007

    I keep getting calls from recruiters wanting to know "how are things going", putting feelers out for whether or not I want to jump ship.  Then when I return their...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Log Writer Suspended?

    Sugesh,

    Thanks, but I already knew about the System Process IDs. 

    My concern was why system processes were suspended.  And my philosophy is "Better to know now when it's NOT a...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 9,541 through 9,555 (of 9,725 total)