Forum Replies Created

Viewing 15 posts - 3,871 through 3,885 (of 9,715 total)

  • RE: To sharpen the Query Logic

    sqlnaive, have you tried google yet? There are definitely challenges out there, if that's all you're interested in. And they should come up easily in a search engine.

    The key phrase...

    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.

    October 23, 2012 at 4:30 am

    #1551816

  • RE: Should I become a DBA?!?

    +100 to Jeff's post.

    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.

    October 23, 2012 at 4:28 am

    #1551815

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/22/2012)

    Brandie Tarvin (10/22/2012)

    Stefan Krzywicki (10/22/2012)

    ...Apple is easy. I tried to make one I could eat this past weekend. I have diabetes, so I had to change it 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.

    October 22, 2012 at 11:25 am

    #1551552

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/22/2012)

    ...Apple is easy. I tried to make one I could eat this past weekend. I have diabetes, so I had to change it a little. I made 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.

    October 22, 2012 at 10:18 am

    #1551511

  • RE: Qusestion on delete job

    If you could combine the jobs into one, TRUNCATE actually uses less restrictive locks than DELETE does. It also only logs pages instead of individual rows, which enables it 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.

    October 22, 2012 at 8:15 am

    #1551384

  • RE: Are the posted questions getting worse?

    ChrisM@home (10/22/2012)

    L' Eomot Inversé (10/22/2012)

    Stefan Krzywicki (10/22/2012)

    Brandie Tarvin (10/22/2012)

    [font="Comic Sans MS"]The PI! It needs more slices![/font]

    You know what I hate about pie charts?

    You can never tell what filling they're...

    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.

    October 22, 2012 at 6:35 am

    #1551343

  • RE: Are the posted questions getting worse?

    [font="Comic Sans MS"]The PI! It needs more slices![/font]

    You know what I hate about pie charts?

    You can never tell what filling they're using. And it's awfully hard to stick 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.

    October 22, 2012 at 4:35 am

    #1551294

  • RE: Qusestion on delete job

    baabhu (10/20/2012)

    Brandie Tarvin (10/19/2012)

    I have an odd question. Why do you need to delete 10000 records from your database every 4 minutes?

    This is an OLTP system with tokens needs 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.

    October 22, 2012 at 4:31 am

    #1551290

  • RE: To sharpen the Query Logic

    SQL challenges don't help you improve your query logic, they just encourage people to use what they know. If you're trying to sharpen your skills, read up on best practices...

    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.

    October 22, 2012 at 4:04 am

    #1551287

  • RE: Exact multiple items

    Sean Lange (10/19/2012)

    tantcu (10/19/2012)

    I have limited knowledge about SQL. Could you guys more specific or give me like a sample to apply?

    BOL is the best place for this kind 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.

    October 19, 2012 at 11:54 am

    #1551001

  • RE: Is a job currently running and if so, what schedule kicked it off?

    That's good to know. Thanks for reporting 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.

    October 19, 2012 at 11:51 am

    #1550999

  • RE: Are the posted questions getting worse?

    SQLRNNR (10/19/2012)

    Sean Lange (10/19/2012)

    Is it just me or is the entire SSC site slow today? For me I can barely navigate anywhere. Each click is taking a couple minutes. No...

    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.

    October 19, 2012 at 11:49 am

    #1550997

  • RE: To sharpen the Query Logic

    SQL Server Books Online should be your first resource in understanding how queries work.

    SQL Queries for Mere Mortals can give you the basics in writing the SELECT statement (the heart...

    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.

    October 19, 2012 at 10:53 am

    #1550964

  • RE: Qusestion on delete job

    I have an odd question. Why do you need to delete 10000 records from your database every 4 minutes?

    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.

    October 19, 2012 at 10:41 am

    #1550962

  • RE: Is a job currently running and if so, what schedule kicked it off?

    Hee.

    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.

    October 19, 2012 at 10:39 am

    #1550961

Viewing 15 posts - 3,871 through 3,885 (of 9,715 total)