No announcements
Found 2079838 threads
-
0 VotesQuickest and most efficient ways to handle data
Answers I have found so far: Quickest way to move the data: 1) SSIS 2) DELETE FROM dbo.Table1 ...Answered | 3 Replies | 1789 Views | Created by rockstar283 - Tuesday, September 17, 2013 5:27 PM | Last reply by rockstar283 - Wednesday, September 18, 2013 8:59 AM
-
0 Votes
Manipulating indexes and threads in efficient way
Following code is one way to do what you want: #include <amp.h> #include <iostream> using namespace ...Answered | 3 Replies | 2618 Views | Created by LaParma - Monday, December 17, 2012 10:50 PM | Last reply by LingliZhang - Wednesday, January 2, 2013 7:39 AM -
1 Votes
More efficient way to code this statement?
He would re-write everything!Answered | 40 Replies | 4237 Views | Created by NoEgo - Monday, December 8, 2008 5:17 PM | Last reply by deadManN - Monday, January 12, 2009 11:08 AM -
1 Votes
What is the most efficient way of testing "null values"?
It might be worth testing for that to see if it resolves your problem Private Sub ...Answered | 6 Replies | 2673 Views | Created by RKage - Wednesday, June 8, 2011 11:54 AM | Last reply by Yann Duran - Thursday, June 9, 2011 12:12 AM -
6 Votes
[vb.net] More efficient way to do this?
At the end of each of your sessions of creating, a method will write the output as a single .xml file which you'll then upload to the site area that I create for you.Answered | 35 Replies | 1070 Views | Created by treeman1111 - Tuesday, June 10, 2014 11:12 PM | Last reply by tommytwotrain - Sunday, June 15, 2014 11:03 PM -
0 Votes
BEST WAY OF WRITING CODE
This condition is a bit strange - what is the exact intent: AND A.DATA_YR =(select max(data_yr) from dbo.fact_wk_sum) AND A.DATA_MO= (select max(data_mo) from ...Answered | 6 Replies | 2064 Views | Created by KODI_KODI - Thursday, January 10, 2013 10:52 PM | Last reply by Varsha Mishra - Friday, January 11, 2013 12:40 PM -
2 Votes
Efficient way to make a wait/hold to the execution/process .
https://social.msdn.microsoft.com/Forums/en-US/e3713497-1f55-4bc9-a072-03490a3de479/best-way-to-wait?Answered | 11 Replies | 3176 Views | Created by Help on BizTalk - Thursday, May 26, 2016 5:09 PM | Last reply by Help on BizTalk - Tuesday, June 7, 2016 3:01 AM -
2 Votes
Efficiency Issue
One suggests to write the program in C#.Answered | 2 Replies | 1734 Views | Created by BGQQ - Friday, August 24, 2012 8:39 PM | Last reply by BGQQ - Saturday, August 25, 2012 3:05 PM -
1 Votes
Better way to write this Query
You can check your query or variation of your query's execution plan to see whether there is a better way to optimize it.Answered | 6 Replies | 1170 Views | Created by Diango - Monday, December 30, 2013 2:34 PM | Last reply by Naomi N - Monday, December 30, 2013 8:48 PM -
0 Votes
What is the best efficient way to create optimized query with lots of fields in this scenario
Write more procedures but simpler ones.Answered | 4 Replies | 5372 Views | Created by MS User 1977 - Wednesday, May 25, 2011 2:10 PM | Last reply by Naomi N - Friday, May 27, 2011 2:13 PM -
6 Votes
Better way to select records?
Also from Celko: "EXISTS (SELECT * FROM . . . ) In general, the ...Answered | 12 Replies | 1938 Views | Created by Kenrav - Tuesday, March 20, 2012 3:00 AM | Last reply by datAdrenaline - Thursday, March 22, 2012 5:11 PM -
0 Votes
Is there a way to filter out columns when writing a select statement in SQL Server
Hi, you can try like this select stuff((select ','+col as [text()] from(select table_name,COLUMN_name as col from ...Answered | 4 Replies | 5135 Views | Created by CSharp Enthusiast - Saturday, February 12, 2011 1:27 AM | Last reply by Rishabh K - Monday, February 14, 2011 4:27 AM -
2 Votes
Most Efficient way to locate duplicates
1 For every expert, there is an equal and opposite expert. - Becker's LawAnswered | 6 Replies | 825 Views | Created by ProfessorFudger - Thursday, February 11, 2016 2:42 PM | Last reply by Naomi N - Thursday, February 11, 2016 4:13 PM -
0 Votes
Most efficient way to query two tables for latest date
Also, I think your query is as efficient as it can be.Answered | 5 Replies | 1161 Views | Created by JasonDWilson77 - Monday, February 17, 2014 3:48 PM | Last reply by JasonDWilson77 - Thursday, February 20, 2014 3:02 AM -
1 Votes
how to Write query in better way
select * from dept where @emp IN ('ALL', emp);Answered | 7 Replies | 2411 Views | Created by Aminesh - Tuesday, December 6, 2011 7:22 AM | Last reply by Brian Tkatch - Tuesday, December 6, 2011 2:32 PM -
1 Votes
Which is Fast or Efficient way of doing !!!!
I actually prefer a 4th variation: IF EXISTS (select 1 from Table1 where Col1 = 12345) -- do ...Answered | 3 Replies | 2379 Views | Created by vchandm23 - Monday, August 22, 2011 8:00 AM | Last reply by Naomi N - Monday, August 22, 2011 4:37 PM -
3 Votes
More efficient way to remove 1st character from a string
Something cannot be "more efficient" in isolation.Answered | 7 Replies | 68531 Views | Created by Avatar 123 - Thursday, June 6, 2013 2:52 PM | Last reply by PaulLinton - Saturday, June 8, 2013 8:14 AM -
0 Votes
Select once and search data or select multiple times?
So, should I select the whole table and then in my code search only for those in that city?Answered | 3 Replies | 668 Views | Created by Tomer Agmon - Friday, January 29, 2016 10:28 AM | Last reply by Eric__Zhang - Monday, February 1, 2016 6:05 AM -
0 Votes
Most Efficient Default Value for a Parameter
You can use something like this SELECT ...............Answered | 5 Replies | 4196 Views | Created by Ken in Tampa - Wednesday, November 24, 2010 4:21 PM | Last reply by Ken in Tampa - Monday, November 29, 2010 2:15 PM -
0 Votes
Efficiently delete a large list.
Efficiently Delete/Purge All items From A SharePoint List Note that you can take the same code and tweak it for usage in PowerShell, and then run it on ...Answered | 3 Replies | 4125 Views | Created by Atli Þ - Friday, October 21, 2011 10:10 AM | Last reply by Michael Mukalian - Friday, October 28, 2011 1:08 PM
No announcements
