Scott Arendt (8/14/2012)

---

I didn't suggest to accept the job, just to let the interview to finish. You should try to speak with some of the employees or find some references...

Did you check on any logs from SQL backup, and not just the job?

If the product has expired, it should throw an error, but I'm not sure if this is...

I'd lean on the CLR as well. It is tough, but there are good examples around: http://www.simple-talk.com/sql/t-sql-programming/clr-assembly-regex-functions-for-sql-server-by-example/

Jeff Moden (9/10/2012)

---

All this talk about being multi-talented on a large number of platforms is interesting because it's actually contrary to what my personal experience has been. It wasn't...

Congrats, Meredith and well deserved.

capn.hector (9/10/2012)

---

quick question to the threadzians, is any one else going to be at #sqlsat154 in St Louis? wondering if its going to be a lonely first professional event...

Magic number for...

Two finger click on the trackpad.

GilaMonster (9/8/2012)

---

Couple years ago I had a car stall and refuse to restart on a highway (was traffic jam, so moving very slowly). After I figured that the car was...

The way to do this is with dynamic SQL.

declare @c varchar(500)

select @c = 'Select * from MyTable where '

...

The error says it all. Replication is enabled, so you can't rename the database.

You won't get a deadlock since you are only accessing one resource. What will happen is that one execution might block the next one.

You can experiment with the size of...

Thanks

I've tended to use copies of production, but sometimes obfuscated for security purposes.

My company (Red Gate Software) makes a data generator that can build data for you, in all shapes...

Three is really nice. I tend to...