Viewing 15 posts - 5,536 through 5,550 (of 6,022 total)
seth 98372 (6/23/2011)
Thank you for your thoughtful response here. OPC.Three is right, though, we're doing the initial SQL Query in java, then processing the results (in java), and per each...
June 23, 2011 at 12:55 pm
Har-Har! I wish this were a homework assignment... This is me at my job trying to improve our app's performance. My boss prides himself as an SQL expert, and he's...
June 23, 2011 at 11:48 am
The worst type of errors are the are not really errors at all, but rather user misunderstandings about SQL functionality (or just typos made in haste) that compile, run with...
June 23, 2011 at 10:20 am
Steve Jones - SSC Editor (6/23/2011)
Eric M Russell (6/23/2011)
June 23, 2011 at 9:01 am
Regarding the client tools specifically (SSMS, BIDS, DAC, etc.), if the user's version of Windows has the latest .NET framework installed, then it shouldn't matter what version of Windows it...
June 23, 2011 at 8:12 am
I guess it depends on what exactly is meant by "will longer support". If that means they will no longer make extensions or big fixes to the code base to...
June 23, 2011 at 7:35 am
I don't think you mentioned the eact method currently used to pull data from the remote database; only that it is "queried". The advice below assumes you're just selecting from...
June 22, 2011 at 9:57 am
David Portas (6/21/2011)
Eric M Russell (6/20/2011)
June 22, 2011 at 8:50 am
I think that more regulation is needed. There are specific software and database design patterns that for decades have been known to be security vulnerabilities, and yet they continue to...
June 22, 2011 at 7:34 am
OCTom (6/21/2011)
I have been on the receiving end of Excel-based databases. As they become bigger, the data is harder to handle...
June 21, 2011 at 9:43 am
While we're on the topic of Excel in the Clouds, Microsoft's Excel Web App service provides not only the data but also the application in the cloud. It also allows...
June 21, 2011 at 7:59 am
One of my primary projects is developing and maintaining a reporting datamart for the accounting department. When a report is run, a dataset containing key and fact columns are queried...
June 20, 2011 at 7:51 am
David Portas (6/20/2011)
Eric M Russell (6/14/2011)
June 20, 2011 at 7:22 am
Somtimes one thing has to break before we discover that something else has been broken for a long time. For example, it takes a hurricane to reveal the fact that...
June 17, 2011 at 7:48 am
GSquared (6/16/2011)
Peter Maloof (6/16/2011)
Andy Warren (6/15/2011)
Got a phrase that you use to share a difficult concept?
Non-technical person: "It's working! What was the problem?"
Me: "You don't really want to know."
Non-technical person:...
June 16, 2011 at 1:09 pm
Viewing 15 posts - 5,536 through 5,550 (of 6,022 total)