Pick up Michael Coles' book on Pro SQL Server 2008 Encryption

Are you running x86 (32 bit)? If not, don't worry.

If you are

http://blogs.technet.com/b/rob/archive/2008/05/15/windows-memory-and-sql-server.aspx

http://msdn.microsoft.com/en-us/library/ms175581(v=sql.105).aspx

Powershell can work outside of SQL Server and is less cumbersome than stringing scripts through SQLCMD. That provides a good way to handle administrative tasks, especially when they involve the...

use a batch file. In it

sqlcmd -E -Q "sp_detach_db @dbname='mydb'"

They can double click the batch file to detach the database.

second vote for what Lynn said. If you provide some DDL and sample data, we can probably help.

I suspect that an inner join is needed as well. When you gather...

Seth has a good explanation, though I don't know I'd assume a trigger is being used. A stored proc can do this well.

The issue is you can't turn off encryption...

distinct won't just look at the productID. How can the engine tell which row to discard if it does? Is it the row with the lower price? The higher one?

You...

Robert Domitz (5/30/2012)

---

I, for one, am a programmer: my expertise is in designing and building software. I am not a writer, nor do I aspire to be one....

I hope people aren't rating the article down because it uses FTP and not SFTP. That's what SSIS provides, and we wanted to give a tutorial on how to use...

you are welcome.

SP4 is pretty stable, and should be fine. Note that there are some post-SP4 patches that you might want to apply as well as a few are...

We had a speech at an event yesterday from the American Legion post here in town that addressed this. It is happy so...

Back up everything. Are you looking to patch Windows, SQL, or both? What patches?

I wouldn't call SQL 2000 old or fragile.

If you're really worried, I'd do a P2V migration...

There isn't a 64bit disk file and a 32 bit disk file. They are the same.

detach/attach or backup/restore as Lynn noted.

A couple things.

First, glad things cleaned up for you.

Second, if you shrink the database, you may undo all the work you did in rebuilding the clustered index to remove fragmentation....

Second vote here for DBCC CHECKDB. You cannot prevent corruption, so you need to run this regularly. If you can't do it every day, do it every week.

The checking, was...