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

Or try this

SELECT i, newid(), rand()

FROM (SELECT 1 i UNION ALL

SELECT 2 UNION ALL

SELECT 3 UNION ALL

SELECT 4 UNION ALL

SELECT 5) derived

order by newid()

to see...

It's possible you had some problem with the backup. I'd rerun it and include the verify check (see RESTORE VERIFYONLY in BOL).

If this doesn't work, be sure you run a...

What's the instance name? Are you sure it's being typed correctly? Check it in the services applet.