If you don't use them then there really isn't much need to have any concern here. 🙂

Cursors...

hisakimatama (1/10/2014)

---

Sean Lange (1/10/2014)

---

hisakimatama (1/10/2014)

---

The database most definitely isn't safe and secure if queries like those are being injected in. As Gail and the others have said, your code's...

hisakimatama (1/10/2014)

---

The database most definitely isn't safe and secure if queries like those are being injected in. As Gail and the others have said, your code's open for injection,...

Meltdown (1/10/2014)

---

Hi Sean,

Parameters are being used, I believe the database is safe and secure -- still don't like seeing the database being hammered with those types of queries.

I was just...

Cool glad that is working you. Thanks for letting me know.

The above example is exactly why you should NEVER NEVER NEVER run pass through sql statements that have information posted from a public facing web page. Properly parameterize your queries...

Yes what happens behind the scenes is an implicit conversion of all the data to the new datatype. This is incredibly simple to demonstrate.

Go on your test box and try...

petervdkerk (1/10/2014)

---

Thanks! Also for the coding feedback, will add that later 🙂

But it turns out that I need one more thing: of all duplicates: keep the row where the column...

rho_pooka (1/10/2014)

---

Greetings, another question for the group. I've been writing out my own homework exercises as I work through the 461 training kit; one of the problems I posed...

cdl_9009 (1/10/2014)

---

I have a Stored Proc that has been working good and never really had Identity issues.

The logic is used was I set @trans_id = SCOPE_IDENTITY(). I...

Shadab Shah (1/10/2014)

---

Sean Lange (1/10/2014)

---

Stale statistics?

Parameter sniffing (or the lack of it)?

It is nearly impossible to help without some details. Please see this article from Gail about how to post...

Stale statistics?

Parameter sniffing (or the lack of it)?

It is nearly impossible to help without some details. Please see this article from Gail about how to post performance issues. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D

Nested transactions are a myth. They do not exist. It seems like they should and the documentation evens references them. The reality is though they do NOT do what would...

Excellent job posting ddl and sample data. I think you deserve more than a link to basic article that discusses ROW_NUMBER but does nothing to explain how you might use...

Practicing canned answers for interview questions is not a great idea. What happens if the interviewer has an actual good question that requires a discussion about the topic? Interviews are...