Thanks again.  I got a little more info on this Dell Powervault.  I shouldn't have referred to it as a NAS.  I'm still trying to determine if it is included...

Thanks for the responses.  The SAN is "leased" space and our company would like to get off of that entirely down the road for cost reasons.  At that point we...

Thanks Steve, that answer is the most helpful I've seen.  The only log backup that is near the 9 Gig size of our log ( ldf ) file is the...

I understand that normally you should let your database activity determine the size of your log file ( assuming regular backups are happening ), rather than manually shrinking it's size...

Thanks for your quick responses.   Yes, the regular log backups truncate the log, but don't shrink its size on disk.  Our database has a data file of about 11 gigabytes...

Adding a user to the Server level Database Creator role, plus db_backupoperator role on each database, plus the TargetServersRole in MSDB helped somewhat but still doesn't give the user full...

Since I'm not getting any responses here, let me rephrase.  Do you have to be a system administrator to set up Database Maintenance Plans and query system tables such as ...

Sorry I didn't make myself clear.  I'm talking about data access via asp.net pages.  The controversy is whether to have the sql generated in the application code  ( e.g. C#...

The more I think about this the more it boils down to results.  What we need to hear are real-life experiences with both approaches, particularly with large numbers of records...

Thanks for all the great input.  I already believe in stored procs -- not sure now how to reverse over a year of development which doesn't use them. 

Since this...

The method by which the "adhoc" or dynamic queries are created is a black box object in C#.  Somehow, based upon the user input from the browser, queries with parameters...

Thanks for the feedback.  Now that this new product has loaded the first of 300+ clients' data, it may be difficult or impossible to get the devel team to switch...

This is the sort of adhoc query I'm seeing in profiler: application name is:.Net SqlClient Data Provider ( again, no stored procedures in use at all )

1. exec sp_executesql N'SELECT...

Seems to me it's just a question of knowing the business rules and testing first. If you know exactly which fields and tables need to be updated/inserted, and test...