The first checkpoint will break things, as Gail noted. Doesn't matter if you have transactions.

To add to Perry, is you want to separate indexes, you need separate physical drives. Not separate drive letters or LUNs, but physical drives if you are looking for performance...

Didn't see the All Star game, but surprised with Verlander's highlights (or lack of) and no offense. A few great catches by the NL, so congrats to them.

This work? http://www.timeanddate.com/library/abbreviations/timezones/

A framework would be nice.

Looking to fill a hole, or a partial hole, in dealing with time zones in T-SQL.

GSquared (7/10/2012)

---

Should the code be sensitive to Daylight Time vs Standard Time (US), or should it rely on "EDT" vs "EST" in the input?

If sensitive without the input being modified,...

My advice, read the MS docs and lists of skills. If you know them, practice, if you don't, go learn them.

If you don't know much, then go get a book...

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)