It will, a cursor doesn't change anything.

Example:

CREATE TABLE #a(id int IDENTITY(1,1), a char(1))

INSERT INTO #a(a)

SELECT 'a' UNION ALL

SELECT 'a' UNION ALL

SELECT 'a' UNION ALL

SELECT 'a'

GO

DECLARE @id int

BEGIN TRAN

DECLARE Test CURSOR...

How about adding a

CASE WHEN PATINDEX('%[0-9]%',VERISIONVAL) = 0 THEN 1 ELSE 0 END,

In fron

t of the other ORDER BY criteria (Order by anything that has a number first,...

Also, the table gives you a couple other benefits:

If you don't have any rhyme or reason for a time that is not work time (The building catches on fire and...

Here's how I would approach it. Note that I didn't do the math on the numbers CTE, I could have overblown the number I needed, but it's a one...

Excellent tip John, thank you. That has already led to me finding one of the many many things that need to be adjusted with this 'process'.

So far, the best I've come up with is to run a profile on the SPID and include the SHOWPLANSTAT events with the binary data, save the trace to a...

Did you read through the blog posts that Gail linked? They explain why cached plans are not always a benefit for things like this.

Dynamic SQL would stop you fro having to update the SP. If you're unaware of the dangers of SQL injection, make sure you do some research on it before...

A couple things. Were...

I find the argument to remove options and functionality in an effort to cater to ignorant/lazy people to be remarkably silly. (No offense intended) Extend that argument to...

I would personally look into the new DDL triggers available in 2005. You should be able to create triggers on create/alter/update for relevant objects to script out whenever they're...

I just re-installed notepad++ this morning with the intention of using it instead of notepad for all of my quick ad hoc notes to myself and possibly more. Does...

Several things about SSMS bugged me when I finally made the transition from QA. One thing that has saved it from being an unused icon again is that with...

OP,

If taking this...

There's really not enough information here for us to do anything with. Take a look at this article that Gail wrote:

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/