Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xhostx
Constraint Violating Yak Guru
277 Posts |
 Posted - 2012-09-14 : 14:12:24
|
| Hi All,I just thought of developing my skills of BI Development and Analytics and I need to some guidance to kick off. Does anyone please have a study case/a project that involve the SQLServer in combination with Business intelligence or analytics?Any Sites that involve both SQL development/Data Sources for analysis or study cases will very appreciated.Thanks.--------------------------Joins are what RDBMS's do for a living |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-09-14 : 15:28:59
|
| Thanks Visakh :)!By the way, I'm trying to attach AdventureWorks Datawarehouse. How many files should I have one (mdf) or 2 files (mdf and log).A link to a FULL AdvantureWorks DW will be very helpfull.Thanks again--------------------------Joins are what RDBMS's do for a living |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-09-14 : 15:34:20
|
| You can attach the MDF by itself, if that's all you have, but best practice is to attach both MDF and LDF files.Microsoft sample databases are located here: http://msftdbprodsamples.codeplex.com/ |
|
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-09-14 : 15:47:29
|
| Hi Thanks you too.This is what I just did: I downloaded the just .mdf. Romoved the log file from the list which show autimatically while you are trying to attache the DW. This will avoid triggering an an error. Click OK. then the log file will be automatically created.--------------------------Joins are what RDBMS's do for a living |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-14 : 15:53:46
|
quote:
Originally posted by xhostx
Hi Thanks you too.This is what I just did: I downloaded the just .mdf. Romoved the log file from the list which show autimatically while you are trying to attache the DW. This will avoid triggering an an error. Click OK. then the log file will be automatically created.--------------------------Joins are what RDBMS's do for a living
yep...that should be fine------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Business Intelligence/Analytics small project