is this "writing a query for a book"?? 😛

select row_number() over(partition by datepart(yy,create_date) order by name), *

from sys.tables

order by datepart(yy,create_date), name

bye!

thanks Koen

I was looking for "general reasons"

If you see the query plans now, they are almost identical

Now, with or without the index, the engine doesn't try to use it

I don't...

thanks Grant

this morning I executed the query again...

but I replaced the view (as you've suggested) with an explicit join between 2 tables

(the view is designed precisely to join these 2...

thanks,

I tested it

but it doesn't improve the query

I've attached 2 exec plans

thanks

I attach the exec plan, in xml format beacuse it's a bit large

please check that, in "plan 2", the estimated number of rows reach 128 millions

when the actual number...

there are some recomendations on the web, check if your table is a heap or not before "insert ... select", consider using begin transaction too

in 2008 r2, for inserting into...

Hi

I need to send distinct report to distinct persons

I have a dataset of people, with their names, email, etc

including the parameters to run the report

Could I accomplish this with SSxS...

You did it!!!! it works fine now !!!

thanks very much!

I love you 😛 !!!

OK! thanks for consider my comments!

regards

Hi Steve

I didn't dig very much on the RFC

but I get that feedback from Bugzilla

the date format I'm refer to is "yyyy/mm/dd"

that is, including the "/" symbol

the format yyyymmdd you...

I 100% agree, and would add another factor: it's difficult to involve clients in that a close way. Clients have their own concerns, responsabilities, and need to dedicate the most...

hi

you have to look for "xsd annotations"

and "schema collection"

you will find a way to accomplish it

with the SqlXml 3.0 or greater

which is an IIS-SqlServer interface (dll)

everything works:

schema transformations and mappings

but...

excuse me

the synonym must point to   "db_A"   ( for this example )

not to "USR01"   (  that is my actual environment  )

the problem is when i [exec synonym_to_sp]

inside another [sp] in another db

THIS SCRIPT REPRODUCES THE BEHAVIOR

-- in db_A

use

db_A

create

procedure dbo.

thanks gopi,

but,

if i right click the synonym

then "Include as" and then "CREATE To"

the script that i get

contains a "four-part names"