steve.france (5/16/2013)

---

Thank you Shashank.

For 2012 it looks possible

John Mitchell-245523 (3/1/2012)

---

Phil Brammer (3/1/2012)

---

The SQL Browser service is only for named instances. If you change the default port of the default instance, you will always have to specify...

okbangas (3/1/2012)

---

Hi, just a little feedback. Under conclusion, you write:

If the SQL Server Browser service is not running, connection strings will have to specify the port number in order to...

COUNT(PriKey) only works...

LadyRuna (2/11/2011)

---

I added a New column to CustomerTable, then checked the view. It still listed only the original 5 columns for CustomerTable. The only way I could force the view...

If there is no backup strategy in place, and the database is in FULL recovery mode, the transaction log will likely be unreadable anyhow, as it will likely be massive...

Kraig Kerr (11/22/2010)

---

Looks like TDWI took down that link. Here is another that points to the same article. http://findarticles.com/p/articles/mi_m0EIN/is_2000_Nov_8/ai_66696495/

The current flavor of this works with SQL 2008, but...

DBCC PAGE is undocumented as well. Use at your own risk.

The link to the MGM Mirage article does not work. I'm still trying to decifer what your reasons for reading the log are. Also, what version of SQL...

That's not...

Except to...

Each time the package is executed, it should download the most current exchange rates.

In something like batch processing, you wouldn't want the...

Yeah, sounds like a HIGH-VALUE declaration in the COBOL (or whatever) code.

tarquin,

I'm not quite clear on how you know the hash of a record in a fact table ahead of time such that it helps with your updates.

Correct - the hash is not the lookup.

To make this work correctly, you create an index on the natural key and include the hash column. This way, you lookup...