Siberian Khatru (3/12/2014)

---

I have a table with @ 20 Million rows of data I want to truncate or delete. I don't need any of the data in it anymore...

Jeff Moden (3/13/2014)

---

Eric M Russell (3/13/2014)

---

pretea (3/13/2014)

---

Hi!

I have multiple (individual) insert statement to insert around 2 million rows (using sqlcmd because the insert stament is around 8 thou lines).

It took...

pretea (3/13/2014)

---

Hi!

I have multiple (individual) insert statement to insert around 2 million rows (using sqlcmd because the insert stament is around 8 thou lines).

It took about an hr to insert...

I've never actually used Twitter, but it seems to me that if the question can be expressed in 140 characters or less, then the answer could probably by found quicker...

It depends on what automation and instrumentation method you're wanting to inegrate with.

It will require some programming, but PowerShell is typically used for what you're asking. This is perhaps...

Odd, I would expect the...

That's funny. 😛

It's been a long time ago, but I vaguely recall using LINQ (or OLEDB directly) to query data from Outlook.

http://thedatafarm.com/data-access/using-linq-to-query-outlook-emails-joined-with-sql-data/

This little DMV ditty should to the trick.

select

object_name(s.object_id) as obj_name,

...

In the case of MS Access, the application forms, reports, business logic, SQL, and database are all intertwined in one file. I guess that works...

dmbaker (3/6/2014)

---

Eric M Russell (3/6/2014)

---

dmbaker (3/6/2014)

---

Eric M Russell (3/6/2014)

---

It's true that by coding batch processing logic within the application, your SQL code can be simplified and constructed in a more...

dmbaker (3/6/2014)

---

Eric M Russell (3/6/2014)

---

It's true that by coding batch processing logic within the application, your SQL code can be simplified and constructed in a more cross-platform fashion. Basic SELECT,...

It's true that by coding batch processing logic within the application, your SQL code can be simplified and constructed in a more cross-platform fashion. Basic SELECT, INSERT, and UPDATE operations...

I would like to see a TV series based on the original 'Conan the Barbarian' short stories written by Robert E. Howard. It could be done in the same style...

I hear that a movie is in the works based on Neil Gaiman's comic book series, 'The Sandman'. I've never actually been that much into comics, but my roommate in...