Viewing 15 posts - 55,111 through 55,125 (of 59,078 total)
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.
September 9, 2007 at 11:47 pm
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...
September 9, 2007 at 10:32 am
Seems to me, based on the chart that Matt posted and the low volume of your anticipated connection/data plans, standard edition would do.
September 9, 2007 at 10:24 am
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...
September 9, 2007 at 9:27 am
Heh... maybe it figured out that you're breaking the license agreement and, therefore, the law by using the Developer Edition for production? ![]()
September 9, 2007 at 9:20 am
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.
September 9, 2007 at 9:18 am
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...
September 8, 2007 at 9:40 pm
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
September 8, 2007 at 7:04 pm
As a bit of a sidebar... why is it necessary to create a table named after a month and year??? ![]()
September 8, 2007 at 7:02 pm
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),'')
September 8, 2007 at 6:58 pm
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...
September 8, 2007 at 9:49 am
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...
September 8, 2007 at 8:58 am
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...
September 8, 2007 at 8:02 am
Oh well, I tried... looks like yet another newbie got what they wanted but not what they needed... knowledge ![]()
Peso, ol' friend... if you...
September 8, 2007 at 1:02 am
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...
September 8, 2007 at 12:57 am
Viewing 15 posts - 55,111 through 55,125 (of 59,078 total)