Undressing

For me music on the radio I start with the 70/80's rock station then progress to alternative then hip hop then country until I find a station not on...

Lynn Pettis (10/5/2016)

---

I just wish developers would show me the SQL code they are developing whether it is embedded in the application or as stored procedures or views before the...

CURRENT_TIMESTAMP

Hmm... the interface for oracle is pretty primitive and very similar to mysql, I hope you like command line 🙂 But on the back end in terms of what the...

It apparently...

Well just for fun I tried it with over 2000 cross applies and it runs sort of, it managed to fill up the tempdb just generating the estimated execution plan...

I remember in my very first and very simplest DBA job ( a lonnnnnnng time back) I had to send out a morning email basically saying, "All backups fine, all...

Hugo Kornelis (9/28/2016)

---

Ed Wagner (9/28/2016)

---

whereisSQL? (9/28/2016)

---

crookj (9/28/2016)

---

Ed Wagner (9/28/2016)

---

djj (9/28/2016)

---

TomThomson (9/27/2016)

---

whereisSQL? (9/27/2016)

---

djj (9/27/2016)

---

Ed Wagner (9/27/2016)

---

Evermore...

WITH TEMP_CTE AS(

SELECT NameFrequency.Name, NameFrequency.Role, RoleRankLookup.Priority, SUM(NameFrequency.Count) AS TOTAL, RANK() OVER(PARTITION BY NameFrequency.Name ORDER BY SUM(NameFrequency.Count) DESC, RoleRankLookup.Priority ASC) AS RN

FROM (VALUES('Jack', 'Student', 3),

('Jack', 'Teacher', 5),

('Jack', 'Admin', 2),

('Jack', 'Student', 2),

('Sue',...

I'm also one of those people who learns by doing, I can read a book on a subject cover to cover and retain/understand how to apply none of it. ...

I don't see data science as something you get a degree or certification in, it's a practical skill acquired through practice not through studying theory. And to actual be...

Well a couple things, it looks like you have more fields in your select statement than you have fields defined in the file. For the fields are these right...

koti.raavi (9/9/2016)

---

I feel like merge will reduce the code length and improve the performace..if that is the case i will avoid merge..or is there any we can rewrite above code...

BenWard (9/9/2016)

---

Having the will and the capability are 2 different things. With the proper training and experience, a top notch DBA could learn photoshop, study graphic design and become...