Forum Replies Created

Viewing 15 posts - 7,861 through 7,875 (of 9,715 total)

  • RE: Psuedo Partion!!!!

    PeterG-377490 (7/8/2010)

    Trying to be proactive.

    Sales transaction database. 100's millions of rows. I built an access front end for users to view reporting.

    Sounds like if i let the sales columns...

    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 8, 2010 at 8:45 am

    #1190292

  • RE: How well do you really know your colleagues?

    Ah, my probationary period for one job started right in the middle of a major project. There'd been over a hundred scope changes the the project was due the end...

    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 8, 2010 at 7:56 am

    #1190245

  • RE: 70-448

    What do you mean summary? And why would someone need to send you their resume?

    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 8, 2010 at 4:27 am

    #1190108

  • RE: problem getting rid of a log file

    Good point about the TRUNCATEONLY issue being only data files. Maybe that's what I was working on, I don't remember.

    Alen, are you getting a specific error message when you try...

    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 8, 2010 at 4:25 am

    #1190107

  • RE: Psuedo Partion!!!!

    PeterG-377490 (7/7/2010)

    While i have your attention Brandie - I mentioned the typical query. That query will also return the sales information. Should i use those columns as an included column...

    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 8, 2010 at 4:20 am

    #1190105

  • RE: Best Alerting System For Small Company

    iqtedar (7/7/2010)

    thanks. One of the issues what i can forsee by using sql agent is that ,lets say i have 200 jobs then i will need to manually add agent...

    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 7, 2010 at 12:41 pm

    #1189812

  • RE: problem getting rid of a log file

    Did you try running the DBCC Shrinkfile with TruncateOnly after or before the EmptyFile?

    ISTR going through this and I had to run both of them (don't remember the order) before...

    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 7, 2010 at 12:33 pm

    #1189807

  • RE: Psuedo Partion!!!!

    PeterG-377490 (7/7/2010)

    I am NOT a DBA but have enough knowledge to do damage.

    Don't worry. We all started that way.. @=)

    PeterG-377490 (7/7/2010)

    A typical query would be to search for a transaction...

    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 7, 2010 at 12:28 pm

    #1189802

  • RE: Best Alerting System For Small Company

    As the others have said, this is all built into SQL Server already. And if there's an alert you can't find, but want, you can make your own.

    And on jobs,...

    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 7, 2010 at 12:20 pm

    #1189797

  • RE: CTE - Avoiding the cursor

    Eugene Elutin (7/6/2010)

    Post #945638 explains how you can generate random number using NEWID() function without using FranchiseID column to randomize.

    It doesn't uses FranchiseID in the TaxID...

    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 7, 2010 at 8:44 am

    #1189657

  • RE: CTE - Avoiding the cursor

    I just realized I'm going about this all wrong. I don't need *random* numbers specifically. I just need numbers that are NOT the TaxID. Which means I can use 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.

    July 7, 2010 at 8:41 am

    #1189655

  • RE: CTE - Avoiding the cursor

    First of all, "she", not he. @=)

    Secondly, I need random numbers that do not repeat. I'm not limited to a range, but I need to make sure they only repeat...

    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 6, 2010 at 11:33 am

    #1189239

  • RE: Error! Msg 103, Level 15, State 4, Line 1

    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 6, 2010 at 4:55 am

    #1189010

  • RE: cannot get DISTINCT results from nested inner joins

    lionwelp (7/1/2010)

    Brandie Tarvin (7/1/2010)

    Also, am I reading correctly that you want the most recent Druk_nr value? The one with the greatest (most recent) creatie__dat?

    I want to have the most recent...

    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 2, 2010 at 9:24 am

    #1188294

  • RE: HOW to split records of one column into multiple column

    CTE stands for Common Table Expression. There's no easy way to explain it except as a pre-query to your main query which can replace 1) a temp table, 2) replace...

    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 2, 2010 at 9:15 am

    #1188287

Viewing 15 posts - 7,861 through 7,875 (of 9,715 total)