Is Change Coming? I certainly hope so. I honestly hope it's real, honest-to-goodness change in the area of security. The "get it done fast and work security...

From what I infer, you're looking for something like this:

SELECT cmpy_code, year_num, SUM(open_amt)

FROM tmpaccthist_2013_2014

GROUP BY cmpy_code, year_num;

From your sample output, I don't see the ORDER BY...

Bogart

Full backups are usually very IO-intense. I'd start by taking a look at the IO consumed by the other jobs. If they're IO heavy, you might need to...

I'd review the schedule to see if your full backups are frequent enough and if you're keeping enough of them. Review your recovery point objective to make sure you're...

Jeff Moden (12/26/2015)

---

In the recent past, I did some side work (performance improvements for code and maintenance of indexes) where I found that they used SSN as the PK and...

Jason A. Long (12/25/2015)

---

Jeff Moden (12/25/2015)

---

The LEN check doesn't do it...

The link Eirikur posted also contains an excellent discussion on the topic.

Wayne Sheffield has an excellent post that explains this very well at http://www.sqlservercentral.com/articles/comma+separated+list/71700/.

Like Jeff pointed out, understanding why the restrictions you listed exist is paramount to determining the solution. That's why we ask questions - to understand what's required and the...

Welsh Corgi (12/25/2015)

---

INSERT INTO PrismData.dbo.tblcall

SELECT * -- TOP 5000 arc.*

FROM PrismDataArchive.dbo.tblcallArchive AS arc

WHERE YEAR(arc.Call_Date) IN (1998)

COMMIT TRANSACTION

-- ROLLBACK TRANSACTION

Msg 213, Level 16, State 1, Line 12

Column name or...

Kevin, just the way you phrased "bad-data causers" made me think of the horrible offense of storing dates and times in string columns.

Morocco

This certainy isn't a comprehensive list, but I think it's a decent start.

While loops or cursors instead of set-based alternatives

Non-SARGable predicates

Multi statement table valued functions

Using SELECT * everywhere

Anders Pedersen (12/25/2015)

---

Since the article was reposted...

Two of the largest credit charge clearing systems runs on SQL, and has for a long time. The first time I worked on...