I have a question on that: is it better to have a clustered index on a high selectivity value like a date field where you might have 1000+ rows...

Have you looked at the activity monitor? What kind of waits are you seeing? It could be something related to hardware or database configuration slowing you down (CXPACKET or PAGEIOLATCH...

Have you tried writing a procedure that creates the database, then the objects within it, and then call that procedure from your app?

Running profiler really hasn't shown me anything. It just shows that its the SQL Agent running it from the server itself.

Well, you could use:

kill spid with statusonly

spid = the spid you killed in the first place.

NOTE: This is bound to take several hours to rollback because of the operation you are doing and how much time you are into it already.

After looking at sp_who2 and...

Same problem here. SQLDMO_ running "dbcc checkcatalog WITH NO_INFOMSGS" on every single database and making backups to virtual devices that we don't use. Source is the database server itself.

What do the updates you're performing look like? How many records, usually?

Hi

I have a headcount report that look like so:

Permanent Temp Contractors Payroll - Vacancies Non-Payroll Vac Total

Marketing 10 4 3 17 10 44

Accounting 3 2 1 6 2 14

HR...

Yeah, thanks G². Also, love the quote!

You can run the following:

The fields you use cannot be nullable, so you may have to use:

alter table test alter column...

We were talking about CXPACKETS and MaxDop on this post , as well. Might want to check it out. I've wrestled my CXPACKETS down from being a major problem to...

How about this:

I have run into this problem before, too. What I found that was a record was deleted by someone on the subscriber side. Transactional replication goes from publisher to subscriber,...

IMHO The simplest would be the osql. It has parameters for an output file. If you have the output of your procedure to be what it is you want logged,...