I still need to provide a solution. I'm unable to upgrade the server version or purchase any products. Technically, the failover is accomplished by the application server. Maybe I do...

I know a good reason to shrink log files. Database was set up for full recovery, but no regular t-log backups were scheduled (engineer who set it up thought log...

Everyone who posted is right when they say that the specific business requirements and architecture are essential to determining what should happen when the database goes down.

I worked on an...

Women leave IT because the IT culture is not compatible with motherhood. I was in IT, having somewhat fallen into it, in the 1990s. I didn't have kids then, but...

I had similar problems. I'd installed Visual Studio 2005 with SQL Express before installing SQL Server 2005 Developer. Since client tools already existed (but not all of them) the client...

One more way to do this, but I don't see any speed advantage on my machine. All three methods are 37 seconds. Although % is typically an integer operation, it...

I don't see anything obviously wrong that you're doing. It's a complicated calculation. It's possible that one or more implicit date conversions aren't yielding the correct date or even data...

Am I correctly deducing that you're changing the Order ID field? If so, IDENTITY won't work for you. And is Order ID part of the primary key? Are you changing the...

Andy, yes, you don't fit in that culture. At almost every position I've held, I've been considered competent and easy to work with. When I started my career, I was...

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

CREATE

TABLE TestBits(

thekey

INT PRIMARY KEY,

A

BIT