Forum Replies Created

Viewing 15 posts - 7,141 through 7,155 (of 9,725 total)

  • RE: sp_reset_connections - DORMANT connections

    Remember that connections are different from threads. One connection can spawn many threads.

    Which is it you're trying to control? Connections or threads?

    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.

    October 21, 2010 at 5:25 am

    #1240192

  • RE: Bundle/Group data elements linked in M-M table

    kajf (10/20/2010)

    Below query gives me all straight relations (have not created a BundleID but in this easy case I can set an unique BID per A) .

    ...

    Result:

    A3C3

    A4C4

    A4C5

    Is it a good...

    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.

    October 21, 2010 at 5:19 am

    #1240190

  • RE: Bundle/Group data elements linked in M-M table

    Kaj,

    Here's why no one's responded yet. Your question breaks down at this point.

    kajf (10/20/2010)

    I have a table AC containing two attributes A and C which have a many-many relationship. What...

    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.

    October 21, 2010 at 5:07 am

    #1240179

  • RE: Bundle/Group data elements linked in M-M table

    Do us a favor? When posting your DDL statements, remember to put quotes around string values that are to be inserted. It makes it easier on us when we don't...

    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.

    October 21, 2010 at 5:00 am

    #1240171

  • RE: Bulk Insert Error: Linked Server "(null)"

    chris.stuart (10/21/2010)

    When I say manually, I love editing the packages outside of BIDS, and in 2008 it works much better (manual edit of the package) where as in 2005 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.

    October 21, 2010 at 4:45 am

    #1240158

  • RE: Why would the same query use 2 different indexes based on date?

    RICHTER-311234 (10/20/2010)

    I have rebuilt the index and ran a updatestats full on the index I am wanting both queries to use, Just a bit at a loss as to what...

    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.

    October 21, 2010 at 4:37 am

    #1240150

  • RE: Delete Records older than 90 days

    Could you please post your table structure and some sample data so we could verify the advice we're giving you before we give it? It's hard to help you when...

    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.

    October 21, 2010 at 4:33 am

    #1240148

  • RE: Can any one please guide,how to split this result,

    There are several ways to split strings in addition to the method Chris mentioned. Google "SQL Server Split Strings," choose one that seems to work, and apply that methodology to...

    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.

    October 21, 2010 at 4:32 am

    #1240146

  • RE: Bulk Insert Error: Linked Server "(null)"

    chris.stuart (10/21/2010)

    When you select the table to be populated in the drop down list in the OLE Destination component, you have the "Name of the table or the view:", 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.

    October 21, 2010 at 4:19 am

    #1240141

  • RE: Today's Random Word!

    CirquedeSQLeil (10/20/2010)

    Ray K (10/20/2010)

    Word Code of the day . . .select cup from coffee

    where caffeine = 'high'

    You won't get any that way, try this:

    select coffee

    Into #Mug

    from Pot

    where caffeine = 'high'

    Boys,...

    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.

    October 20, 2010 at 9:02 am

    #1239748

  • RE: More efficient way

    irobertson (10/20/2010)

    Hi Bill,

    One thing you might like to try is to pre-calculate the two correlated subqueries that you're using to generate criteria and hold the values in variables.

    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.

    October 20, 2010 at 8:14 am

    #1239712

  • RE: SSIS Mapping documentation

    I'd still like the OP to answer. Assumptions about this sort of thing are dangerous.

    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.

    October 20, 2010 at 7:25 am

    #1239673

  • RE: SSIS Mapping documentation

    I'm a little confused. What exactly are you trying to map?

    Are you just trying to show the "guts" of a SSIS package? Or is this something else?

    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.

    October 20, 2010 at 7:18 am

    #1239665

  • RE: SSRS Parameter that give users options to insert values manual

    Pitso,

    You should be able to do it just fine using Parameters in SSRS, unless something changed in 2008 that I don't know about. I believe you make the value as...

    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.

    October 20, 2010 at 7:15 am

    #1239662

  • RE: Bulk Insert Error: Linked Server "(null)"

    Riiiggght. Quite a DUH moment for me here.

    Bulk Insert Task doesn't work if the table has more or less columns than the file has.

    To make it work, I had to...

    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.

    October 20, 2010 at 7:10 am

    #1239656

Viewing 15 posts - 7,141 through 7,155 (of 9,725 total)