That seems pretty fair. Good that they're recognizing holidays with extra pay for those working.

Thanks a lot for the kudos and praise. I appreciate it, but all of you add a lot to the site as well.

You can try dropping indexes and adding them back after the insert. That sometimes helps.

If you are adding a lot of records, it's possible that you're overloading the I/O system,...

Do you mean make a corrupt mdf on purpose?

Use a hex editor to scribble on some random part of the file.

The grammar has been corrected. Apologies for any issues.

I will also award back points for this question.

Try this: http://www.sqlservercentral.com/scripts/T-SQL/67368/

I think Jeffrey has some good advice. don't disrupt things if you don't have to.

Third vote here.

Note that moving those databases to the secondary server, either with detach/attach or just a copy over of the mdf/ldf (note that you need to stop the SQL services), does...

Typically patches will say if they are patching SSMS or EM and if they should be applied there.

that is strange, but I was thinking something simpler:

DECLARE mycursor CURSOR FOR

SELECT

m.TPH_PNT,

m.TREE_COUNT

FROM dbo.LIVE_MASTER m

JOIN dbo.UDB_PNT p ON m.PNTID = p.PNTID

JOIN dbo.UDB_CC c ON p.CCID = c.CCID

JOIN dbo.UDB_FC f ON...

Lynn,

Glad she's OK. It's slippery around here right now. We were worried when my oldest drove to Breck last night, but he made it OK.

congrats, Gus. Looks like Karma is working for you.

You would have to track updates or data changes across tables to know which ones are used the most. You could add triggers to track this, or run a trace...

It's a lot of fun, and people throw all sorts of ways. A wide variety of talent, but I enjoy just going out there with a ball. In many ways...