James Dingle-651585 (5/24/2010)

---

It is difficult to demonstrate for me now because I am not at the office, the computer I use now does not have SQL... sorry if I take...

James Dingle-651585 (5/24/2010)

---

Hi Jon,

Quick remarks:

- There is a clustered index scan on the ID. Obviously, this way it won't work. The snippet of code I've wrote was assuming...

And just one more before anyone else suggests it:

-- Query 10

SELECT *

FROM [Product]

WHERE NOT([Name] <> @Name AND @Name IS NOT NULL)

the where clause above is actually...

James Dingle,

In fact your query preforms nearly twice as badly as the original non-dynamic SQL that would have been in the initial stored procedure.

See SQL and execution plan below.

DECLARE @Name...

James Dingle,

I've tried your style of query to obtain the execution plan and it is the worst performing out of all the attempts so far.

Please find details below. I created...

I thought I'd better put some tests in after all the discussion.

Create some test data:

IF OBJECT_ID('Product','U') IS NOT NULL

DROP TABLE [Product]

IF OBJECT_ID('Colors','U') IS NOT NULL

...

chris.shaw (5/21/2010)

---

Jonathan,

I must say that I found your article to have some really good information in it. I guess there was only a couple comments to it...

Gursoy Yerli (5/11/2010)

---

Fixed a bug;

Your generation sproc was ignoring the schema when using "EXEC sp_helptext @ProcedureName". Added below to fix the issue.

...

You can't update two tables in one SQL statement but you can wrap them in an transaction so from the outside it looks like they are.

BEGIN TRANSACTION

UPDATE A

SET Complete =...

I've written this trigger to record when DDL changes...

Grant Fritchey (5/7/2010)

---

Also, we make it a point of retaining the scripts that were generated for the final rollout to production, in case there's any question in the future what...

bill page-320204 (5/6/2010)

---

Am I missing something here?

We use SourceSafe. We keep each proc separate. When I need to change one, I check it out, modify it, paste it...

I didn't...

In the version of the procedure I have adds and additional call to another...

bphipps-931675 (5/6/2010)

---

True about the walking in late, for that issue but I would still want to logically arrange the various scripts into projects to make them easier to find and...