My application is taking rest of the memory and the CPU is high when it get launched.

my question is if sql is allocated with 3 gb of RAM why it...

If millions of record are there and if delete is done on this , will the pages remain in db and occupy space?

I am explicitly Inserting into table using UidcreateSequential Method

]http://msdn.microsoft.com/en-us/library/aa379322(VS.85).aspx[/url]

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

Thanks

3GB for SQL server and 2 GB for Application

My question was to will the table be fragment again if the old values where there.

I did rebuild (alter index) post changing to NEWSEQUENTIALID().

I see table getting fragmentation after changing...

Opposite ...abnormal

on launching my app my sql server query runs slow. before launch it normal

What will happen for the pregenerated id's?

those ids are generated by NEWID() which is around 10 million record in the table.

now changed NEWSEQUENTIALID() and it starts its sequential orders.

will my...

free_mascot (5/21/2014)

---

What kind of application you are using on database server? As best practice microsoft recomend to have dedicated database server.

Check for any hardware bottlenack. Are you facing issue...

Thanks Gail

so what if the unique id is generated from outside database

If it is from UidcreateSequential function

how the performance will be?

it is same as NEWSEQUENTIALID?

is the behaviour is same for...

moving Database B details to Database A

1. May you have the same data in both databases?

If Q#1 = Yes:...

The pic is not clear can u tell in select statement

like 1+4 and so on....

since id 1 is not clear.

for 2 it is like ?

Select 1+4=5

Select 4+2=6

Select 2+4=6

Select 4+0=4

vignesh.ms (5/20/2014)

---

Hi there,

here is the sample

create table Sample (id int ,value int,total int)

insert into Sample (id,value) values (1,1)

insert into Sample (id,value) values (1,4)

insert into Sample (id,value) values...

No Gail

I checked it ...there is less frag when...

Grant Fritchey (5/19/2014)

---

Then the default of NEWSEQUENTIALID wasn't actually used. Microsoft says that NEWSEQUENTIALID will be faster, so that's not a surprise. It's right there in the documentation that I...

Grant Fritchey (5/19/2014)

---

Can it still fragment? Yes. If you substitute NEWID will that lead to even more fragmentation? Yes. Nothing has changed since the last time we talked about how...