Viewing 15 posts - 6,331 through 6,345 (of 11,678 total)
I wouldn't store those in a dimension table. These are measures (albeit calculated), not attributes. These measures are facts that you should be able to calculate from the fact table...
October 31, 2012 at 8:14 am
Check out Reporting Services Scripter:
http://www.sqldbatips.com/showarticle.asp?ID=62
It can script out everything from a given 2005/2008 environment.
After it's finished, you can look at the resulting scripts to get an idea about the VB...
October 31, 2012 at 8:07 am
Do you mean changes you made before you enabled CDC?
What kind of changes did you make?
October 31, 2012 at 12:44 am
Mark is right. You need Visual Studio 2010 to develop SSRS reports.
Either you install the full Visual Studio 2010 software and install the SSDT templates using the SQL Server setup,...
October 31, 2012 at 12:40 am
You can use a pivottable in Excel to connect to the SSAS datasource.
It works pretty much the same as the cube browser.
October 31, 2012 at 12:33 am
No.
Oracle schema roughly corresponds with SQL Server database.
http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/58ca88c0-5a23-4f52-99a1-b34d2e71d4c6
October 31, 2012 at 12:25 am
You can configure the amount of memory SQL Server can use:
Server Memory Server Configuration Options
Normally SQL Server takes only the memory that it needs, but if it does, it doesn't...
October 31, 2012 at 12:22 am
Great question! Forced me to do some research.
October 31, 2012 at 12:19 am
The spare server would certainly a better option, because fiddling around with a $2500 laptop isn't always fun 😀
Come say hi on the SQLServerDays, it's always nice to meet some...
October 30, 2012 at 6:57 am
Konstantin Reu (10/30/2012)
October 30, 2012 at 6:09 am
foxxo (10/30/2012)
The more common name is sql2008r2. Either that or he's confusing SharePoint and SQL.
If it is 2008R2, I never had any issue migrating them. Just did a...
October 30, 2012 at 6:02 am
Hi Eric,
I haven't spoken on a SQLSaturday (or SQLZaterdag), but I did on the Belgian CommunityDay (twice) and on the SQLServerDays (also in Belgium). Also did some LiveMeeting on the...
October 30, 2012 at 6:00 am
GilaMonster (10/25/2012)
samalex (10/25/2012)
GilaMonster (10/25/2012)
cppwiz (10/25/2012)
You will only have about 90 seconds per question to read, interpret and answer the question.
The exams are 3 hours long and have 30-40 questions in...
October 30, 2012 at 4:55 am
Oh yeah, Eric, you do will have to get your hands dirty with Windows Server and HyperV. Especially if you want to set-up clustering 🙂 But you'll learn a lot...
October 30, 2012 at 4:50 am
I did the 70-462 exam recently, and I have set-up the HyperV environment.
And I had as much experience as you when I first started 🙂
HyperV is included in Windows Server...
October 30, 2012 at 4:46 am
Viewing 15 posts - 6,331 through 6,345 (of 11,678 total)