Yep. They've been logging in under the sysadmin role for a long time. It's only when I change to anything...

Hi,

I was working on a reply for you; I wanted to test both ways. In this...

Hi,

I mean that any server role that is not...

Jeff Moden (2/2/2014)

---

BWAAA-HAAAA!!!!! I know...

In case anyone stumbles upon this old thread, these two Itzik Ben-Gan videos are awesome:

Video 1

Video 2

They cover a number of ways to use the APPLY operators, and some indexing...

Grant Fritchey (2/27/2014)

---

sqldriver (2/27/2014)

---

Grant Fritchey (2/27/2014)

---

Just remember that any of the conversions can prevent the use of statistics which makes the possibilities of scans on the data much higher.

Best practice...

Grant Fritchey (2/27/2014)

---

Just remember that any of the conversions can prevent the use of statistics which makes the possibilities of scans on the data much higher.

Best practice is, like to...

SELECT *

FROM bible

WHERE verse LIKE '%begat%'

Who would ever do something crazy like that? 😉

Next thing I know you'll be making dodecahedron joins to a substring.

Luis Cazares (2/21/2014)

---

sqldriver (2/21/2014)

---

Luis Cazares (2/19/2014)

---

sql2k8 (2/19/2014)

---

I have to rewrite the code in another language. This correlated subquery is not working in the another language. So i am trying to...

Luis Cazares (2/19/2014)

---

sql2k8 (2/19/2014)

---

I have to rewrite the code in another language. This correlated subquery is not working in the another language. So i am trying to rewrite the code...

Jeff Moden (2/18/2014)

---

sqldriver (2/18/2014)

---

Jeff Moden (2/18/2014)

---

I guess I don't understand the need for any preprocessing here. Just load the each group of files into a working table (heaps, to...

Jeff Moden (2/18/2014)

---

I guess I don't understand the need for any preprocessing here. Just load the each group of files into a working table (heaps, to be sure) and...

Evil Kraig F (2/18/2014)

---

sqldriver (2/18/2014)

---

I appreciate that SSIS is a good tool for this situation, but I'm in kind of a weird environment where it's not accessible, on top of...

I appreciate that SSIS is a good tool for this situation, but I'm in kind of a weird environment where it's not accessible, on top of me not liking it,...