Viewing 15 posts - 5,551 through 5,565 (of 6,041 total)
sqldba_icon (6/24/2011)Eric not sure what do u mean by that question but that is not under my control. There could be a way to reduce the number of records but...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 24, 2011 at 9:01 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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 ...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 23, 2011 at 10:20 am
Steve Jones - SSC Editor (6/23/2011)
Eric M Russell (6/23/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 22, 2011 at 9:57 am
David Portas (6/21/2011)
Eric M Russell (6/20/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 21, 2011 at 7:59 am
Viewing 15 posts - 5,551 through 5,565 (of 6,041 total)