Gary Varga (6/17/2013)

---

For too long we have rolled out the young/immature industry arguments. We must stop because quite simply: we know better.

A lot of these industries which have compliance, regulatory...

How big are your log backups? Check the size for each hour. If they are small, then you have something preventing the truncation of the log, like replication or mirroring...

At this point I wouldn't drop the master key. That won't help with your encryption status.

If you cannot drop this (encrypted state = 2) database, or do not have an...

Lynn Pettis (6/14/2013)

---

***************************************************

I am officially going to Afghanistan!

I leave for IRDO at Camp Atterbury in Indiana on Sunday, June 23rd. All should go well there with me leaving there...

It should complete by itself. Has the progress changed at all?

If not, then I think you are in trouble. I'd backup the database, or copy out all data/schema and my...

Thanks for the correction, Hugo. Moving too fast today.

Not sure why you would disable a clustered index then. Perhaps it was included to keep consistent syntax for all indexes? Seems...

It still isn't quite clear. The exact error and exact steps are needed, but you can debug this yourself as well.

run a trace on the 2000 server and watch what...

That makes more sense. I'm not familiar with terminal services licensing, but can you have 2 or 3 terminal servers under the same licensing? Is it by CAL or is...

ETL loads is one reason. It can be faster to load without indexes...

It's not quite clear what you mean, or what you did for access.

What did you do to grant access.

When you say he gets an error, do you mean he...

My apologies. I think I cut and pasted the drop in the wrong spot when this was proofed. It definitely ran correctly when it was tested.

I will award points back...

wolfkillj (6/14/2013)

You got close, Rod, and we'll give you a pass since you're not American.

Here's the lineup:

1st base: Who

2nd base: What

3rd base: I Don't Know

Left field: Why

Center field: Because

Pitcher:...

First, you probably should have someone else responsible for setting this up or working with you. Encryption is serious business and if you lose keys, you lose data. Microsoft...

There is a percent complete column, where you can get the progress. In terms of the rate, you'd have to just watch this and calculate something.

SELECT

db.name,

...

Do you have lots of free space in your databases?

In terms of the object, what's the way that it's structured? Is the row size significant compare to page size? Fill...