You could split it that way, but I can't think of what it would gain you. What's the reasoning behind that idea?

If you want to move data from one...

The spreadsheet would allow me to build some tables. Create scripts would be better, but that could work.

Have you tried the suggestions I already gave you? What result...

It would reduce the logging a bit. Might gain a couple of seconds out...

TheSQLGuru does have a point. If you go with clustering, it's complex and easy to get wrong. Mirroring and log shipping are pretty easy to set up if...

A triangular join is generally (loosely) an inline query that references the outer query and more rows, in such a way that it has to query all/most of the outer...

declare @Alpha char(26)

select @alpha = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'

select 1

while @@rowcount > 1

;with Dupes (Row, Col5) as

(select row_number() over (partition by col5 order by col5),

col5

from dbo.MyTable)

update Dupes

set Col5 = Col5 + substring(@alpha, row-1,...

wildh (9/11/2008)

---

I would also suggest that if you are adding a date to a table you use YYYYMMDD if for no other reason than being able to view them in...

I think the usual way to do that is to attach the image as a file to the e-mail and then include an HTML reference to the attachment. I...

The Unpivot operator will do that. There are directions and examples in Books Online.

How you do that depends on the end result you want.

For example, today is 11 Sept 08. That could be represented in bigint as 20080911, or it could be...

That's only necessary if the names don't conform to the basic naming conventions. Won't solve the problem here.

To my understanding, they didn't actually perform any collisions yesterday, they just fired some particles around in a circle to make sure it was working.

Plus, if it goes wrong in...

You're missing the schema between the database name and the table. It's probably dbo.

For what you're doing, I would definitely look into either SSIS, or using a third party app like RedGate's Data Compare or ApexSQLS's Diff. Both of those apps are...

In compatibility 80, you're very specifically operating the database as if it were on SQL 2000. That's the whole point of the compatibility level.