Welcome to the forums. Keep your hands and feet inside the vehicle at all times.

Performance wise, you have to reference two tables right now. Plus the fact that you can...

Yeah, OSQL will work fine. It's still back to what I said. Open a new connection, either by spawning a thread or using another executable, one you built or one...

I'm not adverse to using it, but I've only seen string parsing or complex math solutions that were clearly more viable with the CLR than with TSQL code. Get me...

I still think it all comes down to a business verification. I can't tell you how many times I've gotten the word to restore the backup for a certain date....

You should have Profiler. You can capture that.

You can also run Perfmon to capture the counters over time. Output them to a file and then you can use those with...

There's always the documentation:

http://msdn2.microsoft.com/en-us/library/ms130214.aspx

It's called SQL Server Agent and it runs as a seperate service on all server installs (it's not in Express or Compact).

Do these transactions include lots of data changes? You might be getting recompiles on your procedures. You'll need to follow Gail's advice and get the wait stats.

And you will need to show execution plans so that bottlenecks can be identified.

The wizard should work. You can also select all your procedures in the Object Explorer Detail window by first clicking on the Procedures folder in the Object Explorer window. In...

Can't you simply open another connection to the database and fire the procedure asynchronously? That way it won't be part of the main application's execution path.

It's also worth pointing out that the ANSI 92 joins will cause problems in SQL Server 2005 and above when doing outer joins. From BOL: The outer join operators (*=...

dfalso (5/9/2008)

---

I don't think you're quite understanding my point (and I apologize if I'm not making myself clear enough). I'm not saying that I don't know how to use set-based...

Jane Matheson (5/9/2008)

---

I've thought about writing and even saved information I was working on for topics that I thought would be interesting. Why haven't I actually submitted an article?...

22?

Oh lordy, I knew you were wet behind the ears, but I had no idea. I could be your father... Oh, yuck. No offense, just lamenting my lost youth.

Anyway,...