Viewing 15 posts - 5,941 through 5,955 (of 11,678 total)
agnetha_11 (1/24/2013)
January 24, 2013 at 1:04 pm
agnetha_11 (1/24/2013)
yes, I save it as a csv and then open using Excel.
GoVelo is right, it's just Excel butchering the format. Open it with a decent text editor, such...
January 24, 2013 at 8:45 am
Bhuvnesh (1/24/2013)
Koen Verbeeck (1/24/2013)
Do not disable foreign keysAny other reference ?
Maybe. I'm sure Google can help you out 😉
January 24, 2013 at 12:58 am
GPO (1/24/2013)
What a stupid question. How can you possibly answer it with the limited details provided?
I first thought it was a joke 😀
"Pffft, who uses XML anyway?"
January 24, 2013 at 12:53 am
debanjan.ray (1/24/2013)
That table contains only 1lac rows.Table PK:
Table_sr_key, table_eff_strt_dt
Table FK(10 Fks like same structure):
PRD_SR_KEY, EFF_STRT_DT
REFERENCES Product (PRD_SR_KEY, EFF_STRT_DT)
Table is refernced by more than 20 table.
This is primarily a...
January 24, 2013 at 12:43 am
You can use the REPLACE function to replace every space with nothing.
January 24, 2013 at 12:34 am
You mean Report Manager? It's normal that it takes a while to load the site for the first time.
Either you see that as "coffee-time", or you can solve it using...
January 24, 2013 at 12:32 am
Are you opening it with Excel?
January 24, 2013 at 12:28 am
Maybe you should create a job to automatically update your statistics, since they're clearly out of date.
January 24, 2013 at 12:22 am
system243trd (1/22/2013)
January 23, 2013 at 11:57 pm
I'd like to see the performance of the XML solution.
Also, I would think the structure of your website is known, so a relational model is preferred.
Curious to see the debate...
January 23, 2013 at 11:44 pm
Greg Edwards-268690 (1/23/2013)
Right Click on your Project in Solution Explorer
4th from the bottom, Delete Dataset Cache...
January 23, 2013 at 1:10 pm
WayneS (1/23/2013)
Koen, I like your #SQLFamily icon in your signature. You ought to put it somewhere and tweet it so others can use it also.
Actually, it's not mine. The SQL...
January 23, 2013 at 1:09 pm
Make sure there are no filters in the data source view and that the dimension usage mapping is done correctly. Also make sure there are no slicers/filters in the browser.
January 23, 2013 at 6:19 am
Great question thanks. I vaguely remember seeing a similar QotD once, but it's quite some time ago.
January 23, 2013 at 12:49 am
Viewing 15 posts - 5,941 through 5,955 (of 11,678 total)