This is fantastic, thank you!

Grant Fritchey (3/15/2016)

---

Not enough info to go on. Trace, or extended events, is the way to go to capture the queries that are being called. The real question is, is...

Sean Lange (12/21/2015)

---

From your description of the situation I would add a few columns to a table. As described this would be a 1:1 relationship which is really kind of...

Phil Parkin (12/21/2015)

---

joshdbguy (12/21/2015)

---

I have some developers that want a bunch of fields added to an existing table (it's fairly new) including a GUID field (UUID). My recommendation was that...

This is perfect, thanks Sean.

I figured it out. Rookie mistake.

hlsc1983 (10/20/2015)

---

hi, I have come so far. Now i need to know something. In the Subjects table , I have columns for four types of marks(THPA, THET, PRPA, PRET) for...

sqld-_-ba (10/12/2015)

---

@josh, i meant to say if that TDE isn't implemented, they could recover it.

Commvault uses its own deduplication algo for databases, which massively reduces backup size, and I don't...

SSIS is a little slow, at least for me. In this kind of scenario I write to temp tables on my dev box or output the data to an excel...

sqld-_-ba (10/12/2015)

---

We have a large VMWare environment with HP SAN, and 2 datacenters - primary and DR, with SAN based replication between them.

We also backup databases to tape via Commvault...

Thanks all, I'll add another script for outer apply. I know the request exists so I expected to see text with the cross. Interesting issue that I've never seen before.

Better way.

I removed the expression task and just added expressions to two separate connectors. One for if the host is blank, one for if it's not.

Eirikur Eiriksson (9/29/2015)

---

joshdbguy (9/29/2015)

---

I'm working on a complicated SSIS package in SSDT 2012. One of the final tasks requires me to send files to FTP locations. Unfortunately, the table that...

GilaMonster (9/3/2015)

---

Don't guess. Diagnose and identify the exact problem. Guessing just wastes time.

Problem is by pulling the DB out of the AG, you'll have lost any information that was in...

Maybe you guys can help me identify the issue? So free space dropped to almost 0% on the data/log drive. AG was still running and t-logs wouldn't truncate. My guess...