It looks like the below query has the same kind of performance between the dev and the test servers:

declare @count int

declare @val nvarchar (100)

set @count = 1

While @count <= 1000

begin

SELECT...

Sorry, I got one thing wrong here, the execution time is about the same for 5 records on both servers if I use:

SET STATISTICS TIME ON

SET STATISTICS IO ON

If I...

Paul White (3/6/2010)

---

Hey Jeff,

There's a faster method than that in 2005 (and I don't mean CLR):

USE tempdb;

GO

IF OBJECT_ID(N'tempdb..#Binary', N'U')

...

Jeff Moden (3/4/2010)

---

I saw that and didn't see the function being used in the code and figured it was an incomplete listing. I...

I've posted it already: Post #876546

Jeff Moden (3/3/2010)

---

Roust_m (3/2/2010)

---

Another issue we have with this function is that it fails after few days without SQL instance restart. When we restart it it works until SQL...

Jeff Moden (3/3/2010)

---

Never mind... decided to make a "direct" replacement so you don't necessarily have to change code. Read the comment in the code header below...

CREATE FUNCTION dbo.fn_varbintohexstr...

Jeff Moden (3/3/2010)

---

Roust_m (3/1/2010)

---

Hi,

A developer approached me in regards for sys.fn_varbintohexstr function they are using at the moment saying it is slow in production: 60 seconds for 15k records...

Another issue we have with this function is that it fails after few days without SQL instance restart. When we restart it it works until SQL Server uses its...

Up! 🙂

Yes I did, no blocking whatsoever...

The process is a big IS package. I can't post it as it may contain some sensitive information.

However I am wondering why after the instance restart the...

I guess you could find out the storage required for data using the data load rate, then double it to account for indexes and then double it again to account...

Yep, this one works perfectly. The only thing, I reckon you...

I...