Forum Replies Created

Viewing 15 posts - 45,451 through 45,465 (of 59,063 total)

  • RE: Table Variables and performance

    Michael Earl (10/8/2008)

    A table variable usually has to get pretty big before it spills over into TempDB.

    Just because the table name shows up in TempDB, doesn't mean that's where it...

    January 28, 2009 at 10:28 am

    #933976

  • RE: Table Variables and performance

    Peso (10/13/2008)

    There you go! 🙂

    I learn something new every day...

    Heh... me too! That's why I hang around here so much. Today, I learned that there was such a...

    January 28, 2009 at 10:23 am

    #933966

  • RE: What are the Party Plans?

    Steve Jones - Editor (1/28/2009)

    Yep, wasn't sure it would cross over night or today, and I still have images coming for the stuff, so announcement tomorrow.

    thanks everyone!!

    I think we're purchasing...

    January 28, 2009 at 10:17 am

    #933963

  • RE: Hierarchies in SQL

    danielk1 (1/28/2009)

    I just feel, to tie myself to a DB structure type, like you mentioned using the hierarchcical ID, might limit my application's portability - say, if I want to...

    January 28, 2009 at 10:10 am

    #933954

  • RE: Hierarchies in SQL

    ventsislav.mladenov (1/28/2009)

    Or you could use CLR store procedures which are very fast in execution and sometimes are faster than T-SQL.

    http://blog.vmladenov.com/?p=197

    Since you say "Now the fact is that the C# store...

    January 28, 2009 at 10:02 am

    #933952

  • RE: Trying to rewrite RBAR Function

    Your last couple of sentences put that all together very nicely! I was aware of being able to put indexes on calculated columns, but didn't know you could make...

    January 28, 2009 at 9:54 am

    #933946

  • RE: Trying to rewrite RBAR Function

    Ok... the reason why the Tally table looses is because of the extra calculation I had to put into the STUFF function to make the Tally table appear to count...

    January 28, 2009 at 9:50 am

    #933943

  • RE: Trying to rewrite RBAR Function

    Jean-François Bergeron (1/28/2009)

    Well, I got a simple 3.0Ghz Dev machine with 4GB of Ram. It's not that quick, trust me. And I ran the query on 200k rows that has...

    January 28, 2009 at 8:15 am

    #933846

  • RE: Trying to rewrite RBAR Function

    smunson (1/28/2009)

    Jeff,

    Can you supply the code necessary to generate the test data you used? I have a quad-core 2.83GHz machine with SQL 2005 DE SP2 that I'd...

    January 28, 2009 at 8:01 am

    #933837

  • RE: CLR Running in Mirrored Environment

    Actually, that does. Thank you for taking the time to explain.

    January 28, 2009 at 7:59 am

    #933835

  • RE: Earning Credit

    Domagoj Orec (1/28/2009)

    Steve you should have been more suspicious about this guy, he joined two months ago and has only 4 visits to this page and 0 points.

    plagiarism is always...

    January 28, 2009 at 6:05 am

    #933731

  • RE: SMO vs SQL-DMO

    Actually, I'd still like to know (if the OP ever gets this), what either was being used for. Sometimes, there's a T-SQL solution that will blow both methods out...

    January 28, 2009 at 6:02 am

    #933728

  • RE: CLR Running in Mirrored Environment

    jzelenda,

    What does the CLR actually do, please?

    January 28, 2009 at 6:00 am

    #933725

  • RE: CLR Running in Mirrored Environment

    Heh... and we still don't know what the CLR does, do we? 😉

    January 28, 2009 at 5:59 am

    #933723

  • RE: Hierarchies in SQL

    Nicely done, Gus. And, considering that the article is about a fix you made for an actual problem having to do with Adjacency and Nested Set methods, I...

    January 28, 2009 at 5:33 am

    #933711

Viewing 15 posts - 45,451 through 45,465 (of 59,063 total)