Thanks to both Lowell and ColdCoffee. Both scripts looks promising. I will test and get back.:-)

Did you try modifying and running the query that I have given?

The query I have given below is based on the input data and output given by you.

If your data...

Thanks Ninja's_RGR'us and J Livingston SQL 🙂

I did found some information about adding aggregations on data cubes in OLAP at MSDN.

http://msdn.microsoft.com/en-us/library/ms174758(v=sql.90).aspx

Does SQL Server Database Engine has any way...

I am learning a course on Data Warehousing. Any fact table in a data warehouse may be accompanied by aggregate fact tables to improve the query (group by queries)...

You can try the query below:

WITH comparisonCTE(Category, HoursActual,HoursForecast) as(

select a.Category,a.TotalHoursQTY as HoursActual,ISNULL(forecast.HoursQTY,0) as HoursForecast

from

(select Category, sum(HoursQTY) as TotalHoursQTY from Empl_Trans group by Category) a

left outer join forecast

on forecast.category=a.Category

)

select Category,...

Now the following query gives you the list of products sold along with their selling price on that day.

select details.product_name,details.sell_date,master.price from master

inner join details on master.product_name=details.product_name

and master.receive_date=details.sell_date

Tip: Try adding a...

Thank you all for your valuable help. From here on I will make sure my tlogs are backed up frequently. 🙂

Hi Pavan

I tried the query and found that the tlogs are coming successful.

I got around 45 rows with EventName="Log File Auto Grow"

1) How do you have the mirroring setup, with or without witness (async or sync mirroring)?

We are doing synchronous mirroring without witness.

The t-log size for the Database A would only...

I am able to run other commands like ping, dir etc

I am giving the exact username and password I gave at the command line.

But the confusing fact is I am...