Viewing 15 posts - 12,091 through 12,105 (of 15,381 total)
Same deal, you are changing the datatype from one to another. Again on a small dataset the performance difference is so little it doesn't make much (if any) difference. It...
May 3, 2012 at 12:43 pm
Convert has some associated overhead that will cause your query to be a little slower. How much slower will depend on how large the table is. If you have less...
May 3, 2012 at 12:13 pm
Lynn Pettis (5/3/2012)
SSC is at 1,499,895 and counting!
Wow if the same rate continues we should hit 1.5M by the end of the day today or certainly tomorrow.
May 3, 2012 at 12:05 pm
Are you looking to get a result set with each half hour block for a given day and the count of rows in your table for each block?
May 3, 2012 at 10:57 am
It is totally unclear what your question is here. You need to more clearly explain what you are trying to do. If you want help with the actual code you...
May 3, 2012 at 10:51 am
SQL Kiwi (5/3/2012)
I'm not sure The Thread actually has...
May 3, 2012 at 9:49 am
Lynn Pettis (5/3/2012)
Sean Lange (5/3/2012)
/soapbox on
We are starting to lean too far to the arrogant side with many of our replies (and yes I...
May 3, 2012 at 9:48 am
That sounds painful. Why do you need millions of rows in a DataTable? For that much data manipulation it seems like you should keep it all in SQL instead of...
May 3, 2012 at 9:04 am
Where are you viewing this that it is all on one line? If it is in SSMS and you are viewing results as grid it will not span multiple lines....
May 3, 2012 at 8:58 am
The Dixie Flatline (5/3/2012)
However, I reserve and defend the right to continue "snarking" here in The Thread. 😀
Amen to that!!! This is snark central how...
May 3, 2012 at 8:56 am
Just an observation and a friendly reminder.
/soapbox on
We are starting to lean too far to the arrogant side with many of our replies (and yes I am guilty myself sometimes)....
May 3, 2012 at 8:25 am
Even before the where clause when writing a delete or update query I write
begin transaction
rollback transaction
That way I can run the code without fear of anything going horribly wrong until...
May 3, 2012 at 8:19 am
Couldn't you use the following query to create your temp table instead of the complicated IF construct and two different temp tables?
Select l.Source_Description, a.ShKey, Sum(m.MeasureValue) as MeasureValue, s.Period_day as DateCode
into...
May 3, 2012 at 8:14 am
jerome.morris (5/2/2012)
May 3, 2012 at 8:08 am
Viewing 15 posts - 12,091 through 12,105 (of 15,381 total)