check following links

http://www.microsoft.com/sql/technologies/analysis/overview.mspx

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1262093,00.html#

Check the following links

http://www.ibm.com/developerworks/web/library/wa-dbdsgn1.html

http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

If your join condition matches with the index fields the query will also performs faster.

It is not the index that imporve the performance. You should look out...

select datediff(dd,sdate,edate)from table where datediff(dd,sdate,edate) =365

where sdate is startdate and edate date enddate

You can use ERWIN.

Open query analyzer. Go to Query and select Result to file.... and

during execution, it will prompt a file name....

As your data stores in the format of YYYY-MM-DD

In case of format 101 is will return MM/DD/YYYY

In case of format 103 is will return DD/MM/YYYY

So in case of 103 the...

In SQL Server Management Studio, highlight SQL Server Agent -> Start. Highlight Job ->New Job…, name it , myJob.

Under Steps, New Step, name it, Step1,

Type: SQL Server Integration Service...

You need to shrink your transaction logs on production

You may also need to set the recovery model of your database to Simple before you shrink your database if it's not...

Yes you can restore.

Checked in forums - Control Panel-My Posts?. My post were existing from the begining (for the last 5 years)

Joining is worth with hoping for the best. If one some thing went wrong there will be always oppertunties to jump.

You need to pass PK dayOfHits datetime with time aslo. This will resolve your problem.

Do you mean that you do not want to have entry for deleted record in the log?

You can use grant on object name to role member