Its basically created a concatenated string of column names as 1 row instead of multiple rows.

This may also help in understanding the query,

http://stackoverflow.com/questions/451415/simulating-group-concat-mysql-function-in-ms-sql-server-2005

Well something needed that space, if you dont know what then I would recommend tracing the server, but if it only happens once in a blue moon then unless you...

If you have such a big log after 30 minutes, then change it to 15 minutes.

You can shrink the log in full recovery, but you will have to wait until...

I would recommend reading this http://www.sqlservercentral.com/articles/Administration/64582/ before you do anything.

If the log file jumped to that size, it was for a reason and would probably do it again.

As detailed already,...

Do you have any weekend processes like rebuild, reorganise indexes etc?

What is the autogrowth setting of the DB in question?

Do you keep a record of the space used on a...

Full backups do not do anything to the transaction log. Only a transaction log backup can mark the log as re-usable.

How often is the log backup taking place?

duplicate post, and from other posts comments seems like homework.

Have you checked out the Microsoft Learning site?

The only way I can think of off the top of my head if you dont want to use subscriptions, is to build your dynamic proc and format it in...

Drop and recreate the index, would be the quickest solution.

This is standard behavour, the log will become larger than what you are used to as it is not marking the log as re-usable until a log backup occurs.

How often...

Have you checked with your mail administrators that you can actually send to an outside domain?

Hi

Please can you post DDL, sample data and expected outcomes so that we can help you out further.

The second link in my signature will help if you get stuck.

Thanks

Something like this

with cte

as

(

select

car.vinno,

car.model_id,

--sales_bill.billno,

--record.recordno,

max(areaofsales.zone_id) as Zone

from

car

inner join

sales_bill

on

car.model_id = sales_bill.model_id

inner join

record

on

sales_bill.billno = record.billno

inner join

areaofsales

on

record.recordno = areaofsales.recordno

group by

car.vinno,

car.model_id

),

cte2 as

(

SELECT

ROW_NUMBER() OVER(PARTITION BY model_id ORDER BY Vinno) AS RowNum, Vinno, model_id, Zone

FROM

CTE

)

SELECT

Vinno, model_id,...

Dont you just need to do an order by vinno asc or zone_id desc

edit, didnt test with sample data, not just an order by needed