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

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