If you can CLR, this works well: https://nclsqlclrfile.codeplex.com/[/url]

Rich

Since no one mentioned this, I'll jump in: think seriously about restructuring your database table and application to provide and store first name separately from last name. You don't...

Steve-3_5_7_9 (6/2/2015)

---

Try and stay away from the wizards and gui as much as you can while you are learning. Learn the TSQL commands and syntax for performing backup, restores,...

Great question. Note that the outcome is dependent on the setting of XACT_ABORT. The default is OFF, but if set to ON, the transaction will rollback, and executing...

So close. I replied 6. Missed REAL = FLOAT(10) = FLOAT(24).

Rich

I created an Agent job based on the code I found here:

http://strictlysql.blogspot.com/2011/01/finding-last-database-growth-date-and.html

It runs slowly, and b/c it's querying the trace file, I don't think you'd want this running constantly. ...

SQLRNNR (4/28/2015)

---

rmechaber (4/28/2015)

---

Well, I got...

Well, I got today's right...

Eric M Russell (4/28/2015)

---

One problem you will encounter when digging into root causes is that your search will often need to cross departmental or even oganizational boundaries, especially in the...

Got it right.

Feel like a chump.

Been writing queries like this using a CTE to return line-item subtotals, then a final query to return those plus the per-row, fraction-of-the-grand-total percentages.

Kathi, you...

bdenning (4/22/2015)

---

I in no way stated "don't read this article" but instead it was a soft plea to SQL Server Central to not reference such articles. Doing so increases...

I feel like I'm on a Fark.com comment thread and should be making a snarky comment about making popcorn.

Are we really still having this conversation in 2015 about business logic,...

I'm late to this conversation, but I've appreciated the ideas from different quarters. Myself, I've been a slow adopter of CLR, but I've gotten to the point where (a)...

Nice question, thank you.

Some additional explanation from BOL (https://msdn.microsoft.com/en-us/library/ms175523%28v=sql.105%29.aspx):

If a run-time statement error (such as a constraint violation) occurs in a batch, the default behavior in the Database...

TomThomson (11/6/2014)

---

Good question.

It raises an issue about the quality of this wizard: why on earth doesn't it read metadata for the target table and set lengths accordingly? It...