Viewing 15 posts - 5,536 through 5,550 (of 6,025 total)
Back with SQL Server 2000, I would frequently leverage temporary tables and table variables for containing a small intermediate result which would then get joined with another query. However, since...
June 24, 2011 at 8:53 am
sqldba_icon (6/21/2011)
i) select * into #temp from tableA
ii) create table #temp (col 1)
insert into ...
June 23, 2011 at 3:29 pm
Perhaps a user entered some trash for the email address in the web form. When I exec the following, I see several character values that are invisible in a grid...
June 23, 2011 at 1:43 pm
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
Viewing 15 posts - 5,536 through 5,550 (of 6,025 total)