sp_databases gives you the size of the physical files for each db (data + logfiles)

If you also want to know how much space is actually used inside those files, you...

My guess would be that it could mean 'read only', 'not changeable' or some other word that is a synonym for 'static'.

Do you have a context for the 'server is...

..in order to keep us 'strayed' then...

Yes, some functions would be very well suited as CLR implementations, the 'recommended kind' is those where...

CTRL+R is actually in 2k QA also. It toggles the resultpane on and off, so it's almost the same thing as CTRL+B (not quite, but almost)

A 'proper' median function native to T-SQL is still on the to-do list.

(There is one in MDX, however)

Ofc you can 'hack' your own, but that isn't SQL per definition.

As I...

In all honesty I have mostly just seen demos and presentations on it.

(It's disabled by default on new installations)

It depends on what 'extend'...

Gaddamn this %"&¤) timeout thingy 

I'll make it shorter then...

About the CLR and procs - yes they are called the same thing, and work the...

Even 'worse' - you can code T-SQL stuff inside the CLR - which now gives the 'enemy' (devs <g&gt the tools to do the...

It's kinda har to say (up_OARaiserror looks like something custom made) other than xp_sendmail is generally a royal PITA to get working. From when I used to use it, I...

Well, the question was about where NOT to use a procedure, and the CLR would then qualify, don't you think?

(this notion is in...

You're still thinking backwards.

You don't want to 'capture' the server state in order to decide when to make your backup, you want to decide and plan for your backups at...

I too believe in the 'it depends' variant - the question is too generic to be answered absolute.

(..there's not that many absolutes in this business anyway)

Damn this stupid interface that suddenly throws away a post instead of posting it...

Oh, well.. Here goes again then...

Well, that was sort of...

You need to be careful about this, since it doesn't work in a predictable way.

It used to (I think anyway), but it doesn't anymore. I thought it used to in...

That is true.

It's pretty common that one view will perform ok, and the other view also, but when you start piggybacking views on top of eachother really bad performance may...