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

Jeff Moden (8/30/2010)

---

pietlinden (8/30/2010)

---

I...

I would call the...

Staff--(1,M)---Protocol

USE [SCRIDB]

GO

/****** Object: Table [dbo].[Staff] Script Date: 08/28/2010 15:54:14 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Staff](

[StaffID] [int] IDENTITY(1,1) NOT NULL,

[FirstName] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS...