Mike C (7/1/2010)

---

One note on your update--be careful when using this syntax:

UPDATE t

SET ...

FROM table t

INNER JOIN table2 t2

ON ...

This syntax lends itself to parallelism and can result in unpredictable...

Mike C (7/1/2010)

---

One note on your update--be careful when using this syntax:

UPDATE t

SET ...

FROM table t

INNER JOIN table2 t2

ON ...

This syntax lends itself to parallelism and can result in unpredictable...

I thought TDE was in the Developer edition as well, which is...

Nice question, thanks! (I had to think a little since I don't use TRIGGERs much.)

A few things I noticed about Mike C's code:

* Since he is using CTEs it will only run on SQL Server 2005 and up.

* His week number is the week...

MutlyP,

What version of SQL Server are you using? (If you are using 2008 the second procedure can be written a little different.)

In your second example looking at the first portion...

I'll take the first one as it is simple. 🙂

In this case it looks...

badatthis: Yes, that issue has been brought up more than once. And I think it goes further than that, even with a PK/clustered index you aren't guaranteed a sort order...

Sadowy,

I think it is very common for the questions/answers to be corrected/edited between when they are email and when you may get to the web site. Being on the west...

mutlyp (6/29/2010)But I do see your logic for this case but like I said there are a lot more data that I must modify, compare and then take actions all...

Nice question thanks!

I'm sure the idea is that the series of articles will start with the...

This is a good article thanks!

I was going to mention that using GROUP BY instead of DISTINCT/ROW_NUMBER might be a good way to solve this, but I see someone has...

Nice question, thanks!

I think little bits like this will help people learn and understand new features like TDE so they are better prepared when they actually need to use it.

Great article, thanks!

Now if we just had the Enterprise version on all the servers...