While your at it check the datefirst parameter

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

It decides what values is returned for Monday , ( It not always 2 ) .

And most importantly start using ANSI joins

select...

There is...

$PARTITION (Transact-SQL)

Look up the above function in BOl

Analysis Services is the data warehousing capability provided in SQL Server.

The wiki above is a good start for DW in general

The below link gives details of SSAS as a data...

I think replication or DB mirroring would be a good fit in the above scenario.

However I think you would suffer significant data loss in your current model because fail over...

If the pays so good I can retire early , I would 😀 , Usually as long as I get paid in proportion to the work I do , its...

See if this helps

http://www.sqlservercentral.com/Forums/Topic18289-8-2.aspx

This is no Help but still

http://connect.microsoft.com/SQLServer/feedback/details/332566/in-configuration-manager-running-under-64-bit-os-proprty-is-set-as-no-where-it-is-installed-on-x64

http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/e83b5ded-8cda-468d-ac36-1b8c31b1073b/

You could always ask them to send you the exact hotfix if you know which one it is, I think they zip and send it

https://support.microsoft.com/contactus/emailcontact.aspx?scid=sw;en;1410

The trigger is created on [st_ppl] therefore the inserted table will look exactly like st_ppl , you need to make sure the column and data types of your destination...

you can perform full backups along with log shipping you dont need to stop log shipping in order to do this. What exactly are you trying to achieve ? ,...

The data files for just the database A105_A add upto 53 GB , could you please monitor the disk space when the rebuild happens to verify that it actually runs...

Whats the size of the DB data files now ?

Check the values for the below underlined text

/****** Object: Database [AdventureWorksDW] Script Date: 07/11/2011 13:56:20...

I was able to execute this successfully with out any errors , could you explain how your executing the query ?

declare @tablename varchar(20)

--Declared a variable to store search term

set @tablename...

There will be no data loss since in high availability mode they transactions are first committed on the mirror before they are committed on the principal