christophe.bernard 47659 (2/16/2016)

---

Hello ben.brugman ,Sean Lange ,Sergiy, Ed Wagner

After talking with my responsible of project and explain the difficult of this problem we have decide to migrate our table.

And stop...

Jeff Moden (2/15/2016)

---

Orlando Colamatteo (2/15/2016)

---

For someone who has made so much hay off helping others slay RBAR processing, I don't blame you one iota for not wanting to review something...

I have to say that I don't know...

If you're looking for a good reference for many common date functions similar to your requirement, Lynn Pettis has a great post at http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/.

Isaiah

Jeff Moden (2/12/2016)

---

Ed Wagner (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

Grumpy DBA (2/12/2016)

---

We will be transitioning to "mountain time". Wake up, breakfast, try to get first chair, snowboard/ski until hungry, grab a quick...

Jeff Moden (2/15/2016)

---

Maintenance plans will rebuild ALL the indexes... even...

The biggest gain that full text indexing gives you is synonyms and similar functionality. As others have said, the LIKE match is the most flexible, but that leading wildcard...

Like Sean said, setting up a home lab is the best way to play and learn. If you screw things up, you won't lose any corporate data and you...

Add me to that list. Backups should always be first. Then security - hopefully disable the sa login. If not, work to get it done.

The indexing and...

I've done it successfully with a linked server. I installed the Oracle client on the server. Also, I was advised to use the Oracle driver for connectivity instead...

Steve Jones - SSC Editor (2/12/2016)

---

I've started to get in the habit of shutting off email and computer time on the weekends, just to get away from work, but also...

Lynn Pettis (2/12/2016)

---

Grumpy DBA (2/12/2016)

---

We will be transitioning to "mountain time". Wake up, breakfast, try to get first chair, snowboard/ski until hungry, grab a quick bite, snowboard/ski until the...

Small

Lynn Pettis (2/12/2016)

---

Ed Wagner (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

Ed Wagner (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

I think I know (now) which one you were talking about. I gave them my shot in the dark...