I've updated the code so that it will include both FileGroups and any INCLUDE columns.

Also made it a stored procedure with the option to include existance test and DROP before...

sknox (10/27/2009)

---

jacroberts (10/27/2009)

---

I can see that you can do this using SQL server but I fail to see any benefit to using SQL Server rather than wirting some code using...

I can see that you can do this using SQL server but I fail to see any benefit to using SQL Server rather than writing some code using a normal...

---

11. More WHERE clause hints - Avoid unnecessary conditions in the WHERE Clause. Also try to avoid a function in the WHERE clause as it presents SQL engine to do...

---

10. WHERE clauses - In a WHERE clause, the various operators used directly affect how fast a query can run. Here are the conditional operators used in the WHERE clause,...

Thought I'd get in with the first comment, only a spelling mistake that gets through a spell checker:

Update: I would recommend you to use SET NOCOUNT ON for the shake...

GSquared (8/13/2009)

---

jacroberts (8/13/2009)

---

GilaMonster (8/13/2009)

---

Plus who decides what's right? The last editor? What happens if someone comes along a couple months after an article's been published and edits garbage in. It...

Andy DBA (8/13/2009)

---

John te Lintelo (8/11/2009)

---

Andy DBA (8/10/2009)

---

So my question is: Does anyone have strong recommendations (other than readability:-D) regarding LEFT JOIN versus either of the other two? Are...

GilaMonster (8/13/2009)

---

Plus who decides what's right? The last editor? What happens if someone comes along a couple months after an article's been published and edits garbage in. It may go...

If the the site implemented Wiki, users could go in and correct any errors on the articles?

That way the site could host a set of excellent, up to date, well...

Kit G (8/11/2009)

---

jacroberts (8/11/2009)

---

I feel that's fine as a policy but there is no warning of this within the articles, they can look like they've been reviewed and properly published...

I feel that's fine as a policy but there is no warning of this within the articles, they can look like they've been reviewed and properly published when as no...

Lynn Pettis (8/10/2009)

---

LP (8/10/2009)

---

Absolutely agreed. Very dangerous article espesially for...

Lynn Pettis (8/10/2009)

---

Tim Walker (8/10/2009)

---

Lynn Pettis (8/10/2009)

---

oli (8/10/2009)

---

Paul White (8/10/2009)

---

I deeply begrudge the minimum one star.

Gail's first post expresses it best, and in milder language terms than I might have...

GilaMonster (8/10/2009)

---

rja.carnegie (8/10/2009)

---

... because it's no longer the case that your use of the command has to be considered as possibly "SELECT column FROM gregory.table" and mine is "SELECT column...