Forum Replies Created

Viewing 15 posts - 4,276 through 4,290 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    Matt Miller (#4) (6/25/2012)

    GSquared (6/25/2012)

    Actually, if you define "NULL" as "unknown value" as opposed to "no value", then one could define a nullable char(1) column as "we may not know...

    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.

    June 25, 2012 at 11:29 am

    #1505214

  • RE: Are the posted questions getting worse?

    Matt Miller (#4) (6/25/2012)

    SQLRNNR (6/25/2012)

    Sean Lange (6/25/2012)

    Stefan Krzywicki (6/25/2012)

    Don't you love columns with "number" in the name that are typed as char or varchar?

    Or the date ones...

    InsertedDateTime int

    BAH!!!

    Or VarChar(1)

    Wait though...

    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.

    June 25, 2012 at 10:23 am

    #1505152

  • RE: Are the posted questions getting worse?

    Oh, wait. Got another one.

    Someone uses INT for a True-False / Yes-No / 0-1 column instead of BIT.

    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.

    June 25, 2012 at 10:10 am

    #1505139

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (6/25/2012)

    Revenant (6/25/2012)

    Sean Lange (6/25/2012)

    Stefan Krzywicki (6/25/2012)

    Don't you love columns with "number" in the name that are typed as char or varchar?

    Or the date ones...

    InsertedDateTime int

    BAH!!!

    There should be 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.

    June 25, 2012 at 10:08 am

    #1505138

  • RE: Today's Random Word!

    Daniel Bowlin (6/22/2012)

    Ray K (6/22/2012)

    quiet (where is everybody?)

    Slammed

    Overwhelmed (need a time machine or a duplicator ala Calvin & Hobbes)

    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.

    June 22, 2012 at 6:53 am

    #1504467

  • RE: Process (%Processor Time) Takes more than Number of Logical Cpus * 100

    Lynn Pettis (6/22/2012)

    One possibility, iirc, is that you could have hyperthreaded cores, which means 16 could be 32. Just a shot in the dark.

    That's the one of the two...

    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.

    June 22, 2012 at 6:09 am

    #1504450

  • RE: Process (%Processor Time) Takes more than Number of Logical Cpus * 100

    And you're seeing values of 2100?

    Are you on a virtual machine or a physical box?

    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.

    June 22, 2012 at 5:06 am

    #1504426

  • RE: Schedule task in sql server 2008

    That is a good point, Anthony. We were reading that question two different ways.

    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.

    June 22, 2012 at 5:04 am

    #1504425

  • RE: CDC is not working after renaming the database

    Glad it worked out for you.

    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.

    June 22, 2012 at 5:02 am

    #1504424

  • RE: Schedule task in sql server 2008

    FYI: The column is called run_time and you will have to jump through hoops to get it formated the way you want it. Not only does it count hours in...

    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.

    June 22, 2012 at 4:50 am

    #1504419

  • RE: Process (%Processor Time) Takes more than Number of Logical Cpus * 100

    Please clarify which counter you are looking at. There is no counter (that I can find) in PerfMon that is named exactly the way you name it in your post.

    I...

    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.

    June 22, 2012 at 4:46 am

    #1504417

  • RE: Locked out of Reporting Services - 2008r2

    Content manager is necessary because SSRS, like the rest of the SQL Server tools, isn't going to allow a box admin to get into its data without someone saying 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.

    June 22, 2012 at 4:39 am

    #1504415

  • RE: CDC is not working after renaming the database

    Have you tried disabling CDC and then re-enabling it?

    You may also have to restart the services, but I'd try the above suggestion first. Chances are CDC is still looking 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.

    June 22, 2012 at 4:35 am

    #1504414

  • RE: disk space 90% full...

    mtassin (6/21/2012)

    Check the size of your logs in proportion to the size of the data files. If they're too big, you'll probably have to shrink them. After you've...

    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.

    June 22, 2012 at 4:30 am

    #1504413

  • RE: Are the posted questions getting worse?

    OMG.

    This space left intentionally blank due to possible harm by misunderstanding. No electrons were hurt in the blanking of this space. If you or a loved one are witness or...

    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.

    June 21, 2012 at 12:35 pm

    #1504148

Viewing 15 posts - 4,276 through 4,290 (of 9,715 total)