When truncating - Row actions are not logged. Page deallocations (which...

Actually Truncate is...

Basics type of question.

Still astounds me that sooooo many people believe that truncate is not logged. At the time I answered, 44% of respondents selected that.

Sudoku[/url]

I have seen it many times more often in a CTE than the older Derived table. I think this syntax has some usefulness when thinking through it. I...

bc_ (8/17/2011)

---

That is cool SQLRNNR.

I don't know if this would always work, but this at least works for the given puzzle to return it in 9 x 9:

SELECT TOP 9...

It is actually very similar to the construct for a cte. A CTE is in essence the new way of doing a derived table.

Break down the query like this

SELECT...

Crud - I had hoped it would since it worked for me. It is scheduled to...

It is not a common syntax, but it is listing the column names for the virtual table created by that subquery.

Here is syntax that is easier to read.

DECLARE @studentID INT...

That is a fast and easy enough way to do it.

I would suggest creating a domain group and adding users to that domain group. Then add the domain group...

Interesting. Mine displays the links between tables for those that already have FKs defined.

I'd look at doing this through a different tool. You may not want to make...

Blog post[/url] sneak peek.

Late - but maybe still worth it. I'll be posting a blog on it shortly.

It generally creates those links if the keys already exist.

Do you already have FKs defined?

I would ensure the RBS filegroup for each content database had a different name. I would also test it heavily in a dev/qa environment and ensure it works. ...