Gopi S (12/20/2012)

---

Technically there is no difference between Unique Index and Unique Constraint. Even though syntax are different the effect is the same.

Unique Constraint creates Unique Index to maintain...

SQLRNNR (12/20/2012)

---

Stewart "Arturius" Campbell (12/20/2012)

---

IMHO, I think the correct answer here will be "It depends".

It depends on whether filtered indexes are utilised or not, etc.

However, it could be that...

Maybe, but my crystal ball is in the...

The second option will only work if the transaction involves only SQL Server related tasks, and they all must use the same connection manager (you need to set the RetainSameConnection...

Got it wrong because the question specified unique constraint instead of unique index.

And even then, the unique index in the sample code doesn't allow NULLs. The index is defined on...

Easy one, thanks.

dwain.c (12/18/2012)

---

As the holiday season rapidly approaches, I'd like to take a minute to wish everyone on this forum a Merry Christmas and very happy New Year.

The first anniversary of...

You can use the Import Column task to import the PDF files into the database.

Your date dimension should have a Year attribute.

Just put the year attribute on one axis and the measure on the other.

How is your cube designed? Normally when you have facts linked to your date dimension, you automatically get the YTD for the last year when you browse on the year...

Not sure what the question is, but it seems you're right, ADO.NET and the native client are more flexible.

Just a sidenote: the OLE DB provider is deprecated since the release...

I managed to write some code that doesn't use a cursor, so hooray for performance 🙂

SELECT

ID= tmp.ID

,Value= t3.[Value]

FROM

(SELECT t1.[ID]

,MaxID = MAX(t2.ID)

FROM[dbo].[Test] t1

INNER JOIN[dbo].[Test] t2 ON [t1].[ID] >=...

An easy query:

SELECT name

FROM DB1.sys.[tables] t

WHERE [type] = 'U'

INTERSECT

SELECT name

FROM DB2.sys.[tables] t

WHERE [type] = 'U';

It doesn't take the schema into account.

Easy one, thanks.

Clever spam?

http://www.sqlservercentral.com/Forums/Topic1393283-17-1.aspx#bm1397555