Bru Medishetty (11/17/2009)

---

You can start with a Weekly Full backup and daily Differential backup (if needed twice a day).

Monitor the Database growth over a few weeks period, and then decide...

Good catch, yes that should be a left outer join. Not enough "coffee" this morning. Getting into work at 6:00 AM local time starting this week and obviously...

Actually, the seconds are...

cengland0 (11/17/2009)

---

Lynn, you have a valid point but if you were to show those times to a client, they would only see the output not the representation. So, for...

You may want to try this, and you may also want to be sure that you have an index on each of the table on the column email.

insert into Total(

...

Also, I think bitbucket resides somewhere on the east coast of the USA, not in the UK.

Everyone is looking at the values, yes, they are "different", but both...

Okay, how do you do that one? I'd like to add it to my "toolbox" right along with lmgtfy.

I actually answered true, and here is why, if you run this:

select getdate(), getutcdate()

you may get a result like this:

2009-11-17 06:16:57.527 2009-11-17 13:16:57.527

They appear different, but are actually the same....

Looks to me like you did a good job of explaiining group access. Let's see what the OP says...

You could also do this:

select left(convert(varchar, getdate(), 108),5)

Never mind this. Again, brain dead for a bit, misread the original query.

Why do you think that is rediculous? It just means that the data has many redundant bit patterns that allow it to be highly compressed.

Because there aren't any system "tables". You will find those under system views now. Starting with SQL Server 2005 you can no longer update system tables directly.

GilaMonster (11/16/2009)

---

I find that condescending and insulting. I've used it once only, after someone repeatedly demonstrated that they were not going to search themselves,...

CirquedeSQLeil (11/16/2009)

---

Lynn Pettis (11/16/2009)

---

Digs posted a project spec here on ssc that he posted on GetAFreelancer.com, so for S & G's (plus I am trying to earn some extra cash...