SQL Feeds - All your SQL feeds in one place.

Monday, April 05, 2010

EXEC and sp_executesql - how are they different?

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 4/5/2010 9:51:00 PM

In my last post: Little Bobby Tables, SQL Injection and EXECUTE AS, I wanted to highlight how to avoid SQL Injection when using EXEC. A few people brought up the point that I could have avoided SQL Injection by using sp_executesql. And, while sp_executesql can be used in some cases, it's not always the most ideal from a performance perspective. So, to really show this, I'm going to start with focusing on the similarities and differences of EXEC and sp_executesql. I'll ...

[ read more ]

Character data type conversion when using SQL Server JDBC drivers

by Kun Cheng via Microsoft SQL Server Development Customer Advisory Team on 4/5/2010 9:49:00 PM

Author: Kun ChengReviewers: Wanda He, Kevin Cox, Michael Thomassy, Peter Scharlock In a recent customer engagement, I ran into an interesting situation, which I’d like to share, especially with SQL Server users using Microsoft JDBC drivers. It started with typical SQL Server performance tuning exercise to identify the most expensive queries running in SQL Server. The top query looks quite simple: SELECT contact FROM tbl_Customers WHERE ID = @P0   The query took about 3ms to run, which was n ...

[ read more ]

Character data type conversion when using SQL Server JDBC drivers

by Kun Cheng via Microsoft SQL Server Development Customer Advisory Team on 4/5/2010 9:49:00 PM

Author: Kun ChengReviewers: Wanda He, Kevin Cox, Michael Thomassy, Peter Scharlock In a recent customer engagement, I ran into an interesting situation, which I’d like to share, especially with SQL Server users using Microsoft JDBC drivers. It started with typical SQL Server performance tuning exercise to identify the most expensive queries running in SQL Server. The top query looks quite simple: SELECT contact FROM tbl_Customers WHERE ID = @P0   The query took about 3ms to run, which was n ...

[ read more ]

Moving the Transaction log file of the Mirror Database

by Sanjay Mishra via Microsoft SQL Server Development Customer Advisory Team on 4/5/2010 6:39:00 PM

  Author: Sanjay MishraReviewers: Prem Mehra, Mark Souza, Kun Cheng, Nicholas Dritsas, Thomas Kejser   Recently I worked with a customer who has deployed database mirroring for a very large database (~ 1 TB) between two data centers that are about 400 miles apart. I got an email from the customer that reads something like the following: While establishing DBM, we restored the log file on the mirror to a different location than its corresponding location on the principal. We had to do i ...

[ read more ]

Subscribe

New Feed

Product Spotlight

Recently Updated Sources

Legal Note

The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us