The boxes and balls cannot be applied/used until we know the order of operations. Maybe I missed it in this long thread :), so I'm sorry if I did......

Revenant (1/16/2012)

---

SQLKnowItAll (1/16/2012)

---

I think that dao's question was whether you can do it without the explicit SPLIT statement. That was the gist of my previous replies: you can alter...

bicky1980 (1/16/2012)

---

SQLKnowItAll (1/16/2012)

---

You have this:

insert into test2

values ('18','0014','01234567125','','9@test.co.uk')

insert into test2

values ('19','0014','01234567126','','9@test.co.uk')

Then this is 1 unique landline?

You have this:

insert into test2

values ('18','0014','01234567126','','9@test.co.uk')

insert into test2

values ('19','0014','01234567126','','9@test.co.uk')

This is 1 unique landline?

You have this:

insert...

You have this:

insert into test2

values ('18','0014','01234567125','','9@test.co.uk')

insert into test2

values ('19','0014','01234567126','','9@test.co.uk')

Then this is 1 unique landline?

You have this:

insert into test2

values ('18','0014','01234567126','','9@test.co.uk')

insert into test2

values ('19','0014','01234567126','','9@test.co.uk')

This is 1 unique landline?

You have this:

insert into test2

values...

This statement contradicts your counts. This would make...

I think that dao's question was whether you can do it without the explicit SPLIT statement. That was the gist of my previous replies: you can alter (redefine) the...

thotvedt (1/13/2012)

---

Yup. I saw that in the link you posted. That explains why the log is not being truncated for certain. Does that also explain why the full backups are...

guerillaunit (1/16/2012)

---

Hi Lowell,

This isn't a productiont table I am producing. It's a reference table that I use for research. I currently make the table in Access, but I...

dao-434438 (1/15/2012)

---

I was wondering if you got the answer to your question about adding new partitions w/o splitting the the range ?

How do you add many partitions to an...

It is quite possible that the update statistics was causing this. When you rebuild the index, the statistics are updated using a full scan and are much more accurate/efficient...

Welsh Corgi (1/16/2012)

---

MysteryJimbo (1/16/2012)

---

As a minimum I would have 5 drives if your budget allows.

-System drive 100GB

-Page file drive (20GB?)

-SQL Data drive

-SQL Log drive

-Tempdb drive

You can get away with three...

Sorry, I was getting pulled into a meeting as I was starting...

No, it is not correct.

Have you restarted the SQL Server service? This must be restarted for the changes to take place.

patrickmcginnis59 (1/16/2012)

---

SQLKnowItAll (1/16/2012)

---

HINT: Look at the data types for the columns you are doing the difference of. Are you sure that the difference can be negative based on those...