Viewing 15 posts - 826 through 840 (of 2,463 total)
Lavanyasri (11/15/2012)
I don't want the error message generated by that job failure . I want only the job name with the failure alert ........
you can use dbo.sysjobhistory ...
November 15, 2012 at 3:28 am
Yes see this query can give you more then one record here . look into this query
select B.ICP
from [R33HypInfa].[dbo].[DF012_Look_up_hfm] A,[R33HypInfa].[dbo].[DF012_HFM_Staging]B
Where A.Account=B.Account AND A.Icp='VS001'
November 15, 2012 at 3:01 am
Dave-644455 (11/14/2012)
However partitioning on this Identity column wouldn't be very useful.
Why you think that partitioning wouldnt be useful here ? i think it will help you here as you...
November 15, 2012 at 2:59 am
Post the execution plan here , so that people can have more clear view to help you
November 15, 2012 at 2:53 am
poratips (11/13/2012)
We are planning to make this as much as much production kind of so we can do all kind of testing.
try to clone as much as of prod...
November 15, 2012 at 12:09 am
SQLSACT (11/10/2012)
A non-unique Clustered index has a 4byte uniquifier column added to into to make it unique, does SQL Server do the same for every non-unique Nonclustered index you create?
...
November 12, 2012 at 2:22 am
a new login will have different SID from the existing user "appp" So to
Re-maps that user to new login by changing the user's Security Identifier (SID) to match the...
November 12, 2012 at 2:07 am
sqlfriends (11/9/2012)
Is it a common thing to reseed a table in data warehouse or dbs or any othe reasons?
this is/should not be a common practice to reseed the...
November 12, 2012 at 2:01 am
Koen Verbeeck (11/12/2012)
Jason-299789 (11/12/2012)
So the simplest way to do this is a Single Update (I'm guessing at the join and update column as they are missing in your code, but...
November 12, 2012 at 1:53 am
shohelr2003 (11/12/2012)
November 12, 2012 at 1:48 am
rukhsar1101 (11/10/2012)
i am tryn to learn sql server to get a job first later i will go for certificatn
pls reffer me a book which can heelp...
November 12, 2012 at 12:58 am
Langston Montgomery (11/11/2012)
November 12, 2012 at 12:51 am
vinu512 (11/11/2012)
November 12, 2012 at 12:38 am
shohelr2003 (11/11/2012)
Hence I want to shrink my transaction log file. Can you tell me the ideal size to which log file can be shrinked?
why you want to shrink it...
November 12, 2012 at 12:32 am
sumith1andonly1 (11/12/2012)
Insertion and updation may occur in parallel.
How come ?
What there must be inserted (new records ) on which updation will be done.
if latency can be affordable...
November 12, 2012 at 12:30 am
Viewing 15 posts - 826 through 840 (of 2,463 total)