Sharepoint actually stored the document itself inside the SQL Server; so, you have something of a problem; with a shrink, I wouldn't expect it to guarantee that every disk sector...

Different styles are different styles, neither good nor bad:

SELECT a.c1

,a.c2

,b.c1

FROM db.schema.tbla a

INNER JOIN db.schema.tbla b

ON b.col1 = a.col1

AND a.col2 = b.col2

I agree in part, and disagree in part.

I agree that readable code, with tags on End If and other blocks so current or future nesting is readable, is important.

I disagree...

gregory.anderson (6/11/2010)

---

I am trying to run a procedure that inserts records into a table that already has some foreign key constraints. In order to do the insert, I need to...

I didn't see any discussion of how frequently data was being added to the archive store; that's an absolutely critical point, especially if there comes to be a gap: quarterly...

If...

For character type strings you expect to be integers, there's also

ISNUMERIC(RTRIM(@value) + '.0e0')

UMG Developer (6/9/2010)

---

That sounds nice, but it...

Reasons I recommend:

A) Never have the first three letters of any stored user procedure be "sp_"

B) Always use three part naming, so you either execute:

Adventureworks.Person.(otherprefix)ReturnSomething

or

Master.dbo.(otherprefix)ReturnSomething

both of...

I'm afraid I'm not familiar with the tools used in the article, but on first glance it appears the following two general "hash to find differences" cautions are appropriate:

First, when...

Minor question:

If you have a week to get your DR site up, how much data are you allowed to lose? 10 minutes? An hour? A day? ...

Steve-3_5_7_9 (6/3/2010)

---

...and something else to check with the SAN admin. Other applications might be sharing your disks (luns) as the drives are just virtual anyway. Another application may...

There are other factors that play into TCO, including but not limited to:

How many servers may eventually need upgrading? It's not hard to get into hundreds of thousands...

Not a "good" option, but an option:

Try global ##temp tables with the entire procedure name and @@SPID placed in the table name... if you get really paranoid, an a 6+...

Always test with a complete, full dataset.

As far as highly complex test setups, the best way is something like a VMWare snapshot that includes the contents of RAM; that...