Ann,

That's the idea, except that you have to switch the app users to the secondary server. Either they connect to a new name, or you rename the server. The...

Outback,

Thanks for the reference, that's good information.

Rudy,

Do you know how fragmented things are when 1.4 has worked? Slightly? Severely? I've seen this questions before and it would be...

Phillip,

Apologies for that and I'm not sure what it is either. I know since I've switched to FireFox it doesn't happen to me, but I suspect there'e something in the...

The reference basically is for how a child process may relate to a parent process. If you wish to spawn another process, but it runs within the memory space and...

Ha,

select 1 'rank', 'Steve', max(bigint)

union

select 2 'rank', user, count(posts)

from forum

group by posts

How's that?

Please post these questions in the appropriate forum. This one is for the Question of the Day.

Please post this in the appropriate forum. this is for the Question of the Day.

I investigated Object databases a few years back and they were interesting. I think NASDAQ or the Chicago Commodity board had used one with great success. The idea seems to...

http://www.sqlservercentral.com/columnists/sjones/tamestrings1.asp

http://www.sqlservercentral.com/columnists/sjones/20010424135929_1.asp

Rarely. Usually only for patches. The SQL ServerCentral.com database has been rebooted once this year for a Windows patch application. Other than that, it's been up since September when we...

Ahhhhhhhhhhh :0

Managers and Access. Keep them away!!!!!

A select count(*) from x where date >= date1 and date <= date2 should work, are you just wanting the number of rows?

http://www.sqlservercentral.com/scripts/contributions/26.asp

This usually works for me.

A proc will not directly take a stream as an import mechanism. It will take text and you'd need to somehow get your file loaded into memory and then pass...

We've got some stuff in the Sept magazine on various scale and HA issues coming. Might answer some questions.

As far as scale goes, I can point to two places...