What determines that the data is bad?

What are you using for reindexing? A maintenance plan?

There are a number of free maintenance solutions that log what they are doing.

They capture the indexes that are...

So, you have data that looks like this:

C828EB51-7A7B-40B1-A0CE-CF37559DC3F9

And you want to display this:

1168198242

Correct?

I guess my question is why do you need to display this data at all? Will the...

pwalter83 (12/8/2015)

---

Sean Lange (12/8/2015)

---

pwalter83 (12/8/2015)

---

Sean Lange (12/8/2015)

---

pwalter83 (12/8/2015)

---

ben.brugman (12/8/2015)

---

pwalter83 (12/8/2015)

Thanks for your suggestion. However, it still doesn't help with my basic requirement. I have to convert the time duration column...

DevOps is what's implemented to break down the communication barriers and silos that were created when Agile was implemented.

To me, it's only a new name for the things we...

Probably. If there is a single...

Honestly, download Ola Hallengren's scripts and use them. https://ola.hallengren.com/

The default structure is Server Name\Instance Name(if needed)\Database Name\Type(Full, diff, or log)

The one thing within the maintenance plans that seems to...

Wouldn't it be easier to snapshot the first installation multiple times?

For starters, you cannot use a case statement in a where clause in this manner.

There are more elegant solutions, but since this is for reporting, I would...

ZZartin (11/10/2015)

---

I think it's worth distinguishing between code that is scary and complex by necessity vs code that as the saying goes give a thousand monkeys a thousands years in...

Ed Wagner (11/6/2015)

---

Brandie Tarvin (11/6/2015)

---

xsevensinzx (11/6/2015)

---

Jeff Moden (11/5/2015)

---

Precisely. I couldn't have said it better myself. It's a bit like interviewing a mechanic. If they can't describe the...

All of them!

You actually have two different aspects of learning, the theory as well as the usage....

programme (11/5/2015)

---

Thank you very much.

Is the stairway link a good quick way to understand how to retrieve the data from the structures?

I would need to extract it by next week,...

Was it this link?

http://www.sqlservercentral.com/Forums/Topic527155-359-1.aspx#bm1733766

https://msdn.microsoft.com/en-US/library/ms179331(v=sql.100).aspx