Forum Replies Created

Viewing 15 posts - 5,506 through 5,520 (of 9,726 total)

  • RE: How to properly design this DB

    Good to hear. Glad we could help.

    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.

    July 26, 2011 at 7:36 am

    #1358499

  • RE: Retrieving records for accounts opened between the first day and the last day of previous month

    Glad I could help.

    Remember, keep "pretty" on the user side. Don't worry about it for the backend stuff.

    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.

    July 26, 2011 at 7:34 am

    #1358498

  • RE: remove last character from string

    justintime (7/25/2011)

    yep gotcha on the string length parts. does the value that i set for the variable matter?

    We're just using the variable as an example. you don't...

    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.

    July 26, 2011 at 7:33 am

    #1358494

  • RE: remove last character from string

    Where the 5 and 4 are in my code, these are the string lengths. If you want a variable strength length, then you just replace the numbers with LEN(Myfield)-1 and...

    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.

    July 25, 2011 at 12:36 pm

    #1358064

  • RE: Are the posted questions getting worse?

    john.arnott (7/25/2011)

    Gus,

    Thanks for the encouragement. I've submitted my meta-QOD.

    And I can't wait to complain about the correct answer to it! @=)

    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.

    July 25, 2011 at 12:34 pm

    #1358063

  • RE: What's a safe backup?

    Ninja's_RGR'us (7/25/2011)

    Please not he said COPY and not MOVE. If something bad happens during the move you lose the DB, copy is safer there.

    Ninja, I'm sorry, but this reply...

    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.

    July 25, 2011 at 12:28 pm

    #1358057

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (7/25/2011)

    Brandie Tarvin (7/25/2011)

    Actually, it's not that post, Ninja. There was another one that I responded to in the first few posts and the guy didn't want to listen 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.

    July 25, 2011 at 12:23 pm

    #1358052

  • RE: Are the posted questions getting worse?

    GilaMonster (7/25/2011)

    SQLRNNR (7/25/2011)

    GilaMonster (7/25/2011)

    mtillman-921105 (7/25/2011)

    Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand...

    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.

    July 25, 2011 at 12:12 pm

    #1358046

  • RE: Retrieving records for accounts opened between the first day and the last day of previous month

    rbond 51820 (7/25/2011)

    We are converting the date to string because the end users tend to "freak" when they see the system datetime with hh:mm:ss rather than just the date only...

    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.

    July 25, 2011 at 12:04 pm

    #1358037

  • RE: Are the posted questions getting worse?

    Actually, it's not that post, Ninja. There was another one that I responded to in the first few posts and the guy didn't want to listen to me, Gus, and...

    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.

    July 25, 2011 at 12:02 pm

    #1358034

  • RE: sp_send_dbmail with dynamic body

    Dynamic SQL is when you populate a variable with a SQL query or another stored procedure. Read up on sp_executesql when you get a chance, so you understand what can...

    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.

    July 25, 2011 at 11:53 am

    #1358024

  • RE: How to properly design this DB

    Welsh Corgi (7/25/2011)

    Yes, also grab some pencils. 🙂

    😛

    @=)

    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.

    July 25, 2011 at 11:39 am

    #1358006

  • RE: What's a safe backup?

    I have to agree with Gus & Ninja. Yes, you can do it, but there are so many things that can go wrong with that method (like accidentally deleting 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.

    July 25, 2011 at 11:20 am

    #1358003

  • RE: Retrieving records for accounts opened between the first day and the last day of previous month

    Why are you converting your dates to strings?

    I have always had problems with BETWEEN dropping records on me, so I never use it. I always go this route:

    SH_ACCT.open_dt >= dateadd(mm,datediff(mm,0,dateadd(mm,-2,getdate())),0)...

    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.

    July 25, 2011 at 11:14 am

    #1357996

  • RE: RAID 10, Crystal Disk Mark Weird score?

    Yes, because SANS are set up in different ways and also have different hardware. Some SANS have 1 disk controller, others have multiples. Also, it depends on how the LUNS...

    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.

    July 25, 2011 at 11:10 am

    #1357992

Viewing 15 posts - 5,506 through 5,520 (of 9,726 total)