I like that you find it useful.

I've made the changes proposed by Henrik Staun Poulsen in a previous post and used it in a stored procedure because now there are...

Hi Henrik,

Thank you for the compliment.

I like your modifications. Thanks for them and I'm going to add them in the script. Probably making a stored procedure...

Josep.

I like your articles because are very didactic and thinking in a lot of ways how to do it.

This one with so many "steps" (approximations), has been useful for me...

And why not using this sentence:

SELECT C.CustomerID, C.CompanyName,

COUNT(O.OrderID) AS TotalOrders

FROM Customers C LEFT OUTER JOIN Orders O ON

C.CustomerID = O.CustomerID AND (YEAR(O.OrderDate) = 1996 OR...

Thank again for your answer!!

This solve our problems 🙂

Josep

PS: Sorry for the delay, I've been on holidays.

Thank you Paul for your answer. I didn't know the need of 8192 byte for each 8000 bytes of data. I going to try to find out why this...

I need...

I'm doing DBA tasks of our clients (15). At the moment they have 2 - 3 Gb but growing, specially the ones that save PDFs. But the maintenance plan is...

I'm not sure that I should post it here, but it's somehow related to SHRINKDATABASE...

The problem I have is that I save PDFs into the database in IMAGE data types....

I have bad experience with UDF. Once I had to change the length of a UDF VARCHAR and it was a nightmare. Solution? I change clear my database of UDF!...

I like things clear 🙂

But some lines above in your Terms and Conditions there's the following text:

"Any information or content provided on the Site (for example in the form of...

I like the article. But I think the important of a JOIN performance, too.

In my database, I have a table that has 14 foreign keys. So, I've a view that...

I'm sure that's a good moment to say:

Thank you for having grow up this great SQL Server website. Since I discovered it, I've read a lot of your daily articles...

Or the use of the SQL standard COALESCE. Example:

WHERE Column_Name=COALESCE(@Param_Name, Column_Name)

I'm not using SQL Server 2005, yet. But I've found this very usefull!

I'm also curious when you say: "Doing the update in batches doesn't guarantee no blocking of course, but...

Interesting the idea but I've some point unclear...

You can do SQL injection using EXEC, but I think there's no injection possibility using the sp_executesql store procedure.

Is sp_executesql inneficient? Well,...