In particular, the Smart Array 6400 Controller DOES have a battery-backed cache.  It will write the data to drives even after a system failure occurs, as long as the disks aren't...

It seems to me that this sort of thing could eventually lead to the downfall of time shifting.  (Tivo, et al) If the networks can show that time-shifting by the...

This should be fun.  I'll get the popcorn.

You might want to look at the title "owner of database object" in the BOL.  You could create tables and other objects that have different meanings to different users in...

Ian,

My understanding is that the ability to perform log backups during a full backup is intended to "cover the gap" that exists in SQL 2000 v point-in-time restore.  This, according...

"In Microsoft SQL Server 2005, you can back up the log while a data or differential backup is running. "

http://msdn2.microsoft.com/en-us/library/ms190217.aspx

jg

Precisely.  Brainwashing the neophytes is probably not the most ethical of approaches.

Active Directory and Exchange server are based on Access (well, JET).   SQL Express certainly is not. 

But then, it is...

Steve,

It is not surprising to find the ever-geekening masses lobbing pot-shots at the big guys.  They do it to inflate their egos and impress their girlfriends. 

Or do I have...

Yes.  This can be done through the performace monitor application.  The counter is in the "physical disk" collection.

DTSRUNUI can be typed at a CMD prompt or directly into the "run" command from the Windows start menu.

It will pop a form that allows you to enter server, login,...

One tequila,

Two tequila,

Three tequila,

Floor?

It is possible that the IBM rep was talking about 'clustering' in the general sense, and not specifically talking about Microsoft Cluster Services.

I believe that Veritas makes a clustering product...

Murali,

You should probably look at your backup and recovery needs in order to come up with a good plan.

In my environment, I have a couple of servers.  "SQLOPS" and "SQLDIST01"

The...

No more than 41% at the time I answered it.

SET COMPUTERNAME returns the virtual server's NBNAME, which is the same no matter what physical node it's running on.

Try this:

create table #foo (

id tinyint identity(1,1),

txt varchar(255))

Insert #foo (txt)

exec master.dbo.xp_cmdshell 'ping localhost...