Take a look at Rank, Dense_Rank, and Row_Number. Those should give you what you need.

Build cost vs use cost is an important part of determining whether to index a temp table. That's definitely true.

Most of the time, if a temp table should have...

Set them up as sequential steps in a single job.

If you need to add a delay in between, set that up as step in between.

This is going to depend on a LOT of factors.

If, for example, your business requires 24x7x365 uptime, then you will pretty much have to apply them "on the fly".

As for...

alan.paxton (11/4/2010)

---

This could be done by adding two columns to your user table. They are:

LoginCount int null

AllowedLoginCount int null

If AllowedLoginCount is greater then zero, this is how many time they...

TheSQLGuru (11/4/2010)

---

I am going to step outside the box here and ask WHY you want to put a nonclustered index on a temp table?? In almost 15 years of...

Start with sys.indexes and sys.index_columns. Read up on those, and it'll get you started.

Really though, I'd get a product like RedGate's SQL Compare or ApexSQL's Diff, which can compare...

You'd have to run it in a Windows VM. That would be easy enough to set up.

And the execution plan for that is some sort of Re-BAR?

You could easily set something like this up with a login trigger.

The problem would be getting and remembering the new password once it's issued, so the trigger would need to...

And here I thought it was called by the more formal name, "bumping into someone in the hall and asking a question about a project". I guess "swarm" does...

Yes, a case statement is another option.

I don't like to use them when a table can be used, because changing data in a table doesn't require rewriting code, but changing...

Honestly, does it matter whether...

CELKO (11/3/2010)

---

No. SQL is not an application language; it is a data retrieval and management language.

What you want is to return to the old days when data...

GilaMonster (11/3/2010)

---

Except it behaves differently in the...