aaah, that explains the table that never replicated then, its the only one with no PK, thanks for the info 🙂

So I've followed the first SSC stairway step for replication to make sure i did everything correct, did it on a dev box with a test DB and some of...

Thanks for the reply opc. I had briefly thought about something like you suggested but figured the replication method would be faster (less downtime) as it should only require...

Thank you Anthony, very helpful 🙂

And the attached whitepaper looks pretty in-depth!

honza.mf (11/1/2012)

---

Ross.M (11/1/2012)

---

... however for the sake of understanding string comparisons, we have no use for knowing how many characters are between 0 and Z, we just need to know...

honza.mf (11/1/2012)

---

derek.colley (11/1/2012)

---

I'm afraid this question was just too obscure for me. It's a good question, sure, but why would I need to know this or reference it in...

Carlo Romagnano (9/26/2012)

---

I think the explanation is incomplete and inaccurate.

INNER JOIN returns number of rows from...

I think c was not actively looking but open to wild offers:

I saw a great quote recently on a LinkedIn profile: " I'm not actively looking for a new position....

What's your reasoning behind this though? Don't get me wrong,...

Ahh ok, I've never connected to excel with SSRS but in a previous job we did have problems with the SSRS user not having access to network drives when it...

Not sure if this will work or not but have you tried sharing the excel doc? (Review tab > Share Workbook)

Works fine for me:

DECLARE@DBName NVARCHAR(50),

@DYNSQL NVARCHAR(MAX)

SET@DBName = 'master'

SET@DYNSQL = 'USE ' + @DBName + ' SELECT name AS [File Name] , physical_name AS [Physical Name], size/128.0 AS [Total Size in...

I'm just quoting the official Oracle documentation, see the link.

Removing rows with the TRUNCATE statement can be faster than removing all rows with the DELETE statement, especially if the table has numerous triggers, indexes, and other dependencies.

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_10006.htm