I agree with lots of what Andy wrote, but I'll chime in as well.

SQLInjection will become one of our biggest worries going forward. With so many bugs and patches coming...

Thanks for the link catch. It's fixed.

You can use either with the IIS server connecting to the SQL Server. Not sure about the actual end user, but I suppose if they connect to IIS using Windows...

do you mean dbcc indexdefrag? Access can grab a large number of locks and I suspect, block the index defrag from running. DBCC inputbuffer returns the last sql batch (or...

Pls don't cross post. Answered in the other thread.

I always use aliases. You learn the pretty quick and as long as you are consistent, it's easy for your team to read. If the Products table is always...

Finally one question that people like

Haven't run through it all, but I wouldn't depend on the dbid. I'd use the names you want to exclude. I might also insert the results into some log...

I'm always wary or writing directly to tape. It seems a much less stable mechanism for restores. I personally haven't used this product, but I have used Backup Exec and...

Not really. Very minor memory usage, if they aren't queried, then no data cache will be eaten up. I wouldn't worry about them.

This shows fragmentation, which can slow access to the table, but it doesn't appear to be too fragmented. It is, however, a large table, so most likely indexing better can...

I'm not the replication expert, but I had a similar situation years ago in v6.5. I used a trigger to move the inserts and updates to a separate table. Then...

You might be able to, but it would be ugly and might cause performance issues. I'd create a couple views to filter things out.

like create view myfirst as select *...

Search in syscomments. A simple query

select * from syscomments where text like '%mystring%'

will get it for you. Surfinity also makes a great search engine for searching, but I'm not sure...

http://www.sqlservercentral.com/columnists/sjones/batching.asp