Gary Varga (9/10/2013)

---

JLMayes (9/10/2013)

---

As an outsider (non-DBA), I can say that my experience over the past 20 years has been that DBAs and the DBA world is as close to...

KWymore (9/10/2013)

---

mtassin (9/10/2013)

---

I don't know why...

pancakes

afternoon tea

Koen Verbeeck (9/10/2013)

---

jasona.work (9/10/2013)

---

Koen Verbeeck (9/10/2013)

---

Grant Fritchey (9/10/2013)

---

L' Eomot Inversé (9/9/2013)

---

Grant Fritchey (9/9/2013)

---

Not sure anyone noticed, but we passed the three year anniversary of the thread. Thank the gods the...

Nice question that illustrates an interesting undocumented feature.

Back in May Microsoft said this was...

Steve Jones - SSC Editor (9/9/2013)

---

A poor question, and incorrect answers. My apologies. I know I ran the code, but I'm guessing I didn't examine the answers closely enough.

I have...

Grant Fritchey (9/9/2013)

---

Not sure anyone noticed, but we passed the three year anniversary of the thread. Thank the gods the terrible twos are over. Our little... thread... is a toddler...

No, if you are on 2005 you need something more complicated - as batgirl suggested,

convert(datetime, datediff(0, DD, getdate()))...

Six days on it's still at 73%. I think it'll stay there. Which...

The conversion to INT may be part of the problem. But Convert(datetime, Convert(int, GetDate())) should deliver midnight tonight, not midnight this morning, so it's surprising you are getting any...

ScottPletcher (9/9/2013)

---

You can get the result you need: the specific method depends on specifically what you need to do. If you can provide sample values and the desired results,...

Steve Jones - SSC Editor (9/9/2013)

---

No idea. It might be, but I'm concerned with the point made of public (law enforcement) cameras forced on private property. When might some "filter"...

hisakimatama (9/9/2013)

---

I agree that the NSA's conduct and invasion of privacy are quite quesionable, but as long as we're only given candidates that are compliant with them in our polls,...

dtevlin 55845 (9/9/2013)

---

You do need encryption for your business data, but the group you need to be wary of is China and Russia. They have a long history of economic...