As Dave pointed out, the IN predicate doesn't work that way.

You may also concatenate in a safer way, using FOR XML PATH.

Concatenating variables in the SELECT list doesn't always work...

OK, looks like I've got it working:

ALTER FUNCTION [dbo].[alias2dnsname] (

@alias NVARCHAR(50)

)

RETURNS TABLE

AS

RETURN (

WITH zones...

Thanks for the tip,...

It will probably be listed in the top 20 queries by CPU:

SELECT TOP 20

query_stats.sql_handle,

SUM(query_stats.total_worker_time)...

Is it OLTP or OLAP?

OLTP databases that use 100% CPU equals (most often) evil query. Find the offending query and fix it.

With a typical OLTP workload, CPU should stay low.

If...

steveb. (10/15/2010)

---

one thing you could do to make it a bit more obvious what server you are connecting to, is to define custom colours for each server under registered...

I use a special keyboard without the F5 key. 😛

Seriously, the main thing is avoiding experiments in production.

You experiment on the test server, then move working code to production.

Never, ever...

Thanks George.

I think I'm on the right track, but sometimes, since I set up this plan, the optimizer decides to pick a very odd plan.

Odd plan + 75 mln rows...

When you're telling the truth, nobody should feel offended! 🙂

george sibbald (10/14/2010)

---

Just in case you did not realise Gianluca this step may be superfluous. If your index rebuild is the...

:hehe::hehe::hehe::hehe: This is defintely the case with me!

Fortunately this is not what I'm doing. I'm setting fillfactor only for two tables, that are the most important tables in my database. They're heavily read and written, most updated...

[EDIT] Removed

Thanks for the suggestions, but I tried both and they don't seem to dellocate internal objects.

Probably that's the reason why MS decided to ship FREESYSTEMCACHE with SQL2005.

This seems to do the trick:

ALTER FUNCTION [dbo].[alias2dnsname] (

@alias NVARCHAR(50)

)

RETURNS TABLE

AS

RETURN (

WITH zones AS (

SELECT dnsname, alias

FROM dnszone AS A

WHERE A.alias...