SDB15 (9/27/2011)

---

These are just a couple rules of thumb that has been useful in my experience. As you said, CTEs, temp tables and table variables all have their uses.

The...

That's interesting. I am seeing similar behavior, but the results are being returned according the active setting, not by what's reported in the execution plan.

Have you tried running the command outside the maintenance plan? You might get a better error message.

HowardW (9/27/2011)

---

SDB15 (9/27/2011)

---

Use CTEs with care, if the expected row count is very high, you're actually better off with a temp table. I've also read that CTEs have a hard...

It would be easier to help if you posted the Audit definition.

You can often get the same data using a CTE or derived table. Something like this:

CTE:

;WITH ItemCount AS

(

...

You really should see which tables really need an OUTER JOIN and only use the OUTER JOIN in those cases. Also you mention SELECT sub-queries, you don't mean that...

You would need to loop over the rows in the table and execute sp_addlinkedserver for each one.

Since I haven't done those activities in many years I can't relate anymore....

Stefan Krzywicki (9/26/2011)

---

Jack Corbett (9/26/2011)

---

So where is everybody? No messages over the weekend and only 2 today?

I know the Summit isn't for a few more weeks so that can't...

I probably would have gone with the trigger as well, but that's mainly because I don't like having to go outside the table definition to see what a check constraint...

So where is everybody? No messages over the weekend and only 2 today?

I know the Summit isn't for a few more weeks so that can't be the reason. ...

@RDBMS (9/24/2011)

---

A table has dates stored as nVarChar in the format: dd/mm/yyyy. I have added a new DateTime column and want to store the nVarChar dates into this column for...

I believe you either need to use the FOR XML syntax in T-SQL or you can use a SCRIPT TASK in the control flow or a SCRIPT COMPONENT in the...

Jim Murphy (9/22/2011)

---

Say, anyone here know how to admin Sharepoint? Things like changing permissions to the calendar and stuff like that?

People are asking me but I don't have a...