We have a server with full text searching enabled and another where it is not. We have a stored proc that checks if full text indexing is enabled and runs a search query as appropriate but the issue ...

In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...

I guess I'm going to find out! I will bet you otherwise: a stored proc with multiple serially executed set-based operations (even with conditional flow statements) usually wins over cursors. I totally ...