If the only difference is that some rows may have certain data elements updated and others can't, I'd say they belong in the same table (there are bound to be...

peter.cox (2/12/2014)

---

sorry - my bad. Meant there was no extended jobs. I'll have a read on Extended events (I've come from a SQL 2005 environment, so still not 100% au...

Eric M Russell (1/30/2014)

---

djackson 22568 (1/30/2014)

---

Software code should not be able to be patented. A copyright is more appropriate. There is little difference between me writing a book...

crazy_new (1/29/2014)

---

There are multiple line in the Invoice line table with the same ID, that's why I joined the Invoice ID and Invoice header.

I have to move them across from...

Good god man, it's hard enough...

Indeed.

St Jude is the Patron Saint of...

Jeff Moden (1/24/2014)

---

andrew gothard (1/24/2014)

---

netmikem (1/23/2014)

---

Thanks for the feedback.

The job ad definitely says SCUD. Here is the particular qualification statement ...

"Must have minimum eight years' experience with SQL, coding queries,...

Jim P. (1/23/2014)

---

It is us in IT whose responsibility is to highlight how a solution can be provided with as many of the risks mitigated without stripping the users of...

netmikem (1/23/2014)

---

Thanks for the feedback.

The job ad definitely says SCUD. Here is the particular qualification statement ...

"Must have minimum eight years' experience with SQL, coding queries, SCUD, stored procedures and...

I *Want* to ... but...

jasona.work (11/26/2013)

---

/rant mode on

Frickin' bloody pain in the tuckus idiotic mindless rules drones! Gotta go in early tomorrow because it's entirely possible a SQL server and a couple Oracle...

LutzM (11/23/2013)

---

Greg Edwards-268690 (11/23/2013)

We had SQL Server, DB2, Sybase, and Oracle. But we moved the application from Oracle to SQL Server. And DB2 was for the ERP System, and moved...

When I said half I was looking at just these two lines:

Eight to ten years database programming experience using two or more of the following databases; MS SQL Server, Oracle,...

Jeff Moden (11/22/2013)

---

Revenant (11/22/2013)

---

Jeff Moden (11/22/2013)

---

I'm, very thankfully, not currently in a postition like Lynn where I need to find a job because I wouldn't even consider working for a...

This should be able to be fixed by dropping and recreating the index.

http://www.sqlskills.com/blogs/paul/teched-demo-nonclustered-index-corruption/

however, the question of why the index has become corrupted is also an issue. Do you have...