Viewing 15 posts - 2,056 through 2,070 (of 2,462 total)
is time out coming frequently or any particular time ?
it means there might be chances that another process(example jobs/backup) running behind the scene
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 19, 2010 at 9:01 am
vmssanthosh (3/19/2010)
But you do not have to be rude like this.. you could have just ignored his post.. thats how people starts here... At the start itself no body answers...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 19, 2010 at 6:22 am
NO, it will give only those engineerid and engineername which are not present in table2
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 19, 2010 at 6:11 am
chandrasekaran.ganapathy (3/19/2010)
select Distinct(EngineerId),EngineerName from Table1where EngineerId not in (select (EngineerId) from Table2)
this query will exclude all the records/engineerid which are present in table2.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 19, 2010 at 5:52 am
there is no duplicate values and secondly is this from table A or table B ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 19, 2010 at 5:36 am
chandrasekaran.ganapathy (3/19/2010)
Why it is not retrieving EngineerName?
it should . can you post some sample data where this query is failing ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 19, 2010 at 5:20 am
Sorry, I thought that the link might help you, as you can script out the users and apply them after having data refresh.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 19, 2010 at 4:28 am
chandrasekaran.ganapathy (3/19/2010)
Can you just give me some idea how to use if not exists or any other scenario?
Try thisdeclare @t table ( EngineerId int )
insert into @t
select 1
union select...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 19, 2010 at 4:16 am
Srikanth ,
can you post your script which is used in job, i guess it needs some modification
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 19, 2010 at 3:51 am
Read below post
http://support.microsoft.com/kb/246133
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 19, 2010 at 3:44 am
Go to Object Explorer details (press F7) >> click JOBs folder >> select all jobs >> right click create script for jobs
OR
Use SSIS package
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 19, 2010 at 3:38 am
Paul White (3/17/2010) Rebuilding an index offline acquires and holds a schema-modification lock.
why index offline holds a schema-modification lock ? please explain
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 17, 2010 at 6:35 am
another post with related problem http://www.sqlservercentral.com/Forums/Topic881805-360-1.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 17, 2010 at 5:50 am
where substring(dprtweekday, datepart(weekday, dprtdte), 1) = '1')t1
for this code Sql optimizer doesnt use index seek/clustered seek.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 17, 2010 at 5:40 am
SELECT batch_execution_id,
other_column_padding
FROM #TableX
WHERE batch_execution_id = '99641F25-0FA8-4651-819B-E2DEC05D5113'
GO
-- Same SELECT, but using a variable
DECLARE @execid NVARCHAR(50)
SET ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 17, 2010 at 5:20 am
Viewing 15 posts - 2,056 through 2,070 (of 2,462 total)