No announcements
Found 403194 threads
-
4 VotesCasting Performance
Unnecessary casting is a performance warning when you enable static Code Analysis.Answered | 4 Replies | 4150 Views | Created by Jason17439 - Friday, June 24, 2011 2:21 PM | Last reply by Evan Machusak - Sunday, June 26, 2011 3:26 AM
-
0 Votes
Linq Performance and Casting
Difference possibly comes from the more logic in OfType than in first query with is and as, but that compination does the casting twice.Answered | 5 Replies | 3166 Views | Created by KellyInSeattle - Wednesday, January 16, 2013 3:50 PM | Last reply by MasaSam - Thursday, January 17, 2013 7:18 PM -
0 Votes
CAST/CONVERT Performance with sql_variant Columns
So even with the explicit cast you got the scan?Answered | 4 Replies | 9411 Views | Created by JediSQL - Monday, August 20, 2012 9:39 PM | Last reply by JediSQL - Thursday, August 23, 2012 7:02 PM -
2 Votes
How much do CAST statements affect performance?
But even if the scalar UDF does not perform any data access, there is a certain call overhead.Answered | 5 Replies | 27487 Views | Created by Nick Ryan - Thursday, June 26, 2014 10:54 PM | Last reply by Erland Sommarskog - Friday, June 27, 2014 9:02 PM -
0 Votes
CAST and performance problem with generated SQL
[Id] WHERE ( CAST( [Extent1].Answered | 1 Replies | 4563 Views | Created by Flavien Charlon - Wednesday, March 18, 2009 2:07 PM | Last reply by Kati Iceva - MSFT - Tuesday, April 7, 2009 9:05 PM -
2 Votes
CAST in delete query-Performance is so slow
To add to Kent and Hunchback's answers: The cast/convert on the column will prevent the optimizer from performing any "seeks" on the join column.Answered | 6 Replies | 4715 Views | Created by orlando_fl - Thursday, September 16, 2010 6:34 PM | Last reply by --CELKO-- - Tuesday, September 28, 2010 7:02 PM -
0 Votes
Performance issue with ef casting in where clause
It looks to me as a bug to use cast function im where clause and cause bad performance. any thoughts?Answered | 4 Replies | 4684 Views | Created by LudaGrich - Wednesday, August 1, 2012 3:32 AM | Last reply by Alexander Sun - Friday, August 3, 2012 2:07 AM -
0 Votes
object and casting into it
why do we cast , what task does it perform Hi, Casting is an explicit conversion between ...Answered | 2 Replies | 681 Views | Created by amigo 1 - Wednesday, July 2, 2014 11:51 AM | Last reply by Nick Holmes - Eurofins - Wednesday, July 2, 2014 1:00 PM -
2 Votes
Object Casting ?
No, I'm not saying that casting is not allowed.Answered | 6 Replies | 3267 Views | Created by Vivek Ragunathan - Saturday, December 6, 2008 3:59 AM | Last reply by Vivek Ragunathan - Wednesday, February 25, 2009 12:20 PM -
0 Votes
Cast
SELECT CAST(12.345 AS varchar(6)); -- Arithmetic overflow error converting numeric to data type varchar.Answered | 10 Replies | 927 Views | Created by CIWorker - Wednesday, March 2, 2016 7:57 PM | Last reply by Sam Zha - Thursday, March 3, 2016 2:46 AM -
0 Votes
CAST?
DECLARE @dateTime DATETIME = '2015-12-01 08:25:47.300' SELECT STUFF(CAST(@dateTime AS VARCHAR),18,0,':'+CAST(DATEPART(SECOND,@dateTime) AS VARCHAR)) Don't ...Answered | 4 Replies | 797 Views | Created by aaditya2000 - Tuesday, April 26, 2016 5:48 PM | Last reply by Patrick Hurst - Tuesday, April 26, 2016 6:42 PM -
1 Votes
Erro while attempting to perform a type cast in derived column component
Hi I'm trying to perform a DataType change of a column from DataType DT_STR to (DT_UI1).Answered | 4 Replies | 3300 Views | Created by yaron2311 - Saturday, July 6, 2013 12:18 PM | Last reply by yaron2311 - Monday, July 8, 2013 5:53 PM -
0 Votes
Cast?
Performing an explicit cast differs from using the as operator in three major aspects.Answered | 2 Replies | 2470 Views | Created by MDMoura - Sunday, May 16, 2010 10:07 PM | Last reply by Liliane Teng - Tuesday, May 18, 2010 8:32 AM -
1 Votes
How to perform the cast from list to class object?
When you say "return clonedList as A" you're saying, if 'clonedList' is of type 'A' cast it to 'A' and then return it; if it's not, jut return null.Answered | 3 Replies | 1789 Views | Created by Balakumaronline - Wednesday, July 18, 2012 1:54 PM | Last reply by Reed Copsey, Jr - Wednesday, July 18, 2012 4:05 PM -
1 Votes
Difference between Casting and "as"
as operator appears to be slightly faster in v1.0 and v1.1 of Microsoft's CLR compared to casting (even in cases where there are no invalid casts which would severely lower ...Answered | 3 Replies | 3027 Views | Created by NoEgo - Wednesday, June 17, 2009 2:23 AM | Last reply by Michael Sun [MSFT] - Thursday, June 18, 2009 2:58 AM -
0 Votes
Cast
The difference is that the first statement will return a null if MyList is not an IEnumerable<Object>, whereas the second statement will throw an exception if it can't be cast.Answered | 3 Replies | 2478 Views | Created by MDMoura - Sunday, October 31, 2010 12:45 AM | Last reply by BonnieB - Sunday, October 31, 2010 1:53 PM -
3 Votes
Difference between Cast and Convert
CAST is the more ANSI-standard of the two functions, meaning that while it's more portable (i.e., a function that uses CAST can be used in other database applications more ...Answered | 2 Replies | 24791 Views | Created by Suman Sarkar - Tuesday, June 15, 2010 10:47 AM | Last reply by sekhara shiris chinta - Tuesday, June 15, 2010 11:17 AM -
2 Votes
c-style casts
C-style cast ignores accessibility of a base class.Answered | 11 Replies | 2686 Views | Created by plutnik - Thursday, December 22, 2011 10:38 AM | Last reply by David Lowndes - Friday, December 23, 2011 8:03 AM -
0 Votes
Casting to datetime2
.',':') select convert(datetime2, @str, 101)Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL ...Answered | 5 Replies | 5346 Views | Created by Zoe.Ohara - Tuesday, December 5, 2017 3:04 PM | Last reply by Zoe.Ohara - Wednesday, December 6, 2017 8:54 AM -
4 Votes
Cast again
You create the custom cast yourself.Answered | 25 Replies | 3369 Views | Created by Mean Arbez - Saturday, August 27, 2011 9:51 PM | Last reply by Louis.fr - Tuesday, September 6, 2011 10:29 AM - Items 1 to 20 of 403194 Next ›
No announcements
