I for one would be super interested in seeing how you reverse engineer your indexes. I just went through this process and I have a feeling yours will be better...

ScottPletcher (6/6/2013)

---

Ask them::

Given table1 with columns "id" and "value", where each id has 1 to 3 values/rows in the table:

Describe the essentials of a single query (no subquery, CTE, etc.)...

DO NOT RUN THIS IN PRODUCTION!!!! It is slow and will consume massive amounts of resources. Get a copy to a dev server and run this there.

I used a VERY...

OK so next question is do you care if there are actually NULL values in the table or is it good enough...

bslchennai (6/6/2013)

---

Hi,

Please help me on finding the Null values on indexed columns from all tables in SQL Server.

I need a SQL query to find all the indexed columns which is...

I think you should be able to tweak the logic in this article to achieve what you are looking for.

http://www.sqlservercentral.com/articles/SQL+Puzzles/findinggapsinasequentialnumbersequence/2336/%5B/url%5D

Here is another article covering this topic.

http://www.sqlservercentral.com/articles/Advanced+Querying/anefficientsetbasedsolutionforislandsandgaps/1619/%5B/url%5D

Luis Cazares (6/6/2013)

---

Sean, you gave...

What you had was VERY close. Both Lynn and I had a solution that returned the values instead of IDs. I have to say that returning the IDs seems very...

Here is another:

select stuff(isnull(col1 + '/', '') + isnull(col2 + '/', ''), LEN(isnull(col1 + '/', '') + isnull(col2 + '/', '')), 1, '')

from Table_1

Dird (6/6/2013)

---

Sean Lange (6/6/2013)

---

You can always write it each time you need it but honestly that is really one of the points of a view in the first place, so...

Ed Wagner (6/6/2013)

---

Now that's a pretty cool idea I hadn't even considered. What's the performance like when compared to a physical table? I haven't tried it, but I'd...

Dird (6/6/2013)

---

Sean Lange (6/6/2013)

---

This gives you the best of both worlds. You have the advantage of a tally table, it is persistent in that it can be queried just like...

Ed Wagner (6/6/2013)

---

I've heard the tally table described as the "Swiss Army Knife of SQL" by more than one person on this site. It can solve a lot of...

Dird (6/6/2013)

---

Yes, according to...

This is still not consumable ddl. I should able to copy and paste your post into SSMS and...