Viewing 15 posts - 1,231 through 1,245 (of 2,462 total)
nadersam (10/7/2010)
Thanks
Create function [GetTableData] (@TableName varchar(50),@RowID integer)
returns table
AS
Declare @MySQL varchar(100);
Set @Mysql=...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2010 at 4:38 am
nadersam (10/7/2010)
i wanted to pass the inserted record in trigger as a table variable to stored procedure but unfortunately it seems not supported in SQL 2005 :crying:Any ideas?
Post the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2010 at 3:24 am
Nader ,
I will still stick to avoid the syscolumns/sysobjects/sysindexes kind if sys tables in your logic , they will force for unnecessary locking in TempDb.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 6, 2010 at 9:15 pm
really GOOD question..i really got my eye-brow raised while see the answer.:-D
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 6, 2010 at 12:55 am
Bhuvnesh (10/5/2010)
nadersam (10/5/2010)[hr
and another try i think you should first keep data from information_schema.columns to table variable and then use in further query
Did you try this ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 5, 2010 at 3:59 am
nadersam (10/5/2010)
also i checked the Activity Monitor tool and i see the following wait
Wait Type:LCK_M_S
Resource...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 5, 2010 at 3:29 am
nadersam (10/5/2010)
Yes, but still the locking issue which is very weird and cant find the reason for it.Regards
Nader
its time to set profiler trace
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 5, 2010 at 2:18 am
nadersam (10/5/2010)
Man this is amuch better solution , thank u very much.Nader
Did you see some improvement with it ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 5, 2010 at 1:52 am
vinothr 33504 (10/4/2010)
When the recovery model is changed from full recovery to simple recovery will the transaction be logged?
If yes where it will...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 5, 2010 at 12:45 am
AKP (10/4/2010)
Could not find stored procedure 'Test_SP'.
Are you sure these SP exist?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 4, 2010 at 9:34 pm
Two things you can try here
1) Don't create # table on fly use create approach.
2) SELECT @Field_Position = MIN(ORDINAL_POSITION) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @Table_Name AND ORDINAL_POSITION > @Field_Position;
SELECT...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 4, 2010 at 6:03 am
I would like to see the trigger definition now
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 4, 2010 at 5:42 am
nadersam (10/4/2010)
The error is:Lock request time out exceeded error:1222
Thanks
I think this article can help you.
http://support.microsoft.com/kb/308518/en-us
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 4, 2010 at 5:25 am
the derived table which contains
SELECT
COALESCE(B3.ColA, B2.ColA) AS XYZ
FROM BigTable2 B2
LEFT MERGE JOIN BigTable3 B3 ON B2.Id=B3.Id
WHERE B3.NameSearch LIKE @ClientName+'%'
OR (B3.NameSearch IS NULL AND B2.NameSearch LIKE @ClientName + '%')
Surely...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 4, 2010 at 4:32 am
urmarke (10/2/2010)
The issue hasnt been resolved but we've got a work around so its okay for now.
What kind of workaround ? any index or query adjustment ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 4, 2010 at 4:17 am
Viewing 15 posts - 1,231 through 1,245 (of 2,462 total)