Wow, there's a lot going on there, the first thing I did was eliminate thee first 3 derived tables (the select *'s without any where clauses).

There isn't anything that...

What do you mean by more functionality? The DBEngine isn't going to do more because you are using the full-blown management tools. If that happened, then there would...

Grant Fritchey (1/19/2009)

---

What? Did the copy editors fall down on the job again. Steve, fire that mangy lot and get someone decent in here to...

Can you post the query please?

You have asked for specific answers to general questions. Please see the links in my signature.

Based on what I have read in BOL, you need to have an explicit COMMIT TRANSACTION.

A user can set a savepoint, or marker, within a transaction. The savepoint defines a...

Since it is MSDE I don't believe you need any CAL's to connect to the SQL Server.

I don't have 2000 installed currently, but you can change the timeout settings in Tools -> Options.

If you are using SSIS then the lookup component is the current method to do this. If the databases are on the same server you could get better performance...

mamsay (1/18/2009)

---

hi cozyroc,

writting data into excel sheet doesn't work.. so now i changed my proceedings.. it is throwing many errors.. i think writing the excel sheet through scheduling is not...

Definitely try to solve this with a set-based solution. Cursoring through 200,000 rows will kill the server. If you post your DDL and some sample data (see the...

Here's a good blog post about people just implementing solutions form the internet or forums without caring why:

http://www.straightpathsql.com/blog/2009/1/18/empirical-evidence.html

I found this on a tweet by Jonathan Kehayias.

So it can be done, but don't miss this line:

Who knows how good it will be? I have a basic outline of the "series" it is based on a Profiler presentation I did at the Orlando User Group...

I've got a series on Profiler/Trace in process, building from real basic to a little more advanced (server-side traces, etc...). I was waiting on getting a new laptop, done,...