Brandie Tarvin (2/8/2011)

---

Michael Valentine Jones (2/8/2011)

---

I think some companies want a college degree just to make sure that you can read and write, since a high school diploma doesn’t seem...

adam spencer (2/8/2011)

---

Thanks all,

I got quickly what I needed( CONVERT(char(8), CreatedOn, 112) = '20110208' ) from the link from Dave before I saw the other reply. But I will...

I think some companies want a college degree just to make sure that you can read and write, since a high school diploma doesn’t seem to ensure that.

Another thing to consider is maintenance windows for the different applications for things like OS patching, etc.

Critical applications can have mutually exclusive maintenance windows so there is no good time...

Craig Farrell (2/7/2011)

---

Michael Valentine Jones (2/7/2011)

---

You say this:

"Senior DBA required for physical administration of very large databases (>1TB) in both OLTP and OLAP environments on Microsoft SQL Server. "

OLAP may...

That sounds like a very bad idea. You would lose all your...

You say this:

"Senior DBA required for physical administration of very large databases (>1TB) in both OLTP and OLAP environments on Microsoft SQL Server. "

OLAP may mean that you want someone...

The simple answer is that you are wrong. The difference is 21 days.

select

a.*,

DT = convert(datetime,replace(a.StrDt,'.',''))

from

( -- Test Data

select StrDt = '1/02/2011 12:03:41 p.m.'

union all

select StrDt = '1/02/2011 11:59:00 a.m.'

) a

Results:

StrDt ...

mw112009 (2/4/2011)

---

Michael Valentine Jones (2/4/2011)

---

You should probably take a step back and look at how much space the database files are using, and find the size of the individual tables...

You should probably take a step back and look at how much space the database files are using, and find the size of the individual tables in the database. ...

That sounds like a network problem, and...

Do they have a reason for not...

shahgols (2/1/2011)

---

Those options will not work for us. The process from the HP SAN side is as follows:

1. Somehow put the SQL Server databases on write-suspend mode (or...

You should look into using ROBOCOPY for this. It is made for mirroring or moving data from one folder to another. You can probably do all you want...