i think you are thinking other way around , PK provide clustred index by default , so while thinking abt PK you should think abt uniqueness of records. then next...

:Wow:

I've been eyeballing for a good hour now. Even tried tilting my head an closing one eye for a...

@Koen Verbeeck

Mooi man! Good job! Nice read!

Ahhh, the dreaded but expected "Depends". :hehe:

How does one find duplicate statistics?

I've got a basic start.

SELECT OBJECT_NAME(S.[OBJECT_ID]), S.Name, SC.*

FROM Sys.Stats S

JOIN sys.Stats_Columns SC

ON S.Stats_ID = SC.Stats_ID

AND S.[Object_ID] = SC.[Object_ID]

JOIN sys.Columns C

ON...

Thanks for replying.

So having so many statistics on a table with (36 cols) is normal or at least not unusual?

No bloat or overhead involved?

As for the PK, one of the...

Have you searched at all yourself?

Try googling "SQL migrate 2000 dts to SSIS"

Wow Sean,

10 points for effort and patience!

You don't have to specify an age and you can execute the job immediately.

I just tried it. Took about 5 mins. 😛

A task for each type.

Are the phyical file locations the same?

TempDB and user DBs on different spindles?

RAID and disks all ok?

Does your QA enviroment have other instances or DBs sharing the resources?

We'll be making the move to 2012 and availibility groups sometime next year. Hopefully i'll get a 2012 dev environment well before crunch time.

Thanks for your input! 🙂

Hi Grant,

Thanks for taking the time to share!!

Have you ever had to restore a published DB? Did/would you generate the scripts (Via the GUI) for the publications just prior to...

Third Sleeve

Your statement says that you want to enter data into 3 columns, but you are only providing data for 2 columns.

Because you are using an IDENTITY, then you don't need...