DBADave (1/5/2009)

---

We also have a large Oracle environment here as well. One thing we do in the multi-TB data warehouses is track index rebuilds/reorganizations in a table in the...

Jim Johnston (1/5/2009)

---

Jonathan Kehayias (1/5/2009)

---

At some point I would expect that you have to do a...

I forget who posted it on Twitter first, but it was covered on slashdot a few days back. It is really kind of sad. I am torn about...

DBADave (1/5/2009)

---

They said people read how you can use multiple data files to improve tempdb performance and assume that also pertains to other databases. That's not the case. ...

At some point I would expect that you have to do a rebuild to get it...

Disgruntled employees delete your databases like what happened to:

http://www.journalspace.com.

They were an online blogging/community site for six years, and had no backups of their SQL Database, that collapsed over...

Actually, the implicit type conversions that could happen depending on how you implement the column could be very detremental to performance. If the column is a varchar(128), and you...

In my own design I would go with the nvarchar(128) or use a user defined data type (UDDT) that describes the data being held.

Laurentiu Cristofor's blog is one the best sources of information on encryption. Some posts to look at are:

http://blogs.msdn.com/lcris/archive/2007/10/04/sql-server-2005-a-note-about-the-use-of-certificates.aspx

http://blogs.msdn.com/lcris/archive/2008/01/11/sql-server-2005-why-you-should-not-encrypt-data-with-certificates.aspx

http://blogs.msdn.com/lcris/archive/2005/10/14/sql-server-2005-using-symmetric-keys-to-encrypt-data.aspx

The last discusses how to protect the data encrypted by a symmetric...

Agreed,

It looks like you tried to post some sort of code into the post that ate your text. From the preview I can see:

sql server could not configure ;instance'...

You could have done an inplace migration from Evaluation to Standard/Enterprise Edition using the command line SKUUPGRADE=1 option. The command would be like the following:

start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER...

DBADave,

The next time the Index Maintenance is running, check if it specifically is having the CXPacket waits that you describe. If it is, then add the MAXDOP 1 option...

One other thing to check is if the SMK is being used by the Key or Cert for encryption. A DBA will have access to the SMK for sure...

If they are a sysadmin on the SQL Server, I wouldn't bet on it. Sysadmins can do a number of operations that may allow them to decrypt the data,...

If a database is corrupt, all you can do is restore it. Anything else is a last ditch effort to recover information because you failed to backup your data...