a clustered index on this column would result in slow inserts and updates coz the day comes first in the var char column and every time a day is repeated...

http://www.sqlservercentral.com/articles/T-SQL/67624/

Heres and article on how to perfrom fast rowcounts

Am suprised no one has suggested using a table datatype or a table variable yet

SELECT dbo.Product.Id, dbo.ProductStock.AvgCostPrice

FROM dbo.Product

LEFT OUTER JOIN dbo.ProductStock ON dbo.Product.Id = dbo.ProductStock.ProductId

WHERE dbo.Product.Family = '0001' AND dbo.Product.Number = '043001'

Allow me to...

My point was that you should use a left outer join when trying to look up from tables that may not have a value for (dbo.ProductStock.BranchId = 13)

A per processor license works for most Small businesses. Besides reporting should be hosted on a different server altogether in the long run. Trying to fit OLTP and reporting and...

SELECT dbo.Product.Id, dbo.ProductStock.AvgCostPrice

FROM dbo.Product

LEFT OUTER JOIN dbo.ProductStock ON dbo.Product.Id = dbo.ProductStock.ProductId

WHERE dbo.Product.Family = '0001' AND dbo.Product.Number = '043001'

When inserting the data , are u performing an ordered insert or do you have a clustered index performing sort operations?

the above post has already been discussed below

http://www.sqlservercentral.com/Forums/Topic531822-360-1.aspx

http://msdn.microsoft.com/en-us/library/ms189858.aspx

whats wrong with BIDS ( business intelligence developement studio ) its a GUI which allows creation and modification of SSAS cubes.

I guess the best way to do this would be to copy the backup on a disk and send the disk to the secondary location.

Mainly coz its simpler and...

Why not database mirroring ? its a high availability solution with automatic fail over ? i think it would work better for you than having to manually fail over...

There needs to be more details to answer your question, here is an example of what a dim table looks like and a fact table looks like.

A dim table such...

Click Start --> Run ---> Services.msc ---> Look for any service which start with SQL Server .

If you don't have any services it means u have not installed SQL you...

So in short you want to schedule a SSIS package as part of SQL Agent job ?

Assuming the package was created on a different machine from which it needs to...

Varchar(8000) truncates data after 8000 bytes , Varchar (max) allows you to store data up to 2 GB.