Evil Kraig F (12/13/2011)

---

GSquared (12/13/2011)

---

On the original point, I don't think you'll end up with a significant advantage using SSIS over a stored procedure unless you're setting up incremental loading....

DataLength and Len can give very different results. Trailing spaces, Unicode strings, possibly a few other things, will cause those to return different numbers.

SQL Kiwi (12/13/2011)

---

DATALENGTH is a safer bet than LEN, due to the problem with trailing spaces.

DECLARE @String VARCHAR(100) = 'Physician->Scotland->Scotland North->NOS431 Core Medical Training ';

SELECT LEFT(@String, LEN(@String) - CHARINDEX('>-', REVERSE(@String))-1)

SELECT...

GPO (12/14/2011)

---

Under what circumstances would you use one of these on-the-fly solutions as opposed to a permanent calendar table? I'm probably missing something here - it's not unusual - but...

Kevin Mao-243787 (12/13/2011)

---

Role of DBAs

Four roles are listed in first Chapter of Professional Microsfot SQL Server 2008 Administration: Production DBA,Development DBA, Business Intelligence DBA & Hybrid DBA. For smaller organzations,...

And the only cure is beingectomy - in other words, you have to be amputated from all...

jcrawf02 (12/13/2011)

---

Favorite email exchange of the day (after the other party read the recursive CTE date article in the newsletter, and I pointed them to Jeff's comment/article in the discussion):

From:...

The exits needing commits depends on what you're trying to do.

If a condition calls for rolling back on a failure, then raising an error, cutting over to the Catch block,...

Then what you probably want is Try Catch and Raiserror, like your proposed solution.

Join the table to itself on whatever column makes them match, User_ID in this case, and on the intersecting program IDs. That'll give you a count you can use.

How are the Return statements being used? Are they returning error codes, or are they just aborting the procedure so no further code is run in it?

I generally avoid...

As mentioned, it's not "standard terminology". I've usually heard it in reference to synchronizing schemas between servers, usually either Dev -> Test or Test -> QA or QA ->...

Kraig, RAID-1 uses mirroring. It can survive a single drive failure. Can't survive both drives failing, but neither can RAID-5. Multi-drive failure survival requires RAID-6, or RAID-51...

First, your script doesn't produce anything useful even if it doesn't truncate, because of missing single-quotes around the param value, and because of not having an actual executable script assigned...

Ray Cacciatore (12/13/2011)

---

Is there a tool out there that can take me to the definition (SQL) of an object by right-clicking it in SSMS and selection Go To Definition? I...