MyDoggieJessie (4/2/2012)

---

Hyperbac intercepts the data stream while it's backing up, correct? It's done on the fly which results in considerable time being saved during a back, the same thing...

Grant Fritchey (4/2/2012)

---

Lynn Pettis (4/2/2012)

---

In SQL Server 2008 and newer when running...

In SQL Server 2008 and newer when running Enterprise Edition, I would...

sunny.tjk (4/2/2012)

---

Lynn, I totally accept what you said "If you attempted to add a second null value to a column with a unique constraint, it would no longer be unique."....

Rod at work (4/2/2012)

---

tom.wauters (4/2/2012)

---

I would suggest to migrate to SQL Server 2008 R2.

First of all, your databases will be in the newer environment, which has lots of improvements compared...

Okay, nevermind what I was thinking. You posted this in a SQL Server 2008 forum so I was going to make a SQL Server 2008 suggestion.

Edit: And I...

luissantos (4/2/2012)

---

Hello comunity

I see a TSQL script to make UPDATE on large table :

select

'update fl set radicaltipoemp='+convert(varchar,'1')+' from fl where fl.flstamp='''+fl.flstamp+''''

from fl (nolock)

where fl.radicaltipoemp = 0

i think that the...

Oracle <> SQL Server

Best way to put that one. Also, currently in Oracle an empty string ('') is treated as null while in SQL Server it is not.

What edition of SQL Server 2008 are you running?

A primary key can not have a null value. However, for a unique constraint, a single null value is unique. This is why a single null is allowed....

Glad to help.

And no, there is no button to mark the thread as answered. The thread will stay open and others may come along and offer other suggestions or...

Conficker (4/2/2012)

---

DECLARE @Day INT

SET @Day = datePart(dd,getDate())

DECLARE @i INT

SET @i = 0

CREATE TABLE #temp1

(para VARCHAR(50))

WHILE (@i<20)

BEGIN

IF @DAY < 21

BEGIN

INSERT INTO #temp1

SELECTCONVERT(VARCHAR(25),((dateAdd(mm,-(@i+0),getDate() ) - datePart(d,getDate()))+21),103)+

' - '+

CONVERT(VARCHAR(25),((dateAdd(mm,-(@i+1),getDate() ) - datePart(d,getDate()))+20),103)

END

ELSE...

vsql (4/2/2012)

---

Hello all,

I am planning to write the MSBI certification please sujjest me some good source of material,...

I'd want more information from the vendor on why the advise against the SQL Native client.

For a SQL based solution, you can try this, but please note that it won't work for billing dates that start on the 29th, 30th, or 31st of the month.

declare...