Oh, okay... this is almost starting to sound like an episode of Intervention... "You gotta kick the cursor habit, man!! That stuff will kill you!"

I'm a recovering Access guy....

Really interesting discussion! (nearly wrote "disscussion" which almost seems appropriate!) thanks everybody for your input and examples.

just create a summary query

SELECT Booking_ID, SUM(TEU) As BookingTotal

FROM [MG_BOOKING_EQUIPMENT_REQ]

GROUP BY Booking_ID

ORDER BY Booking_ID;

If you use SSIS to do the data migration, you can change data types inside the SSIS package, and then write the data to the final table. Once you...

Not enough information. Post your Partition Scheme and Partition Function. Are you returning only the month in the Partition Function?

If the database is complicated, you may want to create views, stored procedures, and table-valued functions to return data to the users. Then you can basically hide the complexity...

JayK (12/12/2010)

---

Hi,

I have an Order_Products table which has all products for all orders in our database for the past 5 years. The Order_Products table is transactionally replicated on our reporting...

Maybe I'm stating the blatantly obvious, but if you work your way through the Microsoft book covering the exam you're taking, you'll be okay. Just brew lots of coffee...

You might want to cozy up with a good...

oh, ouch. I figured it would bring the database to its knees... should have done the math FIRST!!

Steve Jones - SSC Editor (11/15/2010)

---

One trick that might work, not sure since you havent' provided much info, is to use the "Go trick".

Have smaller cross joins, or variable ones,...

LOL... Certification exam stuff is basically a total joke, in my opinion... but I have to do it...

I just found it odd that there's a ton of stuff on HOW...

Okay, I'm stupid. When, if ever, should you truncate the log file? Or should you just move parts of it to another log file? Funny, NONE of...

Thanks for the catch Nigel... coming from baby database land (Access) where everything is pretty much in one database, this takes some getting used to!

Cool, thanks! I can wait...

Pieter