Jeff Moden (9/6/2012)

---

UMG Developer (9/5/2012)

---

Adam Machanic (9/5/2012)

---

How are you seeing string splits used where such a difference would matter? (Again, I am *only* talking about string split operations.)

Generally when I...

...

My last suggestion is to make a function to clean up your queries. It will take a large amount of time but it will be more accurate.

1. REPLACE CHAR(13)+CHAR(10), CHAR(10)+CHAR(13)...

Just two samples without windowed functions:

1. Use of temporary storage for values to keep. It may play very well if you need to large set of data:

create table #demo(val nvarchar(20))

insert...

You can achieve it with use of dynamic SQL.

Do you really have a table with a single column? Or you have some ID there. Id so, you may be able to de-dupe without use of windowed function.

What do you call by "practical used"?

I...

No,...

I can not see any points of trying to search for a specific query which can be implemented in unlimited number of ways. Eg. comments, white spaces, multi-lines, different table...

I have seen overhead with operations on NVARCHAR(MAX) on all types of CLR's eg. table-valued one. I think it is related to the way of memory reservation for MAX type....

I took my function from this one: http://www.sqlservercentral.com/Forums/Topic1348575-338-1.aspx

CLR:

using System.Data;

using System.Data.SqlClient;

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

using System.Text.RegularExpressions;

namespace CLRPlay

{

public partial class UserDefinedFunctions

{

...

Adam Machanic (9/5/2012)

---

Eugene Elutin (9/5/2012)

---

You may not agree. But if you need to split NVARCHAR(max) and NVARCHAR(100), CLR function declared with NVARCHAR(100) as input parameter will perform faster than one...

vinay.varaala (9/5/2012)

---

select dateadd(mm, datediff(mm, 0, @ThisDate) - 1, 0) -- Beginning of previous month

getdate()-- current date

my question I want the records from beginning of previous month to today ..wats...

What about if his query in SP is like that:

select *

from table1 -- some comment ...

I do not agree that there is any point in trying to optimize for smaller strings. Especially given the streaming solution, I think you'd be hard pressed to find a...

The above command cannot "empty out" the column. You did something...