Hello adnani,

1: If the databases requires additional space there's not much you can do.

It seems that this is temporary, two things on that, if it's temporary you should be able...

Sure there's way to do it within SQL, but I wouldn't recommend them.

One of them is:

DECLARE @HDDDrivesList TABLE (

DriveLetter char(1)

, FreeSpaceLeft int NULL

)

INSERT @HDDDrivesList(DriveLetter,FreeSpaceLeft)

EXEC...

if you're using enterprise edition or higher, why not take a look at partitioning horizontally your table?

This is a powerful functionality.

http://msdn.microsoft.com/en-us/library/ms190199.aspx

Yes Celko, this is always a good point to have in mind. Thank you for this reminder!

Whoops!

Yes I was assuming this:

Well I do have learn something new...

Yes but from my understanding, time to perform a page split from a non clustered index <= time spent for a page split from a clustered index.

If that split occurs...

True,

But I would like to avoid page split on a table with a possible 1,500 millions rows in it.

If it needs to insert at the beginning of the clustered index...

Thank you,

Therefore I presume by your answer that data inside the clustered index will be ordered like:

Ordering ->

1.1, 1.2, 1.3, 2.1, 2.2, 3.1

Sorted by the first key, then by the...

I believe it could be possible (yet difficult) implementing the feature to restore a backup while having database snapshot.

Thank you!

It makes a lot of sense with the current state of the query.

Administrative operations need to be done automatically and autonomously.

Once deployed, there will be no way to go back and check.

:hehe: thank you for your support! I've already notice it was hard hence the question 😀

The best advice I could say is check the query plan for both and compare.

That will tell you what has happened.

In one scenario you might have a join task sooner...

I agree that the question is somewhat very large and may be interpreted in many ways.

The way I did see it at first was (translating "best administrative performance")

"What version will...

I've done a T-SQL sample to show what I mean:

Why NULLs are return on the DELETE statement from the Inserted table? I've not inserted anything!

Is it a "by design" feature...