I remember seeing in a banking oriented DWH a fact_daily_balance...

yes... yes... yes... 😀 either way you need a way to know to which database to point which means that "load processes" have to set a flag in some...

Microsoft really doesn't care how you acquired your knowledge, you have to prove nothing - register for the test, take it, pass it, be happy forever after... better saying until...

jflynn-735049 (1/19/2012)

---

We have a large project that is using many stored procedures. The project uses multiple database so a stored procedure may call tables in another database. The issue...

Lets be clear... Does the very same query, with the very same predicate, with the very same filtering/access parameters, against the very same database/set-of-tables sometimes returns in seconds and sometimes...

SQLKnowItAll (1/19/2012)

---

Ok, I guess I could have figured that out on my own 🙂 What about other recommendations? i.e. Wait for 2012, or just upgrade to it later? e-learning, book,...

mulukenn (1/19/2012)

---

I have a large dimension, with approximately 60,000 records and a growth rate of 1600 a day (put another way, there will be around 1600 changes everyday). Would it...

Please check "certification path roadmaps" on link next: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

...or checking the documentation http://msdn.microsoft.com/en-us/library/ms189822.aspx

May we ask...

lcasey 67763 (1/19/2012)

---

Ok I should have searched before I posted. I see these are frowned upon. I didn't realise they were acutal exams. I thought they were...

anthony.green (1/19/2012)

---

running dbcc loginfo gave 32768 results, that I noticed that the log was set to grow in 1MB chunks so thats been changed to 8000MB.

whats the easiest way to...

sdruid71 (1/17/2012)

---

Is there any value to partitioning a field that is frequently used in joins?

For ex.

Select * from table1

inner join table2 on table1.ID=table2.ID

where table2.mydate>=<date>

In the example above, I realize that...

Close but not exactly what it does, if we define the function as max(expression) then the max() function returns the maximum value...

At first sight a 100 Gig T-Log for a 600 Gig Data Warehouse sounds a little excesive... how much data is ETLed in a daily basis against that DWH?

More important......