You should either be able to use a variable for the local path attribute, or build an expression for it. Either one should do what you need.

Depending on the details of how your cursor is being declared (updatable vs read-only, fast forward, et al), having an explicit transaction wrapped around the whole process would make it...

Any possibility of federating (partitioning) the tables?

Then you could rebuild indexes incrementally. That can often help.

Jeff Moden (1/23/2012)

---

GSquared (1/23/2012)

---

I have to admit, I'm sometimes guilty of "jiggling the code till it unbreaks".

I've had to do that in order to teach myself what little I know...

I have to admit, I'm sometimes guilty of "jiggling the code till it unbreaks".

I've had to do that in order to teach myself what little I know of XQuery for...

Okay.

Depending on your decryption method, decrypting a whole table all at once is probably going to be slow, no matter what you do in the database. Encryption/decryption is very...

Take a look at RedGate's SQL Dependency Tracker (link at top right corner of this site). See if that will do what you need.

It depends on what you're doing and how you're doing it.

It possibly can be made faster, but I can't suggest anything to do that without answers to the questions I...

Does the encryption/decryption take place in the database or in a higher layer?

How many rows at a time are you decrypting?

Does the data have to be pulled from the table,...

Stephanie Giovannini (1/20/2012)

---

Daylight savings exists so that I can double the number of mornings that I drive east staring at the rising sun and the evenings that I drive west...

I just delivered a "lunch-and-learn" to the devs where I work. Since we just upgraded to SQL 2008 R2, it was on new T-SQL features they might find useful,...

OMG!!

I've got people staring at me as I laugh maniacally right about now!

Too much!

Love it!

Makes sense. Thanks for updating this.

Not sure what to do in that case. Maybe someone will stop by with experience in that.

I'm used to pulling images in via the file system, not via a...

Rowversion is the alternative to TimeStamp.

TimeStamp was badly named in the first place. The data doesn't have any real relation to time stamps, it's just a row version increment.