Eirikur Eiriksson (1/23/2016)

---

ChrisM@Work (1/22/2016)

---

Ed Wagner (1/22/2016)

---

Greg Edwards-268690 (1/21/2016)

---

Eirikur Eiriksson (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

Steve Jones - SSC Editor (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

It seems he has an elephant on the menu, and a 6...

Eirikur Eiriksson (1/23/2016)

---

Jeff Moden (1/22/2016)

---

Eirikur Eiriksson (1/22/2016)

---

The quick suggestion towards a solution posted earlier was just that, less than two minutes of coding to demonstrate a method for identifying groups...

In addition to what Jacob said, I'd leave the column defined as an Nvarchar(MAX) like Orlando suggested. Excel supports Unicode very well, so you should allow for the possibility....

Eirikur Eiriksson (1/23/2016)

---

Ed Wagner (1/23/2016)

---

jasona.work (1/22/2016)

---

So I just had an amusing moment...

I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was...

Eirikur Eiriksson (1/23/2016)

---

Ed Wagner (1/23/2016)

---

Piling on, I have to agree with the majority opinion here - this is a bad idea. If you're going to reuse IDs that are...

Jeff Moden (1/22/2016)

---

river1 (1/20/2016)

---

Hi,

I have a list of tables (several tables) and I would like to know their size.

Is there a way to know that using t-sql?

It will be easyer...

jasona.work (1/22/2016)

---

So I just had an amusing moment...

I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this morning as...

Piling on, I have to agree with the majority opinion here - this is a bad idea. If you're going to reuse IDs that are primary keys, this will...

Nice job, Jeff. I especially like the way you calculated the group number using two row number functions. Kind of reminiscent of something Itzik wrote once, but I...

Nice approach, Orlando. The term "as a data source" is pretty succinct.

Dr. Who, my guess is that if you put SQL Server on your resume, the reader of the...

Graphite

I'm not entirely sure of your exact requirements, but if you want to union together a set of tables and select everything that isn't in another set of tables, you...

Jeff Moden (1/22/2016)

---

SQL Server can't see that. You need to use the...

Sheep

Since that post was made in 2011, I honestly hope...