Viewing 15 posts - 826 through 840 (of 2,462 total)
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'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 15, 2012 at 2:59 am
Post the execution plan here , so that people can have more clear view to help you
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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?
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 12, 2012 at 1:53 am
shohelr2003 (11/12/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 12, 2012 at 12:58 am
Langston Montgomery (11/11/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 12, 2012 at 12:51 am
vinu512 (11/11/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 12, 2012 at 12:30 am
naga.rohitkumar (11/11/2012)
if u can suggest technical advices rather than genral things its will be nice, and Its happens in everyonces life
see these links
http://support.microsoft.com/kb/298475
http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 11, 2012 at 11:12 pm
Viewing 15 posts - 826 through 840 (of 2,462 total)