Ed Wagner (10/5/2015)

---

You know, I think the Silver Spoons are going to need to be reordered - I'd suggest at least a case. SS is in rare form today,...

I started work at a previous employer where the COBOL/ISAM system ran using DG COBOL and INFOS ISAM files for the data. It was already 12 years old when...

What article?

Assuming this is a data warehouse load, start checking the logs for the ETL process. If there is a problem hopefully the process logs the errors.

roryp 96873 (10/5/2015)

---

Lynn Pettis (10/5/2015)

---

Can anyone tell me what PUP means? I The definition must be snake because I can't seem to find it and it is going to...

Can anyone tell me what PUP means? I The definition must be snake because I can't seem to find it and it is going to bite me.

Because I don't necessarily want to restart SQL just to clear some of the DMVs I am using....

How do I clear the DMVs without restarting SQL?

I have seen that. Makes you...

Brandie Tarvin (10/2/2015)

---

Stupid question, which may or may not have anything to do with this...

You mention it starts when 6 ore more users are logged in. Is the program...

I love the code that looks like this:

WHERE ISNULL(SomeColumn,'') > ''

Uh, this would also work:

WHERE SomeColumn > ''

Same issue, though, getting them to make the changes in the application code...

Jeff Moden (10/1/2015)

---

Kristen-173977 (9/28/2015)

---

My new high score :w00t:

FWIW a +1000 pet-hate of mine is using short mnemonics for the datepart parameters e.g. DATEADD(dd, ... instead of DATEADD(Day, ...

I...

Eirikur Eiriksson (10/2/2015)

---

Lynn Pettis (10/2/2015)

---

There are no foreign key relationships between any of the tables in the database. There is no table above the base report tables (OperationsSIGACTDraftReport...

That's two against and one for (me). I'm not going to apologize, though. He makes that same comment in many posts where there is code like that in...

Eirikur Eiriksson (10/2/2015)

---

Quick question, are the ReportKey columns in in both tables coming from a third table or are there any other such indirect relationships?

😎

+---------------+ ...