I think the record layout is correct - its just that column "provider name" should be further divided into LastName, FirstName, Middle Initial (probably)

if object_id('tempdb..#data') is not...

not my group by - I just copied the original code and moved the top 5 to the inner sql - and removed the outer sql as not required

so if...

look at the properties of the linked server you are using and enable the RPC options

select top 5 c.companyname as companyname, sum(j.cost) as cost
from job j
inner join customer c
on j.cus_guid = c.guid
where j.duedate >= dateadd(day,-7,getdate()) and
j.duedate < dateadd(day,+1,getdate())
group by c.guid,c.companyname,j.cost
order by cost...

And I have to ask - what is your trillion size number - please put it fully here

1.000.000.000 -- for me this is 1 billion

and 5 GB ... that's a...

that is, as far as I can see, an older paper.

Visual Studio Subscriptions (formerly MSDN subscriptions) - latest licensing whitepaper here.

from it

Different Licensed Users Can Run the Same Software

Each...

using the MSDN edition has a few constraints and I do not recommend it.

Main one is that if you use it then EVERYONE accessing that server, directly or indirectly, including...

so you are telling us that you went through the documentation on over 160 dmv views and you didn't find any other view that has a query hash column?

even a...

as you were told on your other thread about this (and please do not create multiple threads) you do each individually - which by now you should already be aware...

DON'T do it is the correct answer. All columns should have the correct data type for their content and purpose.

Null is what you should be using - fact you don't...

Phil - it was combination of 3 db's for a migration project (insurance company).

• transientdb - source data
• persistentdb - etl db - had synonyms to both transient and product...

• This reply was modified 6 years, 3 months ago by frederico_fonseca.

is it just me or does the OP here just think that we "should" answer all his/her questions without he/she showing that he made an effort of googling for whats...

you can try the following.

create a folder where you put the create scripts for those tables

on the projects where you need those tables ensure you have the folders...

you can try the following.

create a folder where you put the create scripts for those tables

on the projects where you need those tables ensure you have the folders setup correctly...

new queries only - so if you are seeing high cpu you will need to use a few dmv's to figure out which queries are taking that cpu