Forum Replies Created

Viewing 15 posts - 4,486 through 4,500 (of 9,722 total)

  • RE: Search billions of records from multiple tables

    Kausar Mehmood (4/16/2012)


    What i have concluded right now after some R&D is that Partition table can solve the issue. It will not only ease Manageability issue but also improve performance....

    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: can we use data mining for simulating football game?

    Larry Page(Ehs_Akb) (4/13/2012)


    you should know when some one comes to these forum this man coming for help not for commerce.so you shouldn't be here .

    If I were 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.

  • RE: about restore

    praspras42 (4/13/2012)


    I just want to know that can i write a procedure with the help of which i can take the backup of all databases and can restore all 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: Search billions of records from multiple tables

    Kausar Mehmood (4/13/2012)


    I know that this depends on DB Design. We are already in development phase and I know we can use UNION statements for combining results from different queries,...

    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: Verifying Estimated Execution Plan results

    Thank you. I knew I was overlooking something.

    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: Search billions of records from multiple tables

    You don't need Full Text Indexing necessarily to do a search. If your indexes and statistics are good enough, then you can search billions of records without a problem.

    The problem...

    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: Abnormal SQL issue

    opc.three (4/12/2012)


    tt-615680 (4/12/2012)


    Brandie Tarvin (4/12/2012)


    Why does the replacement user need similar privledges? You're just shooting yourself in the foot.

    Remember, least permissions needed to do the job (figuratively and literally) should...

    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: Deadlock in data collection

    That's because they're using the same schedule (you can have jobs use an existing schedule, or each job have their own brand new schedule). Delete the schedule from job 3...

    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: can we use data mining for simulating football game?

    Larry Page(Ehs_Akb) (4/12/2012)


    this is the source code of that

    You misunderstand what he said. If you want to put the code in a web page and post the URL of 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: can we use data mining for simulating football game?

    Larry Page(Ehs_Akb) (4/12/2012)


    you mean i have to generate the data?

    Um, that's what I've been telling you. If you want to data mine, you need data (not information). There's a difference.

    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.

  • RE: UPDATE not working as expected

    Forgot about the variable option. I retract the "the only way" part of my earlier 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.

  • RE: [SSRS][Formula] Expression for subtracting values to get total

    What you do then is to create two report variables, one for EXP and one for IMP. Then have the variables subtract from each other.

    FYI: It's been a while since...

    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: UPDATE not working as expected

    SQL won't let you do that. The only way to guarantee order is to have two different UPDATE statements, or to fix your current one to pass in the hard...

    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: Search billions of records from multiple tables

    How is full text searching a limitation if you are allowed to use 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.

  • RE: Are the posted questions getting worse?

    So I'm using Display Estimated Execution Plan for the first time in SQL 2008 and fun, fun, it displays "missing indexes" across the top.

    Then I find an index suggestion where...

    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 - 4,486 through 4,500 (of 9,722 total)