peter-757102 (4/26/2012)

---

As usual...it depends :).

Mostly on when to use it, because if the nature of the problem you try to solve is...

ben.kimball (4/26/2012)

---

Oh wow!

I was just getting ready to say "Wait, WUT?" to your statement about being able to use more than 4000 characters in nvarchar(max). Somehow, I have always had...

ianp (4/26/2012)

---

Dynamic SQL opens the door to injection attacks unless you are very careful: something like using a function which has parameters to generate your SQL string which is then...

And what Gail said 🙂

What steps did you take when you moved the databases from 2000 to 2008 R2?

Set the compatibility to 10?

DBCC CHECKDB?

DBCC UPDATEUSAGE?

Rebuild Indexes/statistics?

GSquared (4/20/2012)

---

I tested two-step upserts vs Merge, and it was faster in most cases in my code. But it isn't always faster, and possibly not even faster the majority...

GSquared (4/19/2012)

---

Once the data is on the remote servers, I have various T-SQL jobs in SQL Agent that do all the more complex transformations and distribute the data to three...

Parameters for SSIS is one of my main reasons that I'm pushing my company to move to 2012 asap.

Good question, thanks!

Ummm?

SET DATEFORMAT DMY;

SELECT CONVERT(VARCHAR,GETDATE(),103)

Lynn Pettis (4/16/2012)

---

mtassin (4/16/2012)

---

GilaMonster (4/16/2012)

---

mtassin (4/16/2012)

---

So when I see you throw out a question like this... I'd expect that you'd expect a Sr DBA to work on these sorts of...

The CosmicTrickster (4/15/2012)

---

"Now, after you take a log backup, could you see a log file bigger than usual?"

No points for me. I perceive there being a difference between a "backup...

GilaMonster (4/16/2012)

---

No, I don't....

GilaMonster (4/13/2012)

---

mtassin (4/13/2012)

---

GilaMonster (4/12/2012)

---

Henrico Bekker (4/12/2012)

---

for your question on the ML pages -> Nasty....do they ever take a guess? 25, 125, 1025? do they ever mention BL mode for ML...

Eric M Russell (4/13/2012)

---

Henrico Bekker (4/12/2012)

---

I've done it as well... "how do you detach a Log Shipped tempdb that...

GilaMonster (4/12/2012)

---

Henrico Bekker (4/12/2012)

---

for your question on the ML pages -> Nasty....do they ever take a guess? 25, 125, 1025? do they ever mention BL mode for ML Pages? would...