Just need to do an inner join from the tree CTE to the Produits table

CREATE TABLE [dbo].[CATEGORIES](

[ID_CATEGORIE] [int] IDENTITY(1,1) NOT NULL primary key,

[CAT_ID_PARENT] [int] NULL,

[CAT_DESIGNATION] [varchar](150) NOT NULL,

[CAT_LEVEL] [int] )

CREATE...

Does this help? Would just be a case of calling the job...

http://msdn.microsoft.com/en-us/library/ee636367%28v=sql.105%29.aspx

I thought the limit was 20 cores, not 16.

But if SQL can see 20 cores, but only use 16, you still need to licenses all 20 cores as it is...

Mac1986 (2/14/2013)

I have a situation where in I need to restore a .BAK file and i do not have enough disk space to restore the entire Data and log...

Best option is a side by side install upgrade, that is if you have a spare server or can change the connection strings and have 4 2008 instances running along...

Do you know a login for anyone with sysadmin, securityadmin or dbcreator?

If not you will need to add yourself as a local admin on the Windows host where SQL is...

Please post table definitions, sample data and expected outcome based on the sample data as per the second link in my signature.

With that, we will be able to help you...

sys.dm_db_missing_index_details

But take what it says with a pinch of salt, create it test it apply it to live.

But DTA is the tool to analyse the workload to see if indexes...

You mean 1 CPU not 1 Core?

So 1 CPU with how many cores?

Yes I get that, but what does it look like now when you run the report, and what is wrong with it so I know what I need to do...

Need data or pictures of what it looks like now and what it should look like after.

sys.dm_exec_sessions

Index & Statistics maintenance would be my first port of call then look at tuning the queries.

Ola has a very comprehensive script which will do the index and statistics maintenance...

Speak to your MS Reseller or MS Directly for a quote, but with that hardware you will need 16 core licenses.

I belive it is the custom one he is writing from...