Looks like I am going to get thrown into the deep end on some blocking issues with our main product. Having been working in relatively stable environments with little...

hreyes819 (9/22/2015)

---

You guys are using way too many foreign terms for me!!!! :crazy:

First of all, I referenced 5 columns in my original post (ha!, just figured out what OP means!...

Would someone with more knowledge of indexing please pop by this thread and add their expertise to the conversation.

Looking back at your original post and seeing that your databases reside on a SAN, I am thinking that extent fragmentation may not be as critical. I base this...

Okay, thank you all. I would still like a better explanation of the business use case from the OP since what has been provided so far is really vague...

Not sure I can answer your question, but I would like to point out that both DBCC SHOWCONTIG and DBCC DBREINDEX have been deprecated by Microsoft and will be removed...

I have a question for the respondents. Why am I the only one that actually created an itvf? The OP did ask for a function.

Sean Lange (9/22/2015)

---

Agreed. I have a feeling yours might win out because iirc the unpivot can get...

hreyes819 (9/22/2015)

---

Let me try this:

Col1 - has values that originate from table 1

Col2 - has values that originate from table 2*

Col3 - has values that originate from table 2*

Col4 -...

Sean, we will need to run some tests between our respective answers.

While waiting for a more detailed explanation I did throw the following together. This doesn't let you off the hook for a more detailed explanation. I'd like to...

hreyes819 (9/22/2015)

---

Hello -

New to SQL Server. Have a lot of MS Access experience and know how to do this task in Access vba but I have not been able...

Koen Verbeeck (9/22/2015)

---

WayneS (9/21/2015)

---

pietlinden (9/21/2015)

---

Eric,

I go to the user group meetings the vast majority of the time. Hard to argue with free training where you can ask questions. =)

Maybe my...

EasyBoy (9/21/2015)

---

I have run the query below:

use azADT

go

SELECT t.*

FROM sys.triggers t

WHERE

t.parent_id = 0 AND

(OBJECT_DEFINITION(t.object_id) LIKE '%amOperations%' OR

...

I am at a loss, what is DataStage?