I agree with Andrew. Maybe full-text search would be a better fit for your situation?

Deciding on being a production DBA or development DBA will probably depend on your personal preference and what type of person you are. Yes they both have simmilar responsibilities...

If you're asking us if these are good interview questions to ask someone you're going to hire, I'd suggest some rewording and re-ordering:

1. How many processors can a SQL Server...

Are you saying that having the instance service account access files is a breach...

SQL Server Express can only be a subscriber, not a publisher or distributor. If you need this, you'd have to build your own method of copying the data from...

Probably a better explanation of it than I could give is in this article:

http://www.sqlservercentral.com/articles/TSQL/62867/

You could set up your tally table in a couple of different ways, but if possible I'd...

once the DLL is in the \Binn directory, this statement esentially creates the interface between T-SQL and the...

Have you ever worked with a tally table before? I think using that, and left outer joining to a subquery where you count the activities per day. To...

Was this xp_varbintohexstr an extended stored procedure? You may need to copy the DLL into your 2005 MSSQL\Binn directory and re-register each procedure in that DLL using sp_addextendedproc.

That will depend if they want to allow multiple rows with NULL for itm for the same...

OK, sorry for the confusion, I didn't realize you wouldn't know the desired pivoting values. I can think of two options offhand, either use ROW_NUMBER() to force the pivoting...

Another contributing factor will be if the web server is on a different physical computer from the database server. If they are, you probably don't want all of that...

Personally, I'd suggest learning how to use CASE statements or PIVOT to do this instead of using that stored procedure. A good article is at:

http://www.sqlservercentral.com/articles/T-SQL/63681/

Trying out the stored procedure...

I thought the only thing that prevented a KILL from working was if the session was calling an extended stored procedure, was the same session that issued the KILL, or...

OK, maybe this is a silly question, but in your subquery:

SELECT ali.ItemValue

FROM AttributeValues as av

INNER JOIN AttributeListItem as ali

...