sql-noob (10/3/2012)

---

The user who is able to access the view belongs to a group which is added to the sql server from ADS(active directory services). Now the irony is other...

Try Adding an OPTION(RECOMPILE) to the SQL Statement that calls the CTE, as I suspect theres an element of paramater sniffing going on, whihc should be solved by this, it...

The reasons for asking the question were

1) As...

Is the view filtered based on row level security, eg a User can only see Certain Products?

Mainly Task manager, though also resource manager.

This is the set up (using a template from SSMS)

-- ================================================

-- Template generated from Template Explorer using:

-- Configure Resource Governor.sql

--

-- Use the Specify Values...

I think its the fact that the Row_number() requires an order by statement thus a sort, rather than an Identity which assigns the number as the data is returned.

I'd...

Thanks Gaz, I've been through the documentation, a couple of times, this is the first real implementation, were planning on using the App_name in order to seperate the different...

Can you provide the DDL for the tables and Indexes as they stand on Production so we can offer some help.

Has anyone changed anything on that table?

What is the sort...

Karthick,

Jeff was making valid point about about how to create the Tally table in the first place, most people will write a while loop, or a recursive CTE rather than...

As always a Fair point Jeff.

terry999 (10/2/2012)

---

Thank you. Your example is easier to read.

BTW I was restricting to only chnage rows by comparing the checksum values.

I didn't know you could add additional filters after is...

You can use the OUTPUT to insert rows into a table rather than the Outer Select, which is rather cumbersome.

this might be better, and you'd need to double check...

While I agree its not a practical solution, as there are names (Yvonne, Pattinson, Lee, off the top of my head) where consecutive characters can be the same and so...

select nc1,nc2,class from

(select *,row_number() over (partition by rnk order by rnk) rnk1 from(

select * from

(

select nc1,nc2,class,dense_rank() over (order by (nc1+nc2)/2) rnk from #nc

)a

)b

)c where rnk1...

nice once dwain, never thought of that, though I suppose it depends on how much you can change the underlying database structure.