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...

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...

Gale (8/19/2011)

---

Sean,

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)...

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...

Just add more columns

select max(datalength(YourColumn)) as YourColumnLength, max(datalength(MyColumn)) as MyColumnLength from YourTable

Warren Peace (11/2/2007)

---

I got two different results. The first returned 75 and the other returned 150. I double checked it by writing a vbscript to get the count of each...

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...

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...

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??

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...

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....

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 ...

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...

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(*)...

Looking forward to it.