Viewing 15 posts - 5,941 through 5,955 (of 11,676 total)
agnetha_11 (1/24/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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?"
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 24, 2013 at 12:43 am
You can use the REPLACE function to replace every space with nothing.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 24, 2013 at 12:32 am
Are you opening it with Excel?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 24, 2013 at 12:22 am
system243trd (1/22/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 23, 2013 at 12:49 am
Viewing 15 posts - 5,941 through 5,955 (of 11,676 total)