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...

Michael Valentine Jones (8/20/2013)

---

taigovinda (8/20/2013)

---

Hi,

My database has a bunch of tables on it that have no indexes at all on them. I want to add indexes to these tables...

ChrisM@Work (8/20/2013)

---

It has to be indexed to...