Viewing 15 posts - 7,396 through 7,410 (of 11,676 total)
Raunak Jhawar (4/2/2012)
There should really be nothing as "stage database". It should be stage tables.
And if you put the staging tables in a database you have a ...?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 11:37 pm
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 11:35 pm
Yes, it can be done in SQL.
Check out "dynamic SQL" on Google.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 11:29 pm
SSIS: Custom Logging Using Event Handlers
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 11:26 pm
+1 for the licensing
How to get your cube to the other server:
Analysis Services Deployment Methods
(this was the first result for the google search deploy ssas)
Or just deploy from the BIDS...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 11:25 pm
EXEC sp_MSForEachTable 'SELECT X FROM ?'
This will only work if the column X is in all the tables of the current database.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 11:21 pm
Great question, thanks. I never use this datatype though.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 11:18 pm
Glad you found the issue, and thanks for posting back!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 3:30 pm
SQL_Surfer (4/4/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 6:30 am
Thanks for posting back the solution.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 5:12 am
Does the error persist if you drop and recreate the task?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 5:11 am
SQLRNNR (4/3/2012)
This is a feature i will have to learn.
+1
I have my beta exam of developing sql 2012 data warehouses this week, and MDS is on the skills list. So...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 5:08 am
Gazareth (4/4/2012)
Ah, thought MDS was only introduced with SQL 2012!
Nope! It existed since SQL 2008 (R2?). Everybody just ignored it 😀
Surprised this QotD didn't hit 100% correct answer, with the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 5:07 am
Evil Kraig F (4/3/2012)
NuNn DaddY (4/3/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 5:04 am
Since these extra values are only inserted for the first occurence of a new value in the first column, you'll need a script component. In the script, you'll keep track...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2012 at 4:59 am
Viewing 15 posts - 7,396 through 7,410 (of 11,676 total)