The one-to-many is a more normalized view of the data and would be more 'correct'. But , you could argue that the CSV route could be right for your...

I may be splitting hairs but , Sqlbits is build as a technical launch event. I cant see similar wording on the dev connections site tho...

Investigate using "CROSS APPLY ( SELECT TOP(1)" , sounds like its what you need.

Try this..

http://www.quest.com/discovery-wizard-for-sql-server/

It hasnt been said explicity in this thread , so i will 🙂

Never run profiler live. Server...

One alternative

Select ProductId , ProductColorId ,ColorImage , ColorName

from tblTableA

Cross apply (Select top(1) ProductColorId , ColorImage , ColorName

...

Just as an aside , you may prefer to add the code to a constraint.

http://msdn.microsoft.com/en-us/library/ms179491.aspx

That way , if you have multiple ways data ( different procs, an ssis task or...

How much control do you have in this process ?

Adding columns such as you have described , really does sound like a design flaw to me.

If it were me ,...

xaeru (1/6/2012)

---

Dave Ballantyne (1/4/2012)

---

TBH , the problem solving skills that you would have to demonstrate would be an integral part of a DBA role.

If you are going for a DBA...

IMO , this sort of formatting should be dealt with at the client level,

use SSRS, excel or whatever to do this.

Hi,

there is no inbuilt functionality to do this. You have to setup some form of pro-active monitor.

Dave

Gail is one of the best, but what makes you think that her advice would be different from ours ?

Is you interview answer now going to be 'ill ask...

Then the best answer is :

"I dont know, but i would start to find out how to by........"

I dont know , is valid answer to any question. The 'but'...

TBH , the problem solving skills that you would have to demonstrate would be an integral part of a DBA role.

If you are going for a DBA role , then...

Dev (1/4/2012)

---

I am expecting few blob columns. It’s the only thing I can think of at the moment that can justify 10 lacs (1,000,000) records with 1 TB...