mota7128 (5/17/2012)

---

Hi Guys,

I am using SQL 2008 R2, and I do thank all of you guys, REALLY love you.

Much thanks for you "Lynn Pettis", your solution is awesome for me...

Update:

DECLARE @StartDate DATETIME,

@EndDate DATETIME;

SET @StartDate = '2012-05-18 12:07:00.000'; --GETDATE();

SET @EndDate = '2012-05-21 15:40:34.497' ; -- GETDATE() + 1;

DECLARE @ElapsedTime INT; --...

melissa.dougherty (5/17/2012)

---

I will need to meet with higher ups to determine amount of exceptable data loss.... we are running mirroring in a synchronous mode, we do not use the Witness.

I...

melissa.dougherty (5/17/2012)

---

I will need to meet with higher ups to determine amount of exceptable data loss.... we are running mirroring in a synchronous mode, we do not use the Witness.

I...

Are you using syncronous or asyncronous mirroring to your off-site database?

melissa.dougherty (5/17/2012)

---

We really don't have a budget.... we would need to justify the need and see if they will approve. We need to recover within an 8 hour window,...

L' Eomot Inversé (5/17/2012)

---

Revenant (5/17/2012)

---

Stefan Krzywicki (5/17/2012)

---

Thanks to new data mining abilities I think I read that they have the ability, to 75% or 90% or something like that, to...

Just remember that using a global tempory table has...

But it is fun. You haven't been around for a while and getting into a conversation over nothing is fun.

Look with eye:

GLDEFRLS

INNER JOIN accropts AC

ON AC.AccAccrOption = EM.EacAccrOption

You are...

Just one case:

case when (departmentnumber in (091111,011111)) then 'Emergency'

when (departmentnumber in (013121)) then 'NICU'

else ''

end as Department

melissa.dougherty (5/17/2012)

---

We are looking for the best solution for high availability and disaster recovery. We have are main production SQL Server databases and we want to replication to two other...

Perhaps this:

set @sql = 'select count(1), sa from deviationbycategoryandsa where [' + @Category + '] = 1 and sa = ' + '''' + @sa + '''' + ' group...

RBarryYoung (5/17/2012)

---

Lynn Pettis (5/17/2012)

---

You find it used off-shore, particularly India: http://oald8.oxfordlearnersdictionaries.com/dictionary/upgradation

We now have, English,...

Truth? Clean up the data. If the data has leading and trailing spaces and these need to be removed for a query, perhaps retaining them in the data...