Sean Lange (8/27/2013)

---

Isabelle2378 (8/27/2013)

---

Hi,

My tables do not have primary keys and as I understand it, transactional replication requires primary keys so my question is: Has anybody found a 3rd...

You might need to use ROW_NUMBER() instead, if there is any chance of a gap/missing number in the EntryID column (note that by definition identity columns can have gaps in...

Hmm, no point in maintaining indexes for 11 months in which they are not being used.

But 30 days? That's a different q. Typically it depends on the size...

In Oracle, a TRUNCATE indeed cannot be rolled back. [Oracle uses a fundamentally different way of handling table allocations that would make it essentially impossible for Oracle to rollback...

GilaMonster (8/27/2013)

---

davidandrews13 (8/27/2013)

---

good advice. i'll certainly get in the habit and also update Procedures as-and-when i get to them so that, come day zero, it wont be such a big...

Sorry, but that's...

You have to separate the data format the user enters vs. what's stored in the db. It's OK in your app to have the user enter "mon. dd, yyyy"...

mario17 (8/23/2013)

---

Thanks, Scott

Your code works fine, and much easy to digest ( or learn if you will), amazing.. and thanks again to you and Dwain for sharing this, sure you...

Good points about the Unicode and datetimeoffset (I've never personally used that data type):

-- list column data type, including len(s), if applicable

...

You should use your own tally table, either a permanent one or a dynamically generated one. Since the permanent one would be clustered on the tally value, it might...

The app should insert a "header" row into a different table when it starts. You can then use that table to pull the log entries.

If the log table contains...

You have to go further than that, including considerations of datetime, datetime2, etc..

NOTE: The code below does NOT consider any user-defined data types.

...

CleverSQLUserID (8/21/2013)

---

ScottPletcher (8/14/2013)

---

The code uses LIKE to compare the string, so just construct your string accordingly.

<snip>

I'll add code to see the actual part(s) of the text that match if you...

Look at the SQL Server Agent error log (separate from SQL Server error log); there will (should) be more info there on why Agent could not start.

taigovinda (8/20/2013)

---

In trying to understand this a bit better, I googled for 'primary key clustered' vs 'unique key clustered' ... if I understand correctly the unique key will NOT prevent...