Different companies are going to define that in different ways. Where I work a senior database developer will be able to design databases based on requirements, develop t-sql, troubleshoot performance,...

Is the automated job running more often than you used to run the backups manually? If so, that would explain the difference.

Logs and log backups don't have anything to do with the data file groups. If the third group is read only, then no log activity will be recorded against it....

There is no SELECT trigger. The best way is what you already have planned, collect the data through a server-side trace (which you can use Profiler to set up). Depending...

Attention to detail.

Which server are you connected to? You might want to know before you run that drop table command.

Does this UPDATE query have a WHERE clause? Be sure before...

Right, all this echoing is starting to get creepy. You can stop now.

And because I can...

10 bottles of beer on the wall, 10 bottles of beer...

Well now that's just strange. What the heck?

You may have to edit the SSIS package the import/export wizard creates.

Don't migrate the timestamp column. It will generate on it's own.

Then you can probably get what you need by querying the DMV's.

Yep. I just tried the update. It didn't seem to affect things at all. It sure sounds like the PK was not defined as the script you supplied. I can't...

I agree. First option would be to query the DMV's to see what has been run. However, if you wanted to know what was run yesterday or last week, the...

Jeffrey Williams (5/27/2009)

---

Yes, statistics are updated after rebuilding the index - on the statistics that support that index. If the index is reorganized, statistics are not updated. 😀

If...

And evidently a volunteer for the head author position. Well done.