The use statement that you specified is not going to ever help. The OSQL command executes in its own context, and will go to the default database for whatever...

If you stop and start SQL I can almost guarantee your database will be corrupted. Been there done that. You will just have to wait or it to...

The only way to make agent do that is to do it with a job with multiple steps. But not anything that says the job A and B have...

207ms over 100K records hardly seems worth it.. Good to know though..

CEWII

Jean-Sebastien Carle (8/31/2009)

---

I only used static text to calculate the int variation as a demonstration and for testing in previous posts of this thread. In a real world environment, I...

If its an identity it can be missed by a rolled back transaction. If a transaction is begun, a record is written to the log, and then the transction...

I know I do, I'm always trying to learn something new. And even as much as I post solutions to other people's questions, I still get a lot out...

Jeff Moden (8/29/2009)

---

heh... understood... I just don't want developers to use a tool just because it's there... I want them to use it for all the right reasons as I...

I look forward to hearing how it went. I would love to see if others have any other or better approaches..

CEWII

1. Could be network, are there any reports available on utilization at those times that its gets sketchy?

2. On the SQL Server did you set priority boost? If so...

For single instances I'm thinking that doing it with the conversion involves very little impact on performance. I'm not disputing that this works. I did a really quick...

I'm not sure about "better", but when times CAN come into play we need to be aware of the dates we choose. As far as taking 3ms off, I...

Ok, I can see that.

Then choose a location and write a file to that location. Your DLL can just read it, don't require it to be passed in. ...

Actually I do..

1. Both SQL servers cannot be running, only one.

2. Changing the ip address on the one can make it difficult to get the other one working again because...

DNS isn't so much routing as resolution.. If prod ip address is 192.168.1.100 and the DR server's ip address is 192.168.2.50. You would configure DNS for some arbitrary...