Chris, I personally do not like storing images in the database. I prefer to store them on a separate image server and only store pointers to the images in the...

In that case, do you have an email address so I can send you my resume?

Or just upgrade to SQL 2005 where the entire procedure definition is in the information_schema.routines record or in the sys.sql_modules (replacement for syscomments) record.

There is also a new function called...

It won't always do a full column search, but the odds are a lot likelier that it will decide that a full column scan is faster than using the index,...

The clustered index affects the peformance of all indexes. Having a clustered index gives SQL Server a field that it can use to perform quick lookups of values by associating...

I ran into this issue. For me, it was caused by conflicts. Conflicts were blocking the cleanup job. I resolved the conflicts and the cleanup job finished within a few...

I query msdb.dbo.log_shipping_monitor_secondary.

I agree with Larry Briscoe above. If I wanted to create a covering index for the query provided and nothing else, then the best option was not a choice. For...

Please post the schema. I'm not going to research other potential answers until I've satisfied myself that the most obvious answer is wrong.

>> why would you need the ID's to go above 11,000 for splitting varchars?

I stand corrected. I thought the Tally value would need to be able to join to the...

Seems like a huge waste of time and effort. Not to mention what happens when the ID's reach 11001.

That makes it seem like the error is in the function. Do you get an error if you run this:

Select Element From

dbo.SplitToInt('1;2;3', ';'))

That script doesn't even have 29 lines. If you double click the error message, which line does it jump to in the query pane?

I get no errors running that code.

There is no syntax error in the code I posted. Double check to make sure you didn't type something wrong.

If you don't see anything, please post the actual code you...