Viewing 15 posts - 14,206 through 14,220 (of 15,381 total)
Try removing your third really complex piece and see if the performance improves greatly. If so, then you may need to rewrite your query. If not, then that is not...
August 19, 2011 at 12:56 pm
I write asp.net all day everyday and it is super fast. Once I have stuff ready to deploy I have not been able to get much noticeable difference in page...
August 19, 2011 at 12:23 pm
Gale (8/19/2011)
Thanks.
Is there some way of just referencing the filename and having the Max(len(
done on every field within the filename.
We're forced to upload everything as varchar(255)...
August 19, 2011 at 9:29 am
There may be some formal training or books but nothing will give you better actual knowledge than getting your hands dirty. I am guessing you picked up way more knowledge...
August 19, 2011 at 9:18 am
Gale (8/19/2011)
How can this be done for every field in a table (at once)?g
select max(datalength(YourColumn)) from YourTable
Just add more columns
select max(datalength(YourColumn)) as YourColumnLength, max(datalength(MyColumn)) as MyColumnLength from YourTable
August 19, 2011 at 9:06 am
Warren Peace (11/2/2007)
August 19, 2011 at 9:05 am
Here is my version from several years ago...warning this type of searching is PAINFULLY SLOW!!!!!!!! I would strongly recommend not running this type of sql during normal business hours. Yours...
August 19, 2011 at 9:02 am
If what you are trying to do is delete all the data and reset the identity you can do without dropping your foreign keys. As you have discovered you can't...
August 19, 2011 at 8:44 am
What kind of performance gains have you seen? I bet with all the great stuff Chris put out there this thing is running a LOT faster??
August 19, 2011 at 8:11 am
Looking good. One last suggestion. There is still the CONVERT(VARCHAR(16), '') Nitpicky I know but every little ounce of performance you can pick up from low hanging fruit is worth...
August 19, 2011 at 8:08 am
Read the SQL Stairways[/url] article about indexes. This topic is entirely too big to say the best practices are "..."
There have been mountains of books of written on the topic....
August 19, 2011 at 8:00 am
Glad you solved your issue but you could use a nested replace instead of a scalar function in this case to produce the same results.
declare @MyVal varchar(50) = 'Here ...
August 18, 2011 at 3:35 pm
Looks like you got a nice solution (and one you can understand). Thanks for posting your final result. I am sure somebody along the way will appreciate it. And thanks...
August 18, 2011 at 2:50 pm
You could also just multiply one of the count(*) * 1.0
That would implicitly change resulting datatype without having to cast either side.
--this will return 0
select
(
select COUNT(*) from sysobjects
)
/
(
select COUNT(*)...
August 18, 2011 at 2:46 pm
Viewing 15 posts - 14,206 through 14,220 (of 15,381 total)