Hi Again

Why do you know every thing ? :crazy:

And Why am I careless? 😀 :blush:

Yes You Are right. I changed the Index and These are The results :...

Thank you

But some say the "NT Service\MSSQLSERVER" is more securable for servers that work on internet.

What's your Idea?

we dont have any special increase in log file.

what do your mean to look at transaction log? how to do it?

Hi

I dont want that you rewrite these queries.Only For you Inform :

I Tried 2 Times but the result was not very efficient .

I need an idea or...

Hi again

I have 2 Functions in my Query. (then 2 columns in my query's output)

Function 1 : calculate a value on check a state field. (get values from 2...

Hi again

Thank you All

I Did partitioning successfuly.

------------------------------------

But Unlike the proposed regulation I could have a better performance.

Database 1 : (Old db Without Partitioning - and 2 index : key cluster...

Ok

The results are equal

and your query has 24 cost in comparition 76 cost of my query.

more over :

the Eirikur Eiriksson's queries are very complete.

Thank you All

First a minor terminology note. RDBs operates on sets of rows not records.The result of table expressions is a set of rows. Records are parts of recordsets returned by DB...

Your Query Return Only One record

And My Query Return records equal the T1 Records Number.

yesssssss

Index on shceme . (Not on table)

I found the command .

CREATE NONCLUSTERED INDEX [NonClusteredIndex-MydateFiled]

...

select I.Object_id,name,I.index_id ,partition_id ,partition_number

from sys.indexes I Inner Join sys.partitions P On P.Object_id= I.Object_id

And I.object_id = 1109578991

This is result

1109578991 ---- NULL ---------------------------------------- 0 --- 72057594042515456 ---1

1109578991 ---- NULL ----------------------------------------...

Hi and thank you

Your advices changed my perspective about partitioning and relations to Performance.

OK

But the truth is that I had raised this issue, I must go to the end.(Only...

Any Thing?

Hi

Your Comment has error :

alter index [NonClusteredIndex-MydateFiled] on MyTable rebuild on MyParScheme([MyDateFiled])

And I Did this :

My Table had an cluster index on id.

I Remove it And Create New NonCluterIndex On...

Befor Partitioning :

Primary FG : data File 1 = 100 GB

--------------------------

After Partitioning :

Primary FG : data File 1 = 100 GB

FG_2015_01 : data file 2 = 10 MB...