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...

This has gone a little sideways, but in addition to blatant harassment, like licking someone's shoulder, I was hoping to drive home the point that any unwanted advances, especially repeated...

LOL, but from personal...

Brandie Tarvin (9/7/2012)

---

All,

Tomorrow's SQL Saturday post is going to be about SQL Server resources. I'm including things like this forum, Tek-Tips, a few blogs, Twitter hashtags.

Does anyone have recommendations for...

Todd.Everett (9/7/2012)

---

Now suddenly we have two key uses for our laptops - social media and cloud storage - that we can't live without. Many employers block both. ...

How much longer did it take? Is the backup larger? Can you determine if there was other activity at the time of the backup?

Usually if a backup takes more time,...

Scott D. Jacobson (9/6/2012)

---

John Hanrahan (9/6/2012)

---

Steve,

I'm surprised no one mentioned agile development practices. It seems like agile is another word for minimal testing. That's fine when the consequences...

cdonlan 18448 (9/6/2012)

---

Defense.

https://www.torproject.org/

I played around with the Vidalia component a few years back (a little clunky but what do you expect?) and think it's a fascinating project. Others may find...