@brigzy

You really should try your tests with a complete table to be handled instead of single strings. "GO N" is a feature of SSMS which causes "N" separate statements to...

Hi

You don't have to create a usual .NET assembly like a console application or a class library. You have to create a SQL Server Project which is a special project...

:w00t:

Could you try to isolate this query into an own batch (without other statements) and executed it in Query Analyzer with "Show Actual Execution Plan" option enabled. You find this...

Hi

As Lutz already wrote. If it runs almost endless it would be helpful if you could provide the execution plan of this query. To provide this enclose the specific query...

Hi

@Lutz:

Oups. Didn't recognize the SELECT INTO. :ermm:

@riga1966:

How did you change your query? Do you use a "WHERE IN" a "WHERE EXISTS" or a "JOIN"? How many items does your input...

Hi Lutz and Riga

Be careful with joining table valued functions. Especially if the string split function works with schema table like spt_values or a Numbers/Tally table.

Just had some nice performance...

@Jeff

Nice article! Thanks for sharing. 🙂

@brigzy

Probably try to work without the "GO N" feature (which is a feature of SSMS, not a T-SQL functionality).

I just tried a simple CLR function...

Hi

You can use the same code as shown in the sample.

As a little side information:

If I'm not wrong, google blocks IPs which send too much requests and don't look like...

Hi

You can start here:

Designing and Implementing Semistructured Storage (Database Engine)

Greets

Flo

Edit: Typo

:hehe:!

As I said, "a wise man told me". First person who told me this analogy was Jeff 😉

In my opinion the problem are not the ORMs but more some of the managers and architects. An ORM is a tool, nothing more. In early days everything was done...

... SQL:StmtRecompile for custom SQL.

Hi

Well, GROUP BY means to group several rows by specified columns... It aggregates rows so that there are no more duplicate rows for the specified columns.

DECLARE @orders TABLE (Amount DECIMAL(15,2),...

"i_date" smells like an integer, right?

Try this:

SELECT SUBSTRING(CONVERT(VARCHAR(12), CONVERT(DATETIME, CONVERT(CHAR(6),i_date) + '01'), 103), 4, 7)

Greets

Flo

(PS: What's wrong with storing dates as DATETIME those days on SSC?)