Cool! where do we pick up our personalized autographed copies of the book?

Sounds like a good read as long as it's not a horror story about a botched upgrade gone...

http://omnibuzz-sql.blogspot.com/2006/06/concatenate-values-in-column-in-sql.html

Bottom of...

Gail - as to your test - I will try to dig out and use the XML data() trick, we'll let Jeff come up with the "pure" T-SQL trick, and...

New results with the CORRECT query for the phone extraction challenge. The "no 3rd" took a chunk out of it (as expected), although the runs just seem slower today...

K. Brian Kelley (11/15/2007)

---

Megha Yadav (11/15/2007)

---

Yes I do understand the importance of the foreign keys for maintaining the integrity ................but what the question is that if the system is working...

Jeff Moden (11/14/2007)

---

Ok... I might have just missed in in your code and because of the rowcount you have...

What results are you hoping to see if you don't execute the query?

It's alright - at least we're comparing...

GilaMonster (11/14/2007)

---

You said it. 😉

What I'll do is grab one of the string functions that...

SQL Noob (11/14/2007)

---

only in an ideal world

in the real world CSR reps and sales people put down whatever the slang name is for something or they put in trouble tickets...

Jeff Moden (11/13/2007)

---

Heh... they ALL say that until a job takes 8 or 10 hours to fail 😛

I've found that the estimated execution plan lies... according to both...

FWIW - blackberry's don't do pools either....:blush:

One thing I can't seem to understand in these cases is the total lack of contingency planning. Having worked in healthcare for a...

The big question is - is it growing bigger at a regular pace, or did something "blow it up"? A bad update process, out of control INSERT, etc... could...

Isn't that just reengineering a foreign key constraint? Wouldn't the built-in version do just as well?

Phone test - Phase 2 (redaction)

The CLR code is:

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Imports System.Text.RegularExpressions

Partial Public Class UserDefinedFunctions

_

Public Shared Function...