Ed Klein-385786 (11/12/2008)

---

I'm just saying it would be nice. Do you have to go to that much effort to sum a numeric field? Why shouldn't accumulating text be...

Regarding the Dynamic-SQL vs Conditional-WHERE discussion there is 1 thing nobody seems to care about : security. Not in the sense of sql-injection, but in the sense of the required...

Hi Gail, another thanks for the series!

We've always used the 'rule' that every table needs a clustered index and I've never really challenged that. If the PK is lean enough,...

CornholioDBA (3/28/2011)

---

I use something similar for searching all stored procedures. I run into a problem where the full procedure doe snot fit in the syscomments field. Will this...

As for doing things this way versus via scripts & source-control : I think the idea of making sure you get all the @@IDENTITY usages this way isn't all too...

@Andy.carter 89422: although I'm not a fan of cursors at all and will always try to avoid them in favour of a SET-based solution, I sincerely think changing...

Although I agree that saving space is "a good thing" (tm), I do wonder if the full impact of this operation is considered.

As far as changing an nvarchar to a...

Although I like the idea of being creative on 'older' hardware (my (far from new) portable runs the test queries in sub-second time frames), I too think there are a...