These are constants, no from needed.

select serverproperty( 'servername')

, spid

from sysprocesses

The same as

select 1

, spid

from sysprocesses

Please post in the appropriate forum. Moved to 2005 admin

Adam,

sorry you didn't like it. Was trying for something a little different this year.

Sorry for the delays on this one. I mistakenly didn't publish it and it wasn't ready until the am.

The Paypal note actually isn't a joke. We sold tickets last year...

you're kind of assuming that purchasing that luxury car does those things. It's debatable to what extent that happens.

Humans do many short-sighted decisions. No doubt about that. I'm just not...

CLEAR!

thump-thump

thump-thump

We're still going.

I'm not sure most people made bad choices. there are always some that made poor financial choices, but buying a larger car, or a less efficient car because you liked...

It goes both ways. It may or may not have a relation. You can't stereotype people using social networking at non-social in the real world.

There are plenty of SQL...

Our decision to buy the Prius was an economic one. Based on the costs, choices we wanted, tax credit, etc., the Prius was the best fit. We've saved a bunch...

Something happened in your i/o system and it rendered the copy-on-write a failure in the snapshot. When SQL detects an issue, it tends to just whack the snapshot. It doesn't...

Yes, we've been frivolous in the US, yes we've wasted efforts. However I'm not sure that we all have just wanted SUVs. If you look back, there have been trends,...

You need to trace this and find out which activity is growing tempdb. There is no other way, live server or not. Activity, and possibly large transactions using temp tables/variables,...

It's not either or. Some of my social networking friendships have brought me closer to people that I see once or twice a year at an event. There's definitely a...

you could go to disk in v6.5, did it for years. Never to tape directly since that was slow, and error prone.

Devices are there precisely to have the same script/code...

I think SSC is kind of a social network!

A few things to keep in mind here. I'm experimenting a bit with Social Networking and I think it's like certifications. You...

Everyone can be harassed, and everyone deserves protections.

Minorities might be harassed more, or might not be, however many feel they have received more discrimination. That's something different.