Forum Replies Created

Viewing 15 posts - 55,111 through 55,125 (of 59,078 total)

  • RE: Performance Tuning Guide

    It's the many that don't understand that we've run into in many a thread.  Between the two of us, it's almost like a standing joke... except it's not funny. 

  • RE: SQL Slowdown...

    You may have to limit the amount of memory each server uses because each is looking for 2 gig for a total of 4 gig... no room for the apps...

  • RE: What SQL Server edition should we be using

    Seems to me, based on the chart that Matt posted and the low volume of your anticipated connection/data plans, standard edition would do.

  • RE: Is it a lie?

    I sure do feel for folks that get stuck in that type of situation.  Definitely not a pleasant position.   Was going to suggest you find a new company but you've...

  • RE: Cannot connect to ReportServer

    Heh... maybe it figured out that you're breaking the license agreement and, therefore, the law by using the Developer Edition for production?

  • RE: Performance Tuning Guide

    Heh... yeah... I did noticed that... easier for them to throw hardware at the problem even though that doesn't work.  Still makes them feel like they did something.

  • RE: Calculating Work Days

    Oh yeah... almost forgot this... and speaking of "Thinking in Sets", Joe, you might want to include this in your new book... just because something is sans-loop, doesn't mean it's...

  • RE: Performance Tuning Guide

    Yeah... how 'bout that?  I'm thinking that a couple of us on this forum should get together and write our own book... one that has some useful info

  • RE: Date prob

    As a bit of a sidebar... why is it necessary to create a table named after a month and year???

  • RE: conditional line feed

    NULL concatenated with anything is still NULL if the default setting of "Concatenate Null Yields Null" was left on... so this simple ditty will do the job you asked...

    IsNull(@RbrComm+CHAR(13)+CHAR(10),'')

  • RE: Calculating Work Days

    ETL the "code" to a spreadsheet?  Why would you do that?  You'd ETL the query results to a spreadsheet... not the code.

    As I...

  • RE: Oracle

    Hmmm... let's see...

    Oracle protects me by doing an auto-commit if I happen to mix some DDL in a proc.  Really helpful there.  With SQL Server explicit transactions, I have to...

  • RE: Is it a lie?

    Who are you?  Why, you're part of a TEAM... and the TEAM failed.  You're not just another developer if you were part of the interviewing TEAM.  You should have asked...

  • RE: Update the rows which are divisible by 10

    Oh well, I tried... looks like yet another newbie got what they wanted but not what they needed... knowledge

    Peso, ol' friend... if you...

  • RE: Performance Tuning Guide

    P.S.  Increasing the number of rows to 30,000 (just added 50% more rows), caused the time on the first running total example to more than double at 4 minutes and...

Viewing 15 posts - 55,111 through 55,125 (of 59,078 total)