george sibbald (1/27/2009)

---

Michael Valentine Jones (1/27/2009)

---

Going by 120 yards by 50 yards for an American football field (100 yards goal-to-goal plus 2x10 yard end zones by 50 yards wide)

select Football_Fields_per_Million_SQ_Ft...

Going by 120 yards by 50 yards for an American football field (100 yards goal-to-goal plus 2x10 yard end zones by 50 yards wide)

select Football_Fields_per_Million_SQ_Ft =

1000000/(select SQ_Ft_Per_Football_Field = (120.0*50.0*3.0*3.0) )

Results:

Football_Fields_per_Million_SQ_Ft...

select Acres_per_Million_SQ_Ft = 1000000/(select SQ_Ft_Acre = (5280*5280)/640.00)

Results:

Acres_per_Million_SQ_Ft

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

22.9568411386593204775

(1 row(s) affected)

For you English measure challenged:

5280*5280 = Square feet per...

What exactly is "1mm sq ft "?

Lynn Pettis (1/26/2009)

---

Why would you say that? The number of members that have posted on the forums is much lower than the total number of members shown on the...

Lynn Pettis (1/26/2009)

---

Michael Valentine Jones (1/26/2009)

---

Where do you see the 1,000,000 number?

At the bottom of the main Forums page I see this:

Board Statistics

760,819 members have posted 518,208 posts within...

Where do you see the 1,000,000 number?

At the bottom of the main Forums page I see this:

Board Statistics

760,819 members have posted 518,208 posts within 118,891 topics.

It's a big...

I would suggest you contact Microsoft for help to see if that is even supported.

Why are you using RAW partitions?

Although they may still be supported, they have been obsolete since at least SQL Server 6.0.

I usually setup transaction log backups to run every 15 minutes, and sometime more...

select

*

from

MyTable

order by

case

when col1 is null and col2 is null and col3 is null

then 1

when col1 is null or col2 is null or col3 is null

then 2

else 3

end

Alvin Ramard (1/26/2009)

---

Michael Valentine Jones (1/26/2009)

---

I think to qualify as a really bad answer; it has to meet the following requirements:

1. It has to be syntactically correct code that executes...

I think to qualify as a really bad answer; it has to meet the following requirements:

1. It has to be syntactically correct code that executes and apparently does the job.

2....

When you restore a backup, all database files will be created at the same size the database was when you backed it up.

If you want to control the transaction log...

You can use a case a mentioned before, but it is harder to code than the previous post shows, because you also have to allow for nulls if the columns...