Folders for me, sync'd to DropBox.

jay-h (7/10/2012)

---

SQLRNNR (7/10/2012)

---

If you can show that there is data to support a decision, it is more likely to be well received than one based on the experience, instinct,...

As long as you aren't causing problems downstream, as noted above, switching to simple is fine. There are people that do this for large data loads as well.

You might look...

Tim Mitchell (7/10/2012)

---

Prince Fielder looked good last night. I was surprised at the vitriol from the crowd toward Robinson Cano. Is it just him, or do they just...

+1

How do you decide it's a parent? If there's any match of a substring?

What if you add this row next: 5.46.200.1.462222.2.1.1.1.1.1.1.2

Are there two parents?

Jeff has clued you in. Tempdb works on temp objects, and you need to handle the peak. If you run out of space when you run queries, you don't have...

You need a query that tells you what is the new information from last week. I'd start by writing that query in T-SQL to get the changed data based on...

96 bit salt used here (12 bytes)

I'd concur with Alan on the disabling them. Easier to put them back if you have issues.

kevin77 (7/8/2012)

---

Steve, what does SqlServerCentral.com do to store passwords and authenticate users? If it's not a hash with a four or five byte salt, then I would gladly help...

Doctor Who 2 (7/9/2012)

---

Bottom line: if the agency is small enough, they don't want a DBA. They're not willing to pay that "DBA tax". They'll make anyone who...

Good points, and I won't argue with you on this. There are...

Jeff Moden (7/8/2012)

---

Excellent editorial, Steve! I wish I could give it a hundred stars because it really hits the nail on the head. There're too many people that...

SSL isn't too bad. Easy procedure in BOL for setting it up. Do not use a self signed cert. Get a real one.

Also, IPSec works well if you coordinate with...