SQLJocky (8/9/2012)

---

I'm trying to figure out why this log file won't shrink down past a certain size. I'm doing it on a brand new database I'm creating and nothing...

Have you done this yet? If so, what are the results?

And it gets worse if the views your are joining together are based on views joined together.

You can imaging how this can expand to views joining views, joining views...

HowardW (8/9/2012)

---

Lynn Pettis (8/9/2012)

---

That's where you build a database agnostic DAL and your actual database layer is written to support the RDBMS of choice. To provide a system that...

Looking at the execution plan, group by version looks simplier, 4 operators versus 6. The table scan and sort have the same cost associated in both.

CELKO (8/9/2012)

---

You also need to start using the ANSI Standard row constructor syntax instead of the old Sybase 1970's stuff you had:

INSERT INTO QA_Tests

VALUES (123, '001', 4),

(123, '002', 4),...

SQLRNNR (8/9/2012)

---

Lynn Pettis (8/9/2012)

---

SQLRNNR (8/9/2012)

---

Lynn Pettis (8/9/2012)

---

< rant on >

Here we go again. Let's berate an OP because of things he/she may not even have any control over. ...

SQLRNNR (8/9/2012)

---

Lynn Pettis (8/9/2012)

---

< rant on >

Here we go again. Let's berate an OP because of things he/she may not even have any control over. I will agree...

That's where you build a database agnostic DAL and your actual database layer is written to support the RDBMS of choice. To provide a system that performs well on...

Yes. It has everything that the Enterprise Edition has, just that its license is restricted to development/testing.

It has one drawback to be aware of when developing solutions. If...

Curious, which is the more scalable solution?

DECLARE @persons TABLE(

personid INT,

version INT);

INSERT @persons

VALUES(1,1),(1,2),(1,3),(2,1),(2,2),(3,1),(4,1),(4,2);

SELECT

personid,

maxversion = MAX(version)

FROM

@persons

GROUP BY personid

ORDER BY personid;

WITH BaseData AS (

SELECT

personid,

version,

...

< rant on >

Here we go again. Let's berate an OP because of things he/she may not even have any control over. I will agree that the OP...

To start, you will need to run a RESTORE HEADERONLY against the file to determine which file to restore.

Here is the entry in Books Online that should help you with...

MysteryJimbo (8/9/2012)

---

Lynn Pettis (8/9/2012)

---

First, you shouldn't use SET ROWCOUNT to control the number of rows affected by your DELETE statement. This functionality has been depreciated and may be removed...

Sean Lange (8/9/2012)

---

So we mentioned the deprecated code but you are still using the "old style" error handling by checking @@ERROR. You should use the newer try-catch construct instead. It...