Ray K (12/18/2009)

---

Good thoughts. I have to admit that the issue of injection attacks didn't even occur to me.

I remember an instance where I'd prefer the embedded code direction...

Adam Gojdas (12/18/2009)

---

GSquared (12/18/2009)

Your version will raise a priority 16 error that will abort that batch, but it will then continue to run from the next GO statement, which can...

The answer depends on a lot of things.

First, moving the code to stored procedures helps with security, because it can be used to help prevent SQL injection attacks. Those...

jcrawf02 (12/18/2009)

---

GSquared (12/18/2009)

---

Black, metalic cases, with cooling fans. Lots of little lights, but not so many as the bridge of...

Why bother denormalizing it this way? Why not just query aggregates? It looks to me like you could get rid of the VersionMaster table completely, or replace it...

Black, metalic cases, with cooling fans. Lots of little lights, but not so many as the bridge of The Enterprise.

BaldingLoopMan (12/17/2009)

---

Inner Joins:

If i'm writting production level stored procs that must be optimized then i would put everything that exist in the ON statement in the WHERE as well when...

Adam Gojdas (12/17/2009)

---

GSquared (12/17/2009)

---

I agree, but I add an additional check.

if object_id(N'[ProcName]','P') is null and object_id(N'[ProcName]') is not null

raiserror('Object name in use', 21, 1) with log;

That...

Probably people trying to solve things before they take...

Build a calendar table. Solve the problem once, then just use that to join to.

You can have "FiscalMonth" as a column in the table, along with the usual "DayOfWeek",...

I can't say that I have well-articulated architectural principles, but I do have policies that I follow. I just haven't taken the time to write very many of them...

I'd uninstall the whole package. Dev Edition comes with the same things, but with more powerful versions. Management Studio, for example, is much more limited in Express than...

The order in the Where clause won't matter, since the engine will make its own decisions on that subject.

The deciding factor on whether to put something in the Join clause...

If you can build CLR stored procedures (more secure and flexible than the sp_OA... procs), this page has one that's worked well for me for drive space:

http://weblogs.sqlteam.com/tarad/archive/2007/12/18/60435.aspx

Rebuilding indexes automatically updates the stats. Reorganizing indexes does not.

There's good data on rebuilds here http://sqlserverpedia.com/blog/sql-server-bloggers/update-statistics-before-or-after-an-index-rebuild/.