codevault33 (4/29/2008)

---

Hi, I'm in a similiar situation, you asked about the quantity of data that the other systems may generate to warrant having their own database, well in my database...

No, it's an implicit commit. I just got the same results. I ran this query against Adventureworks:

SELECT soh.[SalesOrderID]

,sod.[SalesOrderDetailID]

FROM Sales.[SalesOrderHeader]...

It is a small world. I was on SSN606, Tinosa (a pile of glowing razor blades now). I was nuclear power machinist mate. In other words I used a slightly...

It sure beats working on a nuclear powered submarine in terms of pay, benefits, hours, cleanliness... Yeah, I'd say it's still a good career.

I'd have to see the procedure to understand why you're getting a difference. But I think, and I could be wrong about this, the batch includes the commit, but the...

To give you a specific answer you need to post specific information, the two tables & some sample data. See here: http://www.sqlservercentral.com/articles/Best+Practices/61537/

In general, you shouldn't have to do cursors or...

To give you a specific answer, sample structures and data and code are necessary. To give you a general answer, take a look at the execution plans for the queries...

A statement is a single piece of work, whereas a batch is a whole set of work.

So, for example:

DECLARE @Id INT;

SET @ID = 52;

SELECT *

FROM dbo.MyTable

WHERE Id = @Id;

That...

I posted the same question at Connect. One of the MS reps gave me a good response.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=244214

I've been burned way too many times by poor use of functions to be any kind of advocate for them. However, if you really want to drill down on them,...

The queries work well when the data is loaded, but don't work when the tables are empty? I think the previous post may be right, the execution plans are still...

Doggone it! I was getting excited that I might be able to tell you something rather than ask you something.

😛

As to your initial question, it's two schema's in one database, not two databases.

As to your further explanation that you'll be bringing other applications online. As the other applications come...

Any performance degredation is not linear. Depending on how you're working with the system, there may be very little degredation at all. In the instances within the article, we were...

Personally, I would have two schema's within the same database. This will allow you to lock down one schema, but have referential integrity between the schemas where as you would...