Viewing 15 posts - 1,651 through 1,665 (of 2,462 total)
i found error if i put "paul" repetitively
declare @t table ( name nvarchar(30), num int)
insert into @t
select 'paul1', 10 union
select 'paul2', 5 union
select...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 28, 2010 at 7:48 am
three permissions categories
1. sysadmin
2.sql agent login
3.proxy account
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 28, 2010 at 7:29 am
sanketahir1985 (5/27/2010)
it worked
what changes have you made ? please share with us
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 28, 2010 at 1:21 am
At server/databae level , no idea about that additionally didnt that issues resolve from that link ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 27, 2010 at 3:32 am
check why following SPID creating dealock use sp_who2 for it
SELECT distinct spid
FROM ::fn_trace_gettable('C:\Documents and Settings\bkumar\Desktop\TraceAllDeadLocks\TraceAllDeadLocks.trc',0)
where textdata like '%deadlock%'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 27, 2010 at 1:45 am
S-322532 (5/26/2010)
i need the tax to be shown in a separate row.
A bit starnge requirement , anyways for that you need to put some lookup table which will store different...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 27, 2010 at 12:05 am
try this
declare @t table (amt int, p int)
insert into @t select 40000, 10 union select 4000, 30
select amt , p , ((amt*p)/100 + amt) as total from @t
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 26, 2010 at 8:03 am
See if this can help you http://support.microsoft.com/?scid=kb;en-us;310426&x=12&y=11
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 26, 2010 at 7:56 am
Few findings
1. There is no sargable clause/filter which leads to SCAN.
2.
select A.emp_code
from TBL_EMP_MST A...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 26, 2010 at 7:40 am
Another approach
SET statistics profile on
exec SP
SET statistics profile off
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 26, 2010 at 7:23 am
sharon.bender (5/24/2010)
EXEC master.dbo.xp_cmdshell '"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe" /DTS "\MSDB\PayrollWeeklyFileExport" /SERVER NEMO /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E'
Check whether you have required access or not ? additionally can...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 25, 2010 at 12:31 am
Neepa (5/24/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 25, 2010 at 12:19 am
i dont know about the sequence but few other operations are also got performed here like
@sql variable assignment.
excecution of dynamic sql , displaying results , different type of...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 24, 2010 at 8:05 am
Daniel Wood (5/20/2010)
I cannot see what benefit this clustered index would it not be better to add the index on a more unique field.
here it is non uniue clus index...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 24, 2010 at 7:21 am
Viewing 15 posts - 1,651 through 1,665 (of 2,462 total)