Your log may have grown due to index rebuilding. When you checked the jobs, did you also consider the ones that rebuild your indexes?

Regards,

Andras

That makes it more tricky 🙂 Before trying to find a T-SQL...

Mahesh Bote (4/21/2008)

---

[font="Verdana"]

Thanks Andras, even this is new for me. By the way, If he will use SQL Server to check syntax, then how to handle the situation with and...

vipul (4/19/2008)

---

I wnat to create a small application like querry anlyzer in which i want to need parse the query. so any one know please tell me wich dll is...

On http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67997 there is a function that removes these characters.

Regards,

Andras

Mahesh Bote (4/21/2008)

---

[font="Verdana"]

I think you haven't been through the URL given to you. You would have been...

Your query is rather interesting, particularly the

sum(gross_written_premium + ( SELECT [month],

...

govind.sharma (4/18/2008)

---

When I Change the DataType from CHar To Nchar, Problem is Solved, but I want to Know What is the Impact of Jap_CI_AS on The Database

because it work fine...

That is the second part of the problem (sorry I missed...

robinp (4/18/2008)

---

Firstly, Forgive me.

From my understanding CTE's replace subqueries. But when working with large data sets, is it not more effecient to use temp tables and index those temporary tables?...

The query should be:

insert into Recv_info_Tmp(prod_section_c, sub_section_c, slip_no, Order_no, product_no, cusdesch_c1, cusdesch_c2 ) values ('235400', '00', '10003', 'TEST0123451', N'ZZZZKZ999999999999', '9993', '93')

Note the N prefix before the unicode string (N'ZZZZKZ999999999999')

Regards,

...

This is indeed a very nice solution, but it comest at a rather high cost (not only it is not 100% reliable,...

Michael Earl (4/17/2008)

---

I assume you Right-clicked on a database in Management studio and chose the "Delete" option in the menu.

This DROPS a database - which is a single action on...

Hi Karl,

I must admit I have not looked at your solution yet (hence not including it in my response), but I'm looking forward to playing with it for a while....

Unfortunately no. READ UNCOMMITTED behaves the...