You might also ask him exactly what performance gains he expects to see with multiple databases.

Your milage may vary, but this is one way to go from the integer value to the hex with colons. This was taken from a forum post by Paul...

Sorry, but I'm very dense today apparently. What are the rules for converting one to the other?

As Lowell suggested, posting the table definitions and some sample data in the form of insert statements would help. Can you replicate this behavior in other tables or...

The command you showed:

BACKUP DATABASE [DEVDB] TO DISK = N'C:\BACKUP\DEVDB_20121220_120038.bak' WITH NOFORMAT, NOINIT, NAME = N'UploadDownloadDev-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

GO

would put the backup on the SQL...

How are you executing the query? Wouldn't be directly into Excel by any chance, would it?

You could send a fixed terminating character on the end of your variable parameters and check to see if it is actually the last character in the parameter. If...

Do you have anything else in the row that might help to find duplicates? Address? Phone? DUNS number? federal tax id?

What makes a business unique?...

Also having issues with a newly upgraded Win 8 laptop. The 'active threads' link just goes away and never comes back in the new IE but still works well...

It's looking for duplicates. It will only show rows where there is more than 1 instance of the combination of columns in the 'group by'.

Just made everything at least 3 decimals. I think some of the integer math was dropping the decimals for you.

select ((26.700*((504.682+14.566)/14.730)*(520.000/(460.000+64.000))*(1.00/POWER((1.00/(0.99877-(0.00000072531*504.682*64.000)+(0.00013027*504.682))),2.000)))+(19.500*((1751.84+14.566)/14.73)*(520.000/(460.000+67.000))*(1.000/POWER((1.000/(0.99877-(0.00000072531*1751.84*67.000)+(0.00013027*1751.84))),2.000))))

gives me: 4020.733146

You might check this link (near the bottom). Hard to say if that's your real problem:

http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/77a8c381-60d3-46db-a9dd-e666b4a84a3d/

Some backup software is SQL Server aware and will actually use the native functionality under the covers. I don't know enough about the System Center product set to know....

You need both. A normal system backup, if it can copy the .mdf and .ldf database components at all, will not result in a database that is restorable. ...

Assuming that Master is a table in you DB:

USE [TrackIT]

GO

INSERT INTO [dbo].[tblTransactions]

(tblTransactions.Buyer_Initial,

tblTransactions.HeatTicketNumber,

tblTransactions.PO_Number,

tblTransactions.Transaction_Date,

tblTransactions.EndUserFirstName,

tblTransactions.EndUserLastName,

tblTransactions.EmployeeStatus,

tblTransactions.CostCenter,

tblTransactions.TermDate,

tblTransactions.License_Available,

tblTransactions.TransferFrom,

tblTransactions.TransferTo,

tblTransactions.EndUserLocation,

tblTransactions.EquipType,

tblTransactions.Quantity,

tblTransactions.Software_Description,

tblTransactions.Notes,

tblTransactions.Unit_Price,

tblTransactions.AllocationDate,

tblTransactions.Last_Renewal_Date,

tblTransactions.NextRenewalDate,

tblTransactions.LastRenewalPO,

tblTransactions.Transaction_Number)

Select

Master.Buyer_Initial,

Master.HeatTicketNumber,

Master.PO_Number,

Master.Transaction_Date,

Master.EndUserFirstName,

Master.EndUserLastName,

Master.EmployeeStatus,

Master.CostCenter,

Master.TermDate,

Master.License_Available,

Master.TransferFrom,

Master.TransferTo,

Master.EndUserLocation,

Master.EquipType,

Master.Quantity,

Master.Software_Description,

Master.Notes,

Master.Unit_Price,

Master.AllocationDate,

Master.Last_Renewal_Date,

Master.NextRenewalDate,

Master.LastRenewalPO,

Master.Transaction_Number

from [Master]

GO