Can you open up the error log and get the rest of the error message?

Parse the components of the address, using a standard string parsing routine. Then if the second component matches your town setting, replace just that component, then rebuild the string...

Index scans can actually be the exact thing that makes a query fast, if you're looking for a range of information from multiple rows.

If, for example, you have a table...

Why would you use sp_OACreate, et al, on SQL 2005? Build a .NET object, and call it via the whole CLR Stored Procedure functionality. It'll work better, and...

As per its documentation, Try Catch only gets the error that passes control to the Catch block. The only way to do what you want is to do it...

You can set up exception handling in SSIS. Set the properties of the data transformation object to include a routing for bad rows. SSIS can dump them into...

Start with an online search for "t-sql best practices" and "pl/sql best practices". You'll find dozen or hundreds of good articles on the subjects.

What edition of SQL Server are you running on? (Express, Workgroup, Standard, Enterprise/Developer)

The best way to prepare for the unplannable is to educate yourself and practice high-stress things.

Volunteer to help out in real disasters, like Haiti. After you've had to deal...

You'd either need to use dynamic SQL, or a CLR function. Dynamic SQL will be easier and won't require opening up security rules in the database.

Would look something like...

I'd probably go with the trigger option.

If you have a job, and it runs every ten minutes, what happens if you get 100 errors 1 second after the job runs?...

Currently, that's probably me! I...

Here's an interesting one. This is the list of skills someone wants for their "DBA":

Must have advanced proficiency and extensive knowledge of web development and design technologies, and publishing...

GilaMonster (9/1/2010)

---

Grant Fritchey (9/1/2010)

---

If your contact email looked like mine, it was simultaneously a**-kissing and completely generic. The guy waxed prolific about how great I am and how qualified without...

Grant Fritchey (9/1/2010)

---

GSquared (9/1/2010)

---

Connections via SSC and LinkedIn have got my phone ringing off the hook (well, the phone isn't old enough to do that literally, but you get the...