Forum Replies Created

Viewing 15 posts - 7,876 through 7,890 (of 9,725 total)

  • 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

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

    Good catch. I missed the '/' character. I was assuming that maybe he meant for that to be the unicode character of N.

    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:11 am

    #1188278

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

    Have you experimented with PIVOT yet? As usually coded, it wouldn't directly output your results as expected, but I bet you could nest a few PIVOT subqueries together to come...

    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 1, 2010 at 10:48 am

    #1187792

  • RE: cannot get DISTINCT results from nested inner joins

    Honestly, I think you're overly complicating things. You don't need the function, if I'm reading your code correctly. You can just do a CASE statement in the JOIN clause.

    Also,...

    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 1, 2010 at 10:42 am

    #1187788

  • RE: cannot get DISTINCT results from nested inner joins

    What is vvers_dat supposed to be? I'm running your code on my sandbox and I can't do the data insert because that column disallows NULLs and has no insert value...

    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 1, 2010 at 10:26 am

    #1187780

  • RE: CTE - Avoiding the cursor

    Thanks, everyone. I appreciate your assistance. Looks like I'm stuck with cursors still, but I'm well on my way to a solution.

    Soon as I verify it, I'll write up an...

    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 1, 2010 at 10:17 am

    #1187775

Viewing 15 posts - 7,876 through 7,890 (of 9,725 total)