You can create a clustered index on the UpdatedDate column. This will cause a logical ordering of the rows on disk which may, for example, be helpful if you...

That's the kind of thing that SSIS was designed for. If you insist on doing it in a single stored procedure, you can try creating linked servers, or shelling...

I've done something similar recently, although I was looking for linked server names in stored procedure and view definitions. Here is what I did. It may be more...

The question assumes that XACT_ABORT is set to OFF. I know that's the default, but it would be worth mentioning in the question or explanation for clarity and completeness.

John

Rohit

You didn't take my hint, then? Please will you post table DDL in the form of CREATE TABLE statement(s), sample data in the form of INSERT statements, expected results...

Homework? What have you tried? Hint: use GROUP BY and ORDER BY.

John

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...