Thank you all for responding.  

Lynn - Yes, the query you posted is what I am referring to.  I didn't realized that ANSI-89 queries with inner joins were...

opc.three (5/14/2013)

---

sjs-36273 (5/14/2013)

---

GilaMonster (3/4/2012)

---

kilkenny (2/27/2012)

---

My first inclination was to turn on TDE, but after reading several articles, I'm worried about losing performance. If we choose to encrypt at the...

GilaMonster (3/4/2012)

---

kilkenny (2/27/2012)

---

My first inclination was to turn on TDE, but after reading several articles, I'm worried about losing performance. If we choose to encrypt at the column-level, it...

Don't feel bad for jumping in. All of this is great help. The database backup is 40 GB compressed with native tools. Not sure of the size...

Steve - I like where you are going with creating a snapshot of a mirror but isn't a snapshot read-only? How can I make it writeable? This is...

Gila

With transactional replication, are all FKs created at the subscriber? If I am correct, they aren’t. If the FKs are not on the subscriber, I am concerned about...

Gila - 900 miles across an ocean. One is staffed part of the day and the destination is not staffed.

Thanks Chris - The Server B (destination) database actually needs to have both read and write capibility.

Server B will be refreshed with prod data once a night but...

The physical spindles are dedicated. There is not any sharing. Thanks

The file is only 3 MB. I opened it in Notepad and it looks just fine. It looks very similar to a log file that does open on...

I found the answer.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=102320

Go to Report on Report Manager, Click properties of report, under the report definition you will see Edit and Update link...if you click on Edit you can...

I found the solution.

Starting from SQL Server 2008 SP1 Report Builder 2.0 can now be deployed as a click-once application. However this is not the default behavior after you install...

I found the solution.

Starting from SQL Server 2008 SP1 Report Builder 2.0 can now be deployed as a click-once application. However this is not the default behavior after you install...

I started to do triathlons a couple of years ago. I am doing my first half Ironman in a week. (1.2 mile swim, 56 mile bike, 13 mile...

Thanks for your response. You mention that I should intialize after I restore my encryption key. At every step along the way (after restoring databases, after restoring encryption...