You could try optimizing this one. One general strategy I use is if its too expensive to make the columns look like the parameter, then make the parameter look like...

ZZartin (6/17/2015)Sometimes the only way people will accept they're wrong is if you prove them wrong. For example a perfectly plausible scenario is that columns are added in a...

ZZartin (6/5/2015)

---

EdVassie (6/5/2015)

---

You could try a little role-play.

Call your developers into a meeting, and have a box of paper left outside the room.

Tell a developer you need some paper and...

I'm wondering here if the untrusted browser can then set the cookie to arbitrary values to try to get into someone elses database? I myself would probably use the cookie...

andrew gothard (6/12/2015)

---

Aye - very fair point. I've replied on the subject myself on this thread and you're right, on reflection it does detract from the discussion on what...

Honestly, if you have an environment that makes use of schemas to that extent, I think its well worth drilling down in a test environment and making a study of...

WARNING, UNDERSTAND AND TEST YOUR SECURITY WHEN MAKING CHANGES. SECURITY IS SERIOUS BUSINESS. YOU SHOULD ASSUME THIS POST IS COMPLETE JUNK.

Heh anyways...

Just curious here, could you just let that user...

SQL Server will definitely change...

madan.preeti2005 (6/9/2015)

---

Thank you for your response

These tables (around 12/15) are used for reporting purpose. there are 3 jobs which fill these tables from another server and then there are queries...

g.britton (6/2/2015)

---

Brian J. Parker (6/1/2015)

---

This also got me thinking of another real-world example I've faced. Let's say you have a third-party product that includes a really complicated stored procedure that...

ray 64276 (6/1/2015)

---

Cursors can have a higher performance in many cases where dealing with large updates. There are a couple reasons for this:

- The deleted and inserted tables...

g.britton (6/1/2015)

---

patrickmcginnis59 10839 (6/1/2015)

---

Comes from "Edsger Dijkstra's letter Go To Statement Considered Harmful, published in...

Comes from "Edsger Dijkstra's letter Go To Statement Considered Harmful, published in the March 1968...

reminds me of this:

https://www.flickr.com/photos/erikcharlton/348280630

Lynn Pettis (5/27/2015)

---

meilenb (5/27/2015)

---

Alan.B (5/27/2015)

---

meilenb (5/27/2015)

---

Alan.B (5/27/2015)

---

Lynn Pettis (5/27/2015)

---

meilenb (5/27/2015)

---

Alan.B (5/27/2015)

---

Emph. mine

How is the science clear on climate change when the scientists...