No announcements
Found 2080024 threads
-
0 VotesEfficient way to write Select
In case of exact match you write = instead of LIKE.Answered | 3 Replies | 4469 Views | Created by NSG12 - Friday, April 23, 2010 9:52 PM | Last reply by - Thursday, February 4, 2016 3:18 AM
-
3 Votes
Most efficient way of selecting rows at random
If you have an index then it will help improve performance of at least one branch of the query depending on the statistics and cardinality of the predicate Next, with respect to retrieving a ...Answered | 2 Replies | 1109 Views | Created by James.Thomas100 - Tuesday, June 16, 2015 7:58 AM | Last reply by James.Thomas100 - Thursday, June 18, 2015 11:47 AM -
0 Votes
Efficient way of filtering Dimension properties
From what I have read on MDX so far, it is best to try and utilise Bulk execution mode as often as possible when writing a query.Answered | 2 Replies | 893 Views | Created by MrHappyHead - Wednesday, April 2, 2014 10:25 PM | Last reply by MrHappyHead - Thursday, April 3, 2014 11:02 AM -
1 Votes
efficient way to reset byte array
Use Louis' first example as the implementation is inside the CLR so we can imagine that it uses an efficient algorithm.Answered | 4 Replies | 30828 Views | Created by logan_spirit - Friday, March 5, 2010 4:03 PM | Last reply by logan_spirit - Friday, March 5, 2010 9:46 PM -
0 Votes
Efficient way to rewrite this query
create table mytable (ColA int primary key, colB int, colc bit, col1 int, col2 int, col3 int, col4 int, col5 int, col6 int, col7 int) insert into mytable (cola,colB, colc, col1,col2,col3) ...Answered | 2 Replies | 679 Views | Created by srs007 - Monday, July 28, 2014 9:26 PM | Last reply by Jingyang Li - Monday, July 28, 2014 9:43 PM -
3 Votes
Efficient way to join huge tables
SELECT id, time, value, value_lst = LAG(value) OVER(PARTITION BY id ORDER BY time), ...Answered | 3 Replies | 634 Views | Created by Jason_86 - Wednesday, December 14, 2016 8:09 PM | Last reply by Erland Sommarskog - Thursday, December 15, 2016 8:12 AM -
1 Votes
Efficient way of reading binary file into byte array?
Memory mapping a file is the most I/O efficient way. .NET 4.0 will include support for this.Answered | 4 Replies | 6607 Views | Created by BBauer42 - Thursday, February 11, 2010 2:29 PM | Last reply by kenneth.cochran - Thursday, February 11, 2010 5:25 PM -
0 Votes
how to write efficient stored procedure
Each query must be efficient on its own 4.Answered | 8 Replies | 5603 Views | Created by luckyforu2006 - Monday, April 12, 2010 1:01 PM | Last reply by Kalman Toth - Monday, April 12, 2010 3:43 PM -
0 Votes
Most efficient way to convert strings to uniqueidentifier
I was hoping there might be a shorter way of doing this.Answered | 2 Replies | 825 Views | Created by amx2012 - Wednesday, June 8, 2016 12:22 AM | Last reply by amx2012 - Wednesday, June 8, 2016 4:59 PM -
1 Votes
Is There A More Efficient Way Of Doing This?
Try it this way: UPDATE MyTable SET Field1=ISNULL(@Field1,Field1) ...Answered | 3 Replies | 3594 Views | Created by Triyence - Wednesday, July 6, 2011 4:05 PM | Last reply by --CELKO-- - Wednesday, July 6, 2011 6:22 PM -
2 Votes
Write query efficiently
select * from @Event where ID not in (select ID from @event where Event = 'No Show' and venue = 'USA' and ID not in (select ID from @Event where ...Answered | 6 Replies | 1944 Views | Created by CSharp Enthusiast - Friday, October 26, 2012 2:42 PM | Last reply by Rishabh K - Monday, October 29, 2012 5:57 AM -
1 Votes
Efficient way to calculate unique values
If you only need 1 set of dates, then just change my last solution slightly: ;with cte as (select *, row_number() over (partition by ID, case when SetDate IS NULL then 1 ...Answered | 29 Replies | 997 Views | Created by app087 - Tuesday, July 14, 2015 8:17 PM | Last reply by app087 - Thursday, July 16, 2015 3:58 PM -
2 Votes
Most efficient way to asynchronously start a number of Actions
Right.. is it possible that Parallel.ForEach could be more efficient for lots of small actions; as it may execute them with less parallelism and therefore require less pool threads?Answered | 6 Replies | 5024 Views | Created by Fil Mackay - Monday, November 29, 2010 9:33 PM | Last reply by Stephen Toub - MSFT - Tuesday, December 7, 2010 2:07 AM -
1 Votes
Efficient way of doing ??
What is the efficient way of doing this?Answered | 13 Replies | 984 Views | Created by Rehan Mubarak - Thursday, October 15, 2015 5:41 PM | Last reply by TiborK - Friday, October 16, 2015 8:54 AM -
0 Votes
Parent and Child - Efficient way to add column
Just carry it through, your initial cte also looks a touch superfluous ;WITH xt AS ( SELECT Child as Root, Parent, Child, [Name], 1 AS 'Level' FROM ...Answered | 2 Replies | 440 Views | Created by Gil Gerald - Friday, June 9, 2017 2:30 AM | Last reply by Xi Jin - Friday, June 9, 2017 8:59 AM -
1 Votes
Efficient way to write huge boost dynamic_bitset vector to a file and read it back in C++
I want to write the dynamic_bitset vector to a file and later read the file back into a dynamic_bitset vector.Answered | 3 Replies | 7073 Views | Created by Pragadheesh - Friday, July 6, 2012 3:13 PM | Last reply by Grigoriy Chudnov - Friday, July 6, 2012 5:51 PM -
0 Votes
how to convert a img into a graph in a efficient way?
There are plenty of algorithms for performing the grayscale conversion on raster graphics, pick one w/ an efficiency that matches your needs.Answered | 1 Replies | 2701 Views | Created by Julamotte - Friday, October 23, 2009 1:16 PM | Last reply by P.Brian.Mackey - Friday, October 23, 2009 2:39 PM -
0 Votes
Efficient way to commit changes instantly?
Let me know if you need me to write that function for you.Answered | 8 Replies | 1652 Views | Created by HTHP - Sunday, March 5, 2017 7:58 PM | Last reply by HTHP - Monday, March 6, 2017 10:31 PM -
0 Votes
Alter primary key constraint - efficient way
It isn't efficient in the way I suspect you want it to be efficient but it's about the only way to go about doing what you need.Answered | 3 Replies | 1085 Views | Created by priya-s - Wednesday, July 30, 2014 8:04 PM | Last reply by Uri Dimant - Saturday, August 2, 2014 7:21 PM -
0 Votes
Quickest 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 | 1735 Views | Created by rockstar283 - Tuesday, September 17, 2013 5:27 PM | Last reply by rockstar283 - Wednesday, September 18, 2013 8:59 AM - Items 1 to 20 of 2080024 Next ›
No announcements
