Looks like an error from whatever you are calling with xp_cmdshell. Are you having it call an exe file or something like that?

You could split by "up to punctuation" for LastName, First type formats, splitting anything before the punctuation (either comma or semicolon) as the last name. That would be Left(FullName,...

That table contains the results of including query data in an e-mail. All it takes is a few big datasets and you'll get a HUGE table.

There's an article here...

Are you familiar with reading execution plans? That's where you'll need to start.

If you aren't familiar with them:

In Management Studio, click the option in the toolbar for "Include Actual...

Jeff Moden (3/14/2012)

---

anthony.green (3/14/2012)

---

Jeff Moden (3/13/2012)

---

anthony.green (3/12/2012)

---

you might want to take a look at full text indexing and the contains function then, otherwise you will be wrapping the variable in...

Jeff Moden (3/13/2012)

---

anthony.green (3/12/2012)

---

you might want to take a look at full text indexing and the contains function then, otherwise you will be wrapping the variable in a multiple of...

Grant Fritchey (3/15/2012)

---

Jack Corbett (3/15/2012)

---

herladygeekedness (3/15/2012)

---

I have also lost jobs on terminology as I am also self-taught. I'm more a data analyst/programmer than DBA but around SQL...

L' Eomot Inversé (3/15/2012)

---

herladygeekedness (3/15/2012)

---

I have also lost jobs on terminology as I am also self-taught. I'm more a data analyst/programmer than DBA but around SQL since 6.5 and...

The max memory setting is just for the buffer pool. If SQL Server needs more resources for other things, it will use it.

Do your databases have any CLR objects...

Jack Corbett (3/15/2012)

---

herladygeekedness (3/15/2012)

---

I have also lost jobs on terminology as I am also self-taught. I'm more a data analyst/programmer than DBA but around SQL since 6.5...

Stefan Krzywicki (3/15/2012)

---

GabyYYZ (3/15/2012)

---

Is it too much to ask that a DBA candidate, who says he has 10 years experience with SQL Server, know what a primary key is, or...

GabyYYZ (3/15/2012)

---

Is it too much to ask that a DBA candidate, who says he has 10 years experience with SQL Server, know what a primary key is, or know the...

Any week where I feel I'm kicking life's butt more than it's kicking mine. Purely subjective, and it works for me.

David in .AU (3/14/2012)

---

I wouldn't use ATM's as an example as I think you will find that in this day and age, all ATM transactions are live (both debit and...

Gianluca Sartori (3/13/2012)

---

I don't know who you're talking about. 😉

No, seriously, you'd better ignore him.

A wise man once told me that the only person in the world you can change...