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...

select distinct *

from

tableA

where

-- Greater than or equal to yesterday at 00:00:00.000 (midnight)

h.created >= dateadd(dd,datediff(dd,0,getdate())-1,0)

-- Less than today at 02:00:00.000 (2am)

h.created < dateadd(dd,datediff(dd,0,getdate()),'02:00')

Ross McMicken (1/26/2009)[hr

From what I've read, this is mostly a call center workers issue. They seem to get the worst of it from all sides - management and customers. That's...

That really only works correctly if the [created date] is from the current date.

The OP posted an example date of '1/12/2004 7:04 PM'...