Forum Replies Created

Viewing 15 posts - 4,471 through 4,485 (of 9,715 total)

  • RE: Search billions of records from multiple tables

    My experience says that the best solution is entirely dependent on your database schema. As I don't know what your schema is, and I don't know anything about your data,...

    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.

    April 16, 2012 at 12:29 pm

    #1474277

  • RE: Today's Random Word!

    SQLRNNR (4/16/2012)

    L' Eomot Inversé (4/16/2012)

    Revenant (4/16/2012)

    L' Eomot Inversé (4/16/2012)

    Daniel Bowlin (4/16/2012)

    Pollen

    Bees

    Fleas > sneeze

    tease

    knees

    PT

    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.

    April 16, 2012 at 10:59 am

    #1474206

  • RE: Are the posted questions getting worse?

    WayneS (4/16/2012)

    Brandie Tarvin (4/16/2012)

    If any would-be employee claims to be a Threadzian, we have two questions that we can now ask them during the interview.

    2) How many parameters does DBCC...

    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.

    April 16, 2012 at 10:58 am

    #1474205

  • RE: SSIS Pkg with Web Service Call - Troubleshooting Advice

    Actually, I found a solution. Sort of.

    The queries touch 4 tables. 1 has 2 indexes (1 clustered, 1 non), and the other 3 only had clustered indexes on the PK....

    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.

    April 16, 2012 at 10:35 am

    #1474186

  • RE: Are the posted questions getting worse?

    If any would-be employee claims to be a Threadzian, we have two questions that we can now ask them during the interview.

    1) What does sp_kleenex do and when would 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.

    April 16, 2012 at 10:32 am

    #1474181

  • RE: Are the posted questions getting worse?

    He was applying for the Ninja Dev job. I take it he passed? @=)

    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.

    April 16, 2012 at 7:05 am

    #1474001

  • RE: CAREER ADVICE: Applying for DBA Jobs?

    Gabe T. (4/13/2012)

    4) With recruiters, be patient with them, and understand their standpoint. Typically they can hardly spell SSIS, let alone tell you what the difference between a foreach container...

    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.

    April 16, 2012 at 4:56 am

    #1473932

  • RE: Are the posted questions getting worse?

    capn.hector (4/13/2012)

    ok on topic: http://www.sqlservercentral.com/Forums/Topic1283271-392-1.aspx how do you long time posters keep going when you run into people like this. (one thread there are more out there)...

    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.

    April 16, 2012 at 4:36 am

    #1473927

  • 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.

    April 16, 2012 at 4:23 am

    #1473924

  • 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.

    April 13, 2012 at 7:45 am

    #1473247

  • 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.

    April 13, 2012 at 7:39 am

    #1473244

  • 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.

    April 13, 2012 at 7:37 am

    #1473242

  • 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.

    April 13, 2012 at 6:25 am

    #1473185

  • 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.

    April 13, 2012 at 5:35 am

    #1473156

  • 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.

    April 13, 2012 at 5:28 am

    #1473153

Viewing 15 posts - 4,471 through 4,485 (of 9,715 total)