Forum Replies Created

Viewing 15 posts - 5,116 through 5,130 (of 9,715 total)

  • RE: Understand this SQL Script

    What GSquared said.

    FYI: Depending on the business, you could get fired for uploading a database onto the internet. Engage in CYA. Post sample tables and sample data insert scripts...

    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.

    November 11, 2011 at 8:42 am

    #1406342

  • RE: Second Pair of Eyes, Please

    GAH!

    Thank you, guys. I knew it was something simple.

    EDIT: I was also looking at the wrong bit of code in my error search.. DOH.

    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.

    November 11, 2011 at 8:33 am

    #1406333

  • RE: Putting a condition on a subgroup to query result

    Given the scenario, this sounds like a homework question.

    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.

    November 11, 2011 at 8:28 am

    #1406327

  • RE: Are the posted questions getting worse?

    Jack Corbett (11/11/2011)

    Brandie Tarvin (11/11/2011)

    EEEK! I just sold another story. Happy happy.

    Now I have to write more.

    Congrats! I don't know how you do it AND keep up with...

    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.

    November 11, 2011 at 8:07 am

    #1406295

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/11/2011)

    Roy Ernest (11/11/2011)

    Brandie Tarvin (11/11/2011)

    EEEK! I just sold another story. Happy happy.

    Now I have to write more.

    Congrats Brandie. Wonderful job. 🙂 You can stop working as a DBA...

    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.

    November 11, 2011 at 7:51 am

    #1406272

  • RE: Why is my SELECT query slower when the table is indexed?

    The transaction will continue to run until it's completely rolled back. Rollbacks can take a while, just like the initial execution. It depends on how far the initial transaction went....

    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.

    November 11, 2011 at 7:31 am

    #1406253

  • RE: Are the posted questions getting worse?

    EEEK! I just sold another story. Happy happy.

    Now I have to write more.

    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.

    November 11, 2011 at 7:28 am

    #1406249

  • RE: ??Bug in ROW_NUMBER() + Partition BY in CTE

    Glad you found a solution, even if it doesn't help you right now.

    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.

    November 11, 2011 at 6:24 am

    #1406204

  • RE: ??Bug in ROW_NUMBER() + Partition BY in CTE

    SQL Kiwi (11/11/2011)

    Ninja's_RGR'us (11/11/2011)

    Cancel that... seems like the upgrade failed.

    Who said there was no risk? :hehe:

    No-one - the phrase was "pretty small risk".

    It works 99.99% of the time.

    ...well, okay....

    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.

    November 11, 2011 at 5:09 am

    #1406188

  • RE: ??Bug in ROW_NUMBER() + Partition BY in CTE

    If you can resolve the problem by moving your WHERE clause, though, is it really that big of a deal?

    I personally think you should upgrade to SP4, BTW. I'm just...

    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.

    November 11, 2011 at 4:55 am

    #1406183

  • RE: ??Bug in ROW_NUMBER() + Partition BY in CTE

    Would you actually be using a WHERE clause IRL?

    Or does the WHERE clause exist only to limit your row values at the moment?

    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.

    November 10, 2011 at 8:57 am

    #1405846

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/10/2011)

    Stefan Krzywicki (11/10/2011)

    Kiara (11/10/2011)

    Stefan Krzywicki (11/10/2011)

    Kiara (11/10/2011)

    In case y'all haven't seen this.. http://thedailywtf.com/Articles/The-Query-of-Despair.aspx...

    I'm sure we've all had days like that...

    I inherited a query like that back in 99. 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.

    November 10, 2011 at 8:26 am

    #1405817

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/10/2011)

    Brandie Tarvin (11/10/2011)

    Ninja's_RGR'us (11/10/2011)

    Got another puzzle for you guys and possibly another bug (row_number, partition by & cte).

    http://www.sqlservercentral.com/Forums/Topic1203532-266-1.aspx

    Gave it an initial shot. Want to see what your answer is...

    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.

    November 10, 2011 at 8:23 am

    #1405811

  • RE: ??Bug in ROW_NUMBER() + Partition BY in CTE

    When you have time...

    What exactly is the data supposed to be? Product data? What do the dates mean for the data? (I'm looking for the English explanation here so 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.

    November 10, 2011 at 8:21 am

    #1405808

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/10/2011)

    Got another puzzle for you guys and possibly another bug (row_number, partition by & cte).

    http://www.sqlservercentral.com/Forums/Topic1203532-266-1.aspx

    Gave it an initial shot. Want to see what your answer is before I delve...

    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.

    November 10, 2011 at 8:11 am

    #1405792

Viewing 15 posts - 5,116 through 5,130 (of 9,715 total)