It's a task I've been given - you recommend the tsql duration trace as well?

I need to get this one metric, Index Scans down.  How do I identify what tsql is executing these scans?  Is there a way?

>>My SQL install disk is scratched, so that is not going to work.

Better call a buddy and get a disk!!

So I figured I'd try to answer some of these questions since i have an oral interview coming up in the near future and found some potential(yes, i may not...

This cursorless loop was a new trick for me, and very appreciated. 

WHILE @TableName IS NOT NULL

BEGIN

SELECT @TableName=MIN(TableName)

FROM @UserTables

WHERE TableName>@TableName

IF @TableName IS...

Currently there is no mapping going on, he is simply calling the stored proc - this seems like it should work and is some kind of permission problem. Like I...

When moving such a DTS to production will you have to perform this?

I think they like temp tables to make things easier to understand. 

But what about when he drops them at the end of the DTS?  I'm just not understanding why the proc will not run.  The tables are not being used in...

I'll just explain what the proc does, it's pretty simple.

He creates two temp tables, union all 's them into another temp table and then does a query on that table using...

I've been using the sql server 2005 implementation and maintenance training kit and a copy of sql 2005 on a home computer.  Your best bet to become a dba is...

Thanks a lot Bill. 

>>You should be doing EITHER daily or weekly or monthly full backups

I'm guessing they wanted to keep a week backup while also doing nightlys as well. We have space...

"I imagine there is some kind of tie between full backups and txn backups.  What is stopping me from making a backup in one folder doing numerous txn backups then...

Thanks for your reply Ninja,

All users are not dbo, they just have exec on certain procs.  Am I misunderstanding  this from BOL: Ownership chains only apply to SELECT, INSERT, UPDATE,...