Luke L (10/26/2010)

---

Stefan Krzywicki (10/26/2010)

---

What did I do wrong here?

Was I not polite enough in my request for clarification on several of Mr. Celko's points? I know I've seen him...

What did I do wrong here?

Was I not polite enough in my request for clarification on several of Mr. Celko's points? I know I've seen him return to posts to...

Michael Valentine Jones (10/25/2010)

---

If you are use the new DATETIME2 data types, you can use SYSDATETIME or SYSUTCDATETIME to get a more precise value. There is no real penalty...

Derrick Smith (10/25/2010)

---

Just for the record, getdate() and current_timestamp perform the exact same operation on the back end, so there is no data/performance difference at all between them. The only...

bitbucket-25253 (10/25/2010)

---

In the manner of a general reply, assuming you may wish to have a "bag of date tips and all, try this link, and you can add the T-SQL...

Why do you say "Need"?...

Jack Corbett (10/25/2010)

---

Stefan Krzywicki (10/25/2010)

---

Jack Corbett (10/25/2010)

---

So I got an email from a friend this morning asking for some SQL help. They are running a system that used to...

Grant Fritchey (10/25/2010)

---

Jack Corbett (10/25/2010)

---

So I got an email from a friend this morning asking for some SQL help. They are running a system that used to have multiple...

Brandie Tarvin (10/25/2010)

---

I've located a lot of threads on the differences between regular 2k8 and 2k8 R2. What I haven't found is whether or not Microsoft will be putting out...

Jack Corbett (10/25/2010)

---

So I got an email from a friend this morning asking for some SQL help. They are running a system that used to have multiple databases per...

I would love...

george sibbald (10/24/2010)

---

Stefan Krzywicki (10/24/2010)

---

george sibbald (10/24/2010)

---

I'm interested, why use SSIS for backup plans? That does seem an unnecessary extra layer to me. I presume you mean outside of the...

george sibbald (10/24/2010)

---

I'm interested, why use SSIS for backup plans? That does seem an unnecessary extra layer to me. I presume you mean outside of the maintenance plans.

Whats the...

Jeff Moden (10/24/2010)

---

Wow... thanks for the insight on SSIS, folks. I've mostly resisted spending any decent amount of time on it because of what I've seen. Thanks to...

ALZDBA (10/23/2010)

---

With regards to SSIS, I always advise a team of programmers to learn it, just like they would learn any other programing engine.

It is very powerful, but there...