Try updating every row in your largest table. Rinse and repeat until your transaction log is full.

John

Nice one. You could also query one of the system views, for example sys.master_files, to build your list of databases at runtime. That way, you know that the...

Make sure that the user's default schema is dbo or whatever other schema you want the views to be created in. Or ask him/her always to specify the schema...

I'm not sure what that second bullet point means. Perhaps it's advising you to create the clustered index first and all non-clustered indexes afterwards. As for whether to...

Sean Lange (9/30/2014)

---

It doesn't actually matter what order the results are, the question didn't ask anything about what order they are in. It asked how many distinct values would be...

Please post full table DDL, the SELECT statement that's running slowly, and the actual execution plan for the query.

John

Tom Bakerman (9/24/2014)

---

Now I'm really confused.

I'm testing this out in BIDS, right? Watch the appropriate boxes turning green. Start, then Task B, then LRT. Then BIDS says...

Tom

I'm surprised that matters... the precedence constraint is set to Success OR an expression evaluating to True, so the fact that the expression evaluates to True should be sufficient. ...

Are you saying you've got a nullable column, but you don't want to store any NULLs in it, or are you saying you've got a nullable column that does have...

Are the client tools on your PC of a more recent version than your server? Sounds like you may have upgraded your package when you edited it, and now...

Yes, or if you're feeling brave, you could change the DatabaseBackup stored procedure to include the logic in there.

John

Tom

I think you need to change the precedence constraint between C and D so that it evaluates to True on Success OR if @Variable = True (where @Variable is the...

Well, I did say something like that! Just change the ASC to DESC - that should fix it.

John

Second one looks OK. Something like this for the first:

WITH RowNos AS ( -- order within groups in descending date order

SELECT ROW_NUMBER() OVER (PARTITION BY grp ORDER BY dt...

I can't think of any way you could change the owner and carry on with log shipping afterwards. The database will always have to have the same owner as...