Hmmm, perhaps Fortran in early versions.

Anything since 10 I would be pretty sure is mostly C/C++, perhaps some assembler.

http://en.wikipedia.org/wiki/Sybase

Very strange. Likely some security thing.

Perhaps CTRL+F5 for the latest version of the page?

There is no offsides rule. Put a rugger up in front and he'll drag and last defender along with him.

foxjazz,

I think you probably know a lot in your area. Likely run circles around me in C#. In SQL, however, you seem ignorant. That's not a bad thing, it's...

You should create clustered indexes on all your tables. SQL Server is written to somewhat expect these. If it's a small table, pick a PK field. If it's larger, think...

Lowell, good point. We should probably limit areas to 40-50 lines tops.

Apologis, XLS updated.

I'm not as familiar with Oracle, but I do worry about having too much stuff dropped into tempdb. I'd rather have some sort of redo area per database to handle...

Brandon ,

thanks, and can you add this to the Scripts section as well? That way you can post a link and update that as we add items (or if I...

tempdb is something they'd considering (multiples per instance). For 90+% of instances it doesn't matter, but it definitely holds back scaling. Reporting Services does this and MS recognizes this is...

create regions or use auto generated ones for blocks like begin/end, batches, etc.

You've had that one, have you?

Are your partitions in separate filegroups so you can do filegroup backups?

I think if you have a scheme that allows you to recover, and you are confident in it, I'd...

Thanks for the notes. I'm logging some bugs.

- The ADDADD thing, we had that with some other keywords and cleaned them up. We missed this one.

- Blank lines, noted

-...

niall,

good point, and I can only go on my experience. I've had lots of servers that all used roughly the same 20-30% of the product. The core engine, basic T-SQL,...