Pretty much!

That works, but it has all of the problems of dynamic SQL.

Another minor point is, it should use scope_identity, instead of @@identity. @@Identity has problems with things like triggers.

The row_number function puts a row number on the data. By using the "partition by" part, I make it so the number resets to 1 for each set of...

kenambrose (6/5/2008)

---

In my opinion, the definition you quote is certainly not the common interpretation of the term and definitely represents a "dumbing down" of the generally accepted interpretation.

...

Okay. I tested it in procs, and got basically the same results you did. The named index, separately created, took 2453, the unique constraint took 453, and the...

kenambrose (6/5/2008)

---

Personally I think it is simply a self-serving fraud for software developers to call themselves engineers.

There is neither the scientific basis for the analysis, design, construction, and...

Mohamed (6/5/2008)

---

Good question, does a good job of testing knowledge about BETWEEN,

but bad english.

I think the questioner needs to know the difference between 'consistent' and 'same as'.

Consistent means same...

I think RedGate has a product for that kind of thing. Might check it out.

I haven't run into that one. My first guess would be a rights issue.

I suggest joining it to sys.dm_exec_sessions. Those two should give you what you need, I think.

The main thing is back up all your databases. Other than that, I just installed it, with no major lead-in.

Per Books Online, there is no data in that view for a given index till something is done to the index that would increment one of the counters.

If you change...

Generally, yes. They can be unistalled from the appropriate part of Control Panel. If not listed there, then no.

I highly recommend not bothering to format the data in SQL. Leave formatting to the presentation layer (front-end application). They're better at it, and can more easily have...

I think you're misunderstanding me. I'm saying DON'T set it up the way you're setting it up. INSTEAD, set it up as a job, with the BAT file...