Viewing 15 posts - 226 through 240 (of 1,109 total)
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
April 21, 2008 at 7:02 am
karthikeyan (4/21/2008)
But Andras i dont want to use any functions. Because i dont have the permission to create functions.
That makes it more tricky 🙂 Before trying to find a T-SQL...
April 21, 2008 at 6:03 am
Mahesh Bote (4/21/2008)
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...
April 21, 2008 at 5:39 am
vipul (4/19/2008)
April 21, 2008 at 5:09 am
On http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67997 there is a function that removes these characters.
Regards,
Andras
April 21, 2008 at 4:54 am
Mahesh Bote (4/21/2008)
Ripal Patel (4/21/2008)
Dear ,AllCity_Master table having Primary key City_ID,
still how to get Serial No.
I think you haven't been through the URL given to you. You would have been...
April 21, 2008 at 4:47 am
Your query is rather interesting, particularly the
sum(gross_written_premium + ( SELECT [month],
...
April 18, 2008 at 6:47 am
govind.sharma (4/18/2008)
because it work fine...
April 18, 2008 at 6:42 am
govind.sharma (4/18/2008)
Problem is still remainingit think it should not worked because The Then Column Datatype is Char not NChar
That is the second part of the problem (sorry I missed...
April 18, 2008 at 6:17 am
robinp (4/18/2008)
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?...
April 18, 2008 at 6:05 am
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,
...
April 18, 2008 at 6:00 am
PatrickSimons (4/18/2008)
Found a script that works using DBCC OUTPUTBUFFER
This is indeed a very nice solution, but it comest at a rather high cost (not only it is not 100% reliable,...
April 18, 2008 at 5:17 am
Michael Earl (4/17/2008)
This DROPS a database - which is a single action on...
April 18, 2008 at 4:07 am
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....
April 18, 2008 at 3:01 am
Jonathan Mallia (4/18/2008)
Thanks a lot for your reply Andras.Therefore, if I understood BOL well, setting the transaction level to READ UNCOMMITTED would do it?
Unfortunately no. READ UNCOMMITTED behaves the...
April 18, 2008 at 1:52 am
Viewing 15 posts - 226 through 240 (of 1,109 total)