Forum Replies Created

Viewing 15 posts - 2,251 through 2,265 (of 9,715 total)

  • RE: Thank you to the Forum

    On behalf of all the regulars who already saw this but haven't yet responded, you are welcome. It's people like you that we do this for.

    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 ABCs of Database Creation

    cschnaars (10/29/2015)


    Overall, this is a great back-to-basics article. Thank you!

    Minor quibble: Your article says tinyint goes up to 251. It's 255.

    In my defense, I have fumble fingers. I'll get Steve...

    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 ABCs of Database Creation

    samot-dwarf (10/29/2015)


    Bad:

    - no normalization - make extra tables for publisher and title / serie

    - I'd never try to drop a database statement before I creating on - if I want...

    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 ABCs of Database Creation

    andrew_dale (10/29/2015)


    you say

    NOTE: There is a lot of available literature about pages, extents, and the affects they have on database design. Because of this, I won't go into the issue....

    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: Are the posted questions getting worse?

    Lovely.

    We have the URLDefense ProofPoint software to prevent bad URL links. But when the site goes down, so does our ability to navigate to the sites in the emails. Every...

    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: Login Timeout Expired & Log Backups

    Sorry I was unable to help more. I hope the link gives you the info you need.

    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: Synchronize databases over a slow network

    Koen Verbeeck (10/27/2015)


    So the source database of the ERP system is on server A. I can't touch that one, not even read from it (yeah don't get me started). But...

    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: Login Timeout Expired & Log Backups

    anthony.green (10/27/2015)


    The 18456 error is happening on the mirror node.

    The connection strings / connection managers are all set to point to the principal node.

    Okay. Just talking this through to myself...

    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: Synchronize databases over a slow network

    So Server A has database ABC. Server B has database DEF. You need some of the data from DEF to be in ABC? Or is it just copied over 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: Login Timeout Expired & Log Backups

    anthony.green (10/27/2015)


    Yep the login is defaulted to master, I am guessing that the initial catalog in the connection string/connection manager is forcing it to ignore the default db and go...

    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: Login Timeout Expired & Log Backups

    It just occurred to me...

    Have you checked the default database on the logins affected by this error?

    I usually set the default DB to master because I've found that if 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: Are the posted questions getting worse?

    Ed Wagner (10/20/2015)


    Alvin Ramard (10/19/2015)


    From: http://www.sqlservercentral.com/Forums/Topic1720717-1292-4.aspx#bm1729123

    ITU_dk2012 (10/19/2015)


    ... I think I should post this into another SSC forum because I am not getting any help over here.

    Thanks.

    Oh I'm sure...

    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 find the first, last and the Highest (Peak Value) in a list

    ITU_dk2012 (10/20/2015)


    @Lynn,

    Your solution works fine on small amount of data but it doesn't work on large quantities of data. I tried it on joining more than 5 tables on more...

    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 find the first, last and the Highest (Peak Value) in a list

    One thing I am noticing with these last bits of sample data posting is it is not the same sample data as you initially posted. You said there was going...

    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 find the first, last and the Highest (Peak Value) in a list

    ITU_dk2012 (10/19/2015)


    Sorry my mistake that I have not posted a clear scenario. Actually I am looking for way to get the first, highest and last value in the list of...

    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 - 2,251 through 2,265 (of 9,715 total)